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:

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

Font formating

Text alignment

Number formating

Styles

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).

Insert/Delete/Format Cells/Columns

And finally

Editing

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