The Home Ribbon in Excel 2007

The Home Ribbon, the very first of the standard ribbons, consist mainly of functions that are available to you when you select Format or Edit in the Menu bar.

Here is a detailed coverage of the ribbon:

screenshot_home ribbon

It is used primarily for formating cells similar to the functions you find when you click on Menu -> Format, Menu -> edit in the previous version or when you click on the right mouse button within the worksheet, in Excel 2007 and previous version of Excel. See below for get a better picture of how the Home Ribbon is organised:/P>

Copy and pasting cells

screenshot_home ribbon_clipboard

Font formating

screenshot_home ribbon_font_formating

Text alignment

screenshot_home ribbon_text_alignment

Number formating

screenshot_home ribbon_number_format


The style group contains 3 elements which are usually neglected by the average users.

Conditional formating - to automatically format the cell(s) to a different color when certain conditions are met.

Format Table - to format the data in your worksheet into a table

Style - to capture and store cell format settings so that it could be re-used by other cells or ranges. This function is similar to MS Word style formating (e.g. HEADING 1, normal, etc).

screenshot_home ribbon_style

Insert/Delete/Format Cells/Columns

screenshot_home ribbon_cell_format

And finally


Summation button to generate a simple sum, average, count, max or min formula.

Activate the fill series function.

Clear the cell contents

Sort and filter the list

Find, select, goto and goto special functions

screenshot_home ribbon_editing_data_list Lesson 01: Why learn Excel 2007?
Lesson 02: A new look for Excel 2007 and access the "file menu"
Lesson 03: No more toolbar in Excel 2007
Lesson 04: What are on the Ribbons in Excel 2007
Lesson 05: 7 Standard Ribbons in Excel 2007

New! Comments

Have your say about what you just read! Leave me a comment in the box below.