Quick Study for Excel 2000

Index

0-9

3-D references

Add

Charts

Comments

Macros to toolbar

Map button to toolbar

Password protection

Worksheets

Adjust decimal places

Apply

Borders

Shading

Styles

Assign macro to button

Auditing

Dependents

Display toolbar

Errors

Precedents

AutoCorrect

AutoFilter

AutoFit

Column widths

Row heights

AutoFormat

AutoSum

Borders, apply

Button, map

Buttons

Add to toolbars

Redo

Undo

Cells

Apply borders to

Apply shading to

AutoFormat

AutoSum

Clear formats from

Conditional formats

Copy

Custom number format in

Delete data in

Edit comments in

Edit formulas in

Enter data into

Enter formulas into

Enter references to

Fill in

Go to

Highlight

Merge

Move data between

Paint format in

Select

Set fill color of

Split

Wrap text in

Center page for printing

Change

Column widths

Defaults

Font characteristics

Font sizes

Fonts

Page orientation

Row heights

Scaling

Characteristics, font

Charts

	Create
	Modify

Check spelling

Clear cell formats

Clipboard, office

Close

	Excel
	Files
	Workbooks

Color gridlines

Columns

	Change widths of
	Freeze
	Hide
	Insert

Comments

	Add
	Edit
	Remove
	View

Conditional formats

Copy

	Cells
	Files
	Worksheets

Create

	AutoCorrect entries
	Charts
	Custom number formats
	Folders
	Footers
	Hyperlinks
	Maps
	Named ranges
	Queries
	Scenarios
	Workbooks
	Worksheet templates

Custom number formats

Data

	AutoFilter
	Delete
	Enter
	External
	External from web
	Fill in
	Filter
	Mapping
	Move
	Multi-level sort
	Query
	Single-level sort
	Validate

Database queries

Decimal place, adjust

Defaults, change

Delete

	Comments
	Data
	Files
	Names
	Worksheets

Dependents, trace

Display

	Auditing toolbar
	Drawing toolbar
	Formula palette
	Hidden worksheets
	Toolbars

Drawing toolbar, display

Edit

	Charts
	Comments
	Formulas
	Macros
	Redo
	Scenarios
	Undo

E-mail, send workbooks as

Enter

	Cell references
	Data
	Formulas

Errors, trace

Excel

	Exit
	Get help for

Exit Excel

Files

	Close
	Copy
	Delete
	Find
	Move
	Open
	Rename
	Save as HTML
	Save

Fill color, apply to cells

Fill in data

Filter data

Find

	And replace text
	Files

Folders

	Create
	Print workbooks from

Font characteristics, change

Font sizes, change

Fonts, change

Footers

Format

	Automatically
	Borders
	Column widths
	Conditional
	Custom number
	Font size
	Fonts
	Painter
	Row heights
	Styles

Formula bar

Formula palette

	Display
	Use

Formulas

	Edit
	Enter
	Paste function in
	Ranges in

Freeze rows or columns

Functions, paste

	Go to cells
	Goal seek
	Gridlines, color

Headers

Height, row

Help

	Office assistant
	What's this

Hidden worksheets

Hide

	Rows or columns
	Worksheets

Highlight cells

HTML

	Import table from
	Save as

Hyperlinks

Import

	Pictures
	Tables from HTML
	Text files

Insert

	Charts
	Comments
	Functions
	Hyperlinks
	Pictures
	Rows or columns
	WordArt
	Worksheets

	Landscape orientation
	Link worksheets

Macros

	Add to toolbar
	Edit
	Record
	Run

Map button, add to toolbar

Maps, create

Margins, page setup

Merge cells

Modify charts

Move

	Cells
	Files
	Worksheets

Multi-level sorts

Multiple workbooks, print

Names

	Create
	Delete
	Go to

Navigate

	Cells
	Worksheets

Numbers, custom formats for

Office assistant

Office clipboard

Open

	Files
	Workbooks

Options, change default

Orientation, page

Page break preview

Page margins

Page orientation, change

Page setup

	Footers
	Centering
	Headers
	Margins
	Orientation
	Scaling

Panes, freeze

Passwords

	Create
	Protect workbooks with
	Remove

Paste function

Pick from list

Pictures, import

PivotTables and PivotCharts

PivotTables on the web

Portrait orientation

Precedents, trace

Preview

	And print
	And print charts
	Page breaks

Print

	Multiple workbooks
	Preview
	Selection
	Workbooks

Print area

Protect workbooks with password

Publish PivotTables on the web

Queries

	Create
	Web

Ranges

	Named
	Use in formula

Record macros

Redo edits

References

	3-D
	Absolute and relative

Remove

	Comments
	Workbook protection

Rename

	Files
	Worksheets

Replace text

Rows

	Change heights
	Freeze
	Hide
	Insert

Run macros

Save as

	Command
	HTML
	PivotTable on web
	Worksheet template

Save workbooks

Scaling, page

Scenarios

Select

	Cells
	Page orientation
	Print area

Selection, printing

Send workbooks as e-mail

Set

	Centering
	Page margins

Set up

	Centering
	Footers
	Headers
	Headers and footers
	Margins
	Orientation
	Scaling

Shading

Share workbooks

Show

	Auditing toolbar
	Drawing toolbar
	Formula palette
	Hidden worksheets
	Toolbars

Single-level sorts

Solver

Sort

	Multi-level
	Single-level

Spelling

	Check
	Create AutoCorrect entries

Split cells

Styles

	Apply
	Format

Tables, import from HTML

Templates

	Apply
	Create from worksheet

Text files, import

Toggle the Office Assistant

Toolbar

	Display auditing
	Display drawing

Toolbars

	Add macros to
	Add Map button to
	Display

Trace

	Dependents
	Errors
	Precedents

Undo edits

Unhide worksheets

Unprotect

Use

	3-D references
	AutoFilter
	AutoFit
	AutoFormat
	AutoSum
	Conditional formats
	Format Painter
	Formula palette
	Go to
	Goal seek
	Hide
	Office Assistant
	Office clipboard
	Page break preview
	Passwords
	Paste function
	Pick from list
	PivotTable and PivotChart wizard
	Ranges in a formula
	Redo command
	Save as
	Solver
	Undo command
	Unhide
	WordArt
	WordWrap

Validate data

View

	Comments
	Gridlines
	Page break preview
	Zoom

Web

	Import table from HTML
	Publish PivotTables on
	Workbook as HTML

Width, column

WordArt

WordWrap

Workbook protection

	Create
	Remove

Workbooks

	Close
	Create
	Open
	Print
	Protect
	Save
	Send as e-mail
	Share

Worksheets

	Copy
	Create templates from
	Delete
	Display hidden
	Hide
	Insert
	Link
	Move
	Navigate
	Rename

Zoom