Excel Interface

All spreadsheet softwares have somewhat similar user interfaces. You may see Excel’s user interface below (I’ve used Excel 2010 for this screenshot. Current version is Excel 2013. But since it is too new at the moment and UI is similar, I prefered Excel 2010 for wider accessibility):

excel_2010_interface_tn


Here are some brief information about UI elements:

Columns: Columns are named with letters (from A to XFD). Excel has 16,384 columns available in one sheet.

Rows: Rows are named with numbers (from 1 to 1,048,576). Excel has 1,048,576 rows available in one sheet.

Cells: Cells are the boxes where you input your data or calculations into. Cells are named with both column letters and row numbers (eg. A1, D32, FD8799). Excel has 17,179,869,184 available in one sheet.

Sheets: Every screen you see in Excel is called a sheet. Every sheet can hold to a maximum of rows and columns with quantities mentioned above.

Menu Ribbons:

  • File: File tab is a menu rather than a ribbon. It contains save, open, options, print menus.
  • Home: Home ribbon has all of most used items on it (mostly formatting tools). If you are using excel for simple tasks, home ribbon will likely cover all your needs.
  • Insert: Insert ribbon has everything that you may need to insert into your worksheets. You can use this ribbon to insert exel tables, pivot table, pictures, shapes, charts, links, equations, etc.
  • Page Layout: Page layout ribbon houses options to control how your worksheets looks like. Especially when it is printed. You can set themes, margins, aligning, etc. from here.
  • Formulas: Formulas ribbon houses all the functions and options for effective use of them. Open it and check how many functions are available. You are going to get suprised.
  • Data: Data ribbon includes options for data management. You can find ways of getting external data, sorting and filtering options and other data management tools in this ribbon.
  • Review: Review ribbon holds the tools for final polish for your finished work. It provides you with options for spelling check, translation and sheet protection.
  • View: View ribbon has the options to tweak apparence of your wotrksheets. You can set how you want your work screen to appaer form here.
  • Others: In addition to default ribbons, developer ribbon (needs separate activation) and some addins will be added to your ribbons when activaed.

Formula Bar: Formula Bar is located right below menu ribbons to the right. This is where you can see and edit formulas in currently selected cell.

Name Box: Name box is located right below menu ribbons to the left. This is where you see which cell/cells are currently selected. You can also name your cells or ranges by typing a name in here while the cell or range is selected.

Insert Function Button: This button is located at between name boz and formula bar. It opens insert function dialog box when clicked. From here you can select and insert functions with ease.

Quick Access Toolbar: Quick access toolbar is located on the title bar to left. You can insert shortcuts of tools you frequently use here and quickly access them. To insert shortcuts, simply click on the down arrow at the end of this toolbar.

Title Bar Menu: This is an ocassional menu that is displayed due to certain actions. When you select a chart, pivot table, picture, etc. a menu will take place of window title, pushing it to left. From this menu you can reach specific options for the item you selected.

Status Bar: Status bar is placed at the lowest portion of your excel interface. It gives you information about what is going on at any second (like Ready, Calculating,etc).

For more basic information please visit BeatExcel Beginners Page

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *