Screen Elements Excel 2010

The image below should help you understand the main parts of the Microsoft Excel 2010 (Windows OS) window. The Excel 2010 window consists of: 1) Quick Access Toolbar 2) Tabs that make up the Ribbon 3) The Ribbon that consists of Tabs, Groups 4) the Zoom Controls 5) View Buttons 6) The Status Bar.

Excel 2010 Screen

Other than the removal of the Start Button to be replaced by the File Tab there is not been many changes to the 2010 version of Excel, with the exception of the Paste options. Excel 2010 Paste now offers more options and the new templates.

2010 Paste Options

Quick Access Toolbar

The Quick Access Toolbar appears at the top of the window next to the Office button. It includes most common commands such as Save and Undo. You can customize the toolbar by adding command buttons to it.

To add or remove a button from the Quick Access Toolbar, click the list arrow at the right end of the toolbar to display the pop-up menu. Then, click the button name from the pop-up menu list. A check next to the name tells you which function will be on the Quick Access Toolbar.

Ribbon

The Ribbon replaces menus, toolbars, and most of the task panes that were found on previous versions of Excel. The Ribbon is located at the top of the document window and consists of tabs that are organized by tasks. Each tab is organized into groups, or subtasks, such as the Font or Alignment group located on the Home tab. Each button within a group is called a command button, as shown below.

2010 Ribbon

Display and Hide Ribbon

  • In Excel 2011, to minimize the Ribbon double-click the Home tab.
  • You can also click on the down arrow as shown below.

2010 Hide Ribbon

Formula Bar

In addition to the Ribbon Excel also has a Formula Bar. The Formula Bar is located above of the workbook window and allows you to enter or edit values or formulas in cells or charts. The Formula Bar also displays the value or formula used in the active cell.

2010 Formula Bar