Microsoft Excel 2010 Interface

In Lesson 2 we would be exploring the Microsoft Excel 2010 Interface.

The Microsoft Excel 2010 Interface consists of 7 elements:

1. Title bar – This is the bar to the top of the Microsoft Excel Window, as seen in the diagram, below.

The title bar displays the name of the current workbook. It tells you the name of the workbook which is opened and it tells you the name of the program which is opened – which is Microsoft Excel.

An Excel Workbook is a file which consists of one or more  sheets. For instance, this Workbook which is titled ‘Book 1’ consists of 3 Sheets. You can see that at the bottom of the Excel Window. In the diagram below you have: Sheet 1, Sheet 2 and Sheet 3. You can see that at the bottom, left-hand corner of the diagram, below.

Microsoft excel window

2. Qat or quick access toolbar

Just to the far left of the title bar you have the quick access toolbar or QAT for short. This area gives you one-click access to a few often-used features or commands.

quick access toolbar


3. Ribbon

Just below the quick access toolbar we have the ribbon. Which is the entire area enclosed in the red box in the diagram, below…Stretching from left to far right.

The ribbon consists of 3 main areas – tabs, groups and commands.

We have the File tab, the Home tab, the Insert tab, the Page layout tab, the Formulas tab, the Data tab, Review and View Tabs, Developer, Acrobat and Team tabs.

Under each tab are specific groups and appropriate commands.

For instance: Just below the ‘Home Tab’ we have groups: the clipboard group, the font group, the alignment group, the number group, styles, cells and editing groups.

Each group consists of several commands associated with each group. For instance in the clipboard group we have the cut, copy, format painter and paste commands.

Under the font group we have the bold, italics, underline, fill color, font color commands, as well as, several other commands.

And it’s the same with the alignment group, the number group, the styles, cells and editing groups. They each have commands that are appropriate and associated with the specific group.



Just to the right of the title of some groups you may find a down arrow in a small box, called the dialog box launcher. This button launches dialog boxes offering additional formatting options. But we will cover this in more details in later lessons.

dialogue box launchers


4. Excel Window Controls – To the top right corner of the ribbon we have the Excel Window Controls, which are the buttons seen in the diagram below. Starting from left to right, we have the minimize button, the restore or maximize button and the close button.

excel window controls


5. Workbook Window Controls – Just below the Excel Window Controls we have the workbook window controls; see the diagram below. You can use these controls to minimize, maximize and close the current workbook window.

workbook window controls


6. WorkSheet – The large open area in the diagram, below, is the worksheet. This area displays the current worksheet and its where you would do most of your excel work.



7. Status Bar – To the bottom of your excel window – you have your status bar. That is this bar on the bottom here. This area displays messages about excel’s current status, the results of certain operations and other information.

status bar

To the far right of your status bar you have the 3 different views of Microsoft Excel – Normal page view, Page layout view and Page break preview view (we will talk more on this later, though) just to the right of these 3 views is the zoom slider. The zoom slider controls how small or large you want your worksheet to appear on your windows excel screen.

microsoft excel window 3a

For example, if you were to left click on the control button of the zoom slider,  and keep your finger on the left-button – you can drag the mouse to the left to decrease the size of your excel worksheet; and if you drag it to the mouse to the right – you would increase the size of your worksheet.

Well, This completes lesson 2.

Lesson 3: Understanding the Layout of an Excel Worksheet