Microsoft Excel 2013 Layout

Learn about Ms Excel Workbook Layout: Menubar, Formula Bar, Function Bar

Explanation

Layout defines the page view of the worksheet file. Layout of the excel is structured in the following format.

Customize Access Toolbar:
Customizable Access Toolbar is located at the top left corner of the workbook. By default, customize access toolbar have the shortcut for Save, Undo and Redo option. Click on the drop down menu near to redo to select other shortcuts.

Workbook name:
Once you open new workbook in excel, it will be created with the name "Book1 - Excel" as shown in the below image.

Title Bar Buttons:
Title bar buttons are present at the top right corner of the excel file. Buttons included in the title bar are Ribbon Display options, Minimize button, Maximize button and Close button.

Menu Bar:
Menu bar is located at the top of the workbook. It contains the following tabs like File, Home, Insert, Page layout, Formula, Data, Review and View.

Name Box:
Name box will show the cell reference of the selected cell.

Function bar:
Function bar is prefixed with the symbol "f_x". Click the symbol f_x to list all the predefined functions in ms excel 2013.

Formula Bar:
Formula bar is used to enter/edit the formulas. Formula bar displays the data entered in the active cell. All formulas starts with "=" sign.

Worksheet:
Worksheet is the collection of cells where data is entered and stored.

Footer layout:
Footer layout is present at the bottom of the workbook. You can view the page layout of the workbook using Normal, Page Layout and Page Break Preview options. You can also zoom the workbook by adjusting the pointer over the slide bar.

Related Topics