Multiple Sheets

Switching From Page To Page

Modifying Sheets & Sheet Tabs

Moving and Copying Sheets

Setting Defaults for All Sheets

Changing the Number of Pages

Format Sheet

Sheet Background

Background Picture (2007/2010 only)

Window Panes & Freezing Titles

Splitting a Window into 2 or 4 Panes

See Widely Separated Areas Simultaneously

Freezing Titles

Unsplitting and Unfreezing

View Side by Side (2007/2010 only)

Views and Cell Comments

Full Screen Display

Setting Zoom Levels

Attaching Comments to Cells

Editing, Deleting & Printing Comments

Multiple Files

Opening Multiple Files

Displaying Multiple Files

Linking Cells Between Files (not formulas)

Updating Links

Closing All Files

Setting This Equals That Links

Range Names

Creating a Range Name

Using Range Names For Navigation

Using Names Already Entered as Headings

Range Names as Bookmarks

Filtering Range Names (2007/2010 only)

Using AutoCorrect

Using Format Painter to Copy Formats

Sorting & Filtering

Setting Up A Database

The Current Region

Sorting Lists Alphabetically/Numerically

Multiple Level Sorting

Sorting by Colour/Icon (2007/2010 only)

Using AutoFilter to Extract Information

Custom Criteria

And vs. Or

Reapplying a Filter (2007/2010 only)

Format as a Table (2007/2010 only)

The Design Tab

Cell Styles & Themes

The List Feature (2003 only)

Data Forms

Find & Replace

Finding Text, Values, Functions

Replacing Text

Replacing Functions

Advanced Page Setup and Printing

Headers and Footers

Printing Column And Row Titles

Printing Gridlines
Page Order

Review Of Page Breaks And Printing