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

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

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

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

Using AutoFilter to Extract Information

Custom Criteria

And vs. Or

Reapplying a Filter

Format as a Table

The Design Tab

Cell Styles & Themes

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