Excel 2007 user interface – the Home Tab

The Home tab

The home tab in Excel 2007 ribbon is divided into 7 groups, or sections, presented in a toolbar:

1. Clipboard : contains the main edit commands: Cut, Copy and Paste plus the Format painter. The Paste command can be expanded by clicking on the arrow below it to give a submenu which is basically a Paste Special options.

2. Font: Options for font type, size, color, border .. etc.

3. Alignment: Text vertical and horizontal alignment, indentation, text wrapping… etc.

4. Number: Number formatting e.g. Number, Date, accounting. Also decimals, comma style and percentage.

5. Styles: Allows you to specify Conditional formatting by defining formatting rules. You can also format a selected cell by selecting one of the built in formatting styles or you can define a range as a table, and give it one of the predefined styles, or further more you can define your own style.

6. Cells: Allows you to Insert, delete or format, not only cells but also whole columns, rows or sheets. Formatting also includes renaming, hiding or protecting.

7. Editing: Mainly for formulas, sorting, filtering, find and replace.

Note:

Click on the arrow below or next to each option to reveal more options.

Posts on Excel 2007 user interface:

1. Introduction
2. The Home tab
3. The Insert tab
4. The Page Layout tab
5. The Formulas tab
6. The Data Tab
7. The Review Tab
8. The View Tab
9. The Developer Tab

Applies to : Excel 2007

Related posts:

1. How to format a cell based on the value of another cell (conditional formatting)
2. How to change Excel default font
3. How to format a cell based on its value (conditional formatting)