|
Window Panes &
Freezing Titles
Splitting a Window
into 2 or 4 Panes
See Widely Separated
Areas of a Spreadsheet Simultaneously
Freezing Titles
Unsplitting and
Unfreezing
View Side by Side
(version 2007 only)
Views and Cell
Comments
Full Screen Display
Setting Zoom Levels
Attaching Comments
to Cells
Editing and Deleting
Comments
Multiple Sheets
Switching From Page
To Page
Modifying Sheets
Moving and Copying
Sheets
Setting Defaults for
All Sheets
Changing the Number
of Pages
Background Picture (version 2007 only)
Advanced Page
Setup and Printing
Headers and Footers
Printing Column And
Row Titles
Page Order
Review Of Page
Breaks And Printing
Find & Replace
Finding Text,
Values, Functions
Replacing Text
Replacing Functions
|
Multiple Files
Opening Multiple
Files
Displaying Multiple
Files
Linking Cells
Between Files (not formulas)
Closing All Files
Range Names
Creating a
Range
Name
Using Range Names
For Navigation
Using Names
Already
Entered as Headings
Range Names as
Bookmarks
Filtering Range Names (version 2007 only)
Using AutoCorrect
Database Functions
Setting Up A
Database
The Current Region
Sorting Lists
Alphabetically/Numerically
Sorting by Colour/Icon
(version 2007 only)
Using AutoFilter to
Extract Information
The List Feature (version 2003 only)
Data Forms
Format as a Table (version 2007 only)
The Design Tab
Cell Styles & Themes
|