The following are some frequently used procedures in Microsoft Excel 2007.
The [bracketed] information refers to the location in previous versions.

• Create a new Blank Workbook [ formerly File – New ]

1. Click the Office Button
2. Click New
3. Click on Blank Workbook
4. Select Create at the lower right corner
   

• Save a Workbook [ formerly File – Save / Save As ]

1. Click on the Office Button
2. Select either Save or Save As
3. Save As provides additional options for saving

• Add a new Worksheet [ formerly Insert – Insert Sheet ]

1. Click the Home tab
2. Under the Cells group, click on the arrow below Insert
3. Select Insert Sheet
   

• Format Text [ formerly Format – Font ]

1. Click the Home tab
2. Highlight the text you want format
3. Select the desired Options from Font or Paragraph groups
4. Click the Dialog Box Launcher on Font or Paragraph groups for options
   

• Cut/Copy/Paste/Format Painter [ formerly Edit – Copy, Paste , Format Painter icon ]

1. Click on the Home tab
2. Under the Clipboard group, there are options for Cut, Copy, Paste and Format Painter
   

• Work with Formulas [ formerly Insert - Function ]

1. Select the data that is being used for calculation
2. Click on the Formula tab
3. Choose the desired formula from the Function Library group. Click Insert Function to display all functions.

• Work with Charts [ formerly Insert - Chart ]

1. Select the data range you wish to use to create a chart
2. Click the Insert tab
3. Select the type of chart you wish to create from the Charts group or, click the dialog box launcher to view more chart options
   

• Sort / Filter Data [ formerly Data - Filter / Sort ]

1. Select the data range you wish to sort or filter
2. Click on the Home tab
3. In the Editing group, select Sort & Filter.
4. Selecting various data types such as text, numbers, dates, etc. provides appropriate sorting options for the particular data (Sort A to Z, smallest to largest, etc.)
   

• Remove Duplicates [ formerly Data - Filter - Advanced Filter ]

1. Select the data you wish to remove duplicates from
2. Click the Data tab
3. Select Remove Duplicates from the Data Tools group
   

• Work with Headers / Footers / Gridlines [ formerly File - Page Layout ]

1. Click on the Page Layout tab
2. Select the Dialog Box Launcher on the Sheet Options group to open the Page Setup dialog box
3. The Header Footer tab provides options for headers/footers
4. The Sheet tab provides options for showing gridlines
   

• Use Spelling Checker / Thesaurus [ formerly Tools – Spelling, Thesaurus ]

1. Click on the Review tab and highlight the text you want to check
2. From the Proofing group, select any of the command icons you wish to use
   

• Freeze Panes [ formerly Window – Freeze Pane ]

1. Click on the View tab
2. Select Freeze Panes fron the Window group for various options
   

• Show / Hide Rows or Columns [ Formerly Format Row or Column - Hide / Unhide ]

To Hide:

1. Select the rows or columns that you want to hide
2. On the Home tab, in the Cells group, click Format
3. Under Visibility, point to Hide & Unhide and click either Hide Rows or Hide Columns

To Show:

1. Select either the rows above and below the rows you want to display or, select the columns adjacent to either side of the columns that you want to display
2. On the Home tab, in the Cells group, click Format
3. Under Visibility, point to Hide & Unhide and click either UnHide Rows or UnHide Columns
   

• Protect Sheet / Workbook [ formerly Format – Cells - Protection ]

1. Click on the Review tab
2. From the Changes tab, select from the options provided on Protect Sheet or Protect Workbook
   

Page Setup [ formerly File – Page Setup ]

1. Click on the Page Layout tab
2. The Page Setup group offers several selections including Margins, Orientation, Paper Size, Setting Print Area, Backgrounds and Print Titles
3. Selecting the more dialog box launcher from Page Setup offers a Page Setup dialog box similar to previous Excel versions
   

• Print / Print Preview [formerly File – Print ]

1. Click on the Office Button
2. Select Print to present the commands to Print with various printing options available or, Quick Print, or Print Preview