Microsoft ®

Excel 2000

Desk Reference Card

www.johnhinds.com

It begins here.

[Address] [Phone]

The Excel 2000 Screen

Keyboard Shortcuts

Title Bar – Allows quick information on the application and file name
Menu Bar – Provides access to every feature embedded in Excel
Standard Toolbar – Access to frequently used standard actions
Formatting Toolbar – Access to frequently used formatting actions
Rows – Groups of values that travel across a worksheet
Columns – Groups of values that travel down a worksheet

Copy
Cut
Paste
Bold
Italics
Underline
Undo
Redo
Print
Find/Replace
Date Stamp
Time Stamp
Show Formulas
Help
Repeat Last Action
Spell Check
Automatic Chart
New worksheet
Save As
Home Cell
End Cell
Surf Forwards
Surf Backwards
Add Rows to Cell

Ctrl + C
Ctrl + X
Ctrl + V
Ctrl + B
Ctrl + I
Ctrl + U
Ctrl + Z
Ctrl + Y
Ctrl + P
Ctrl + F
Ctrl + ;
Ctrl + :
Ctrl + `
F1
F4
F7
F11
Shift + F11
F12
Ctrl + Home
Ctrl + End
Tab
Shift + Tab
Alt + Enter

The Standard Tool Bar

New – Open a new document	Are Icons Suddenly Missing? Some computers are set to customize the standard and formatting tool bars by promoting the icons you use frequently and demoting the icons you rarely use. To disable this feature, simply right click on one of the two toolbars, fins the customize option and deselect the top two checkboxes on the option tab of the dialog box. Are Icons Suddenly Inactive? Icons will become inactive when working on portions of a document that does not make use of a particular feature. If you know that the feature is normally available, try clicking on a blank area of your document to make sure nothing is selected. Most of the time this simple step reactivates the icon.
Open – Open a file from the hard drive or server
Save – Save file in active window
Print – Print file in active window
Print Preview – View file prior to printing
Spell Check – Check spelling and grammar
Cut – Copy & remove text once item is pasted
Copy – Copy text and enables the paste feature
Paste – Place copied text to a new location
Format Painter – Copy format, paste elsewhere
Undo – Reverses the last action taken
Redo – Re-executes the last undone transaction
Insert Hyperlink – Connect files to each other or the web
AutoSum –Quickly add numeric data in columns or rows
Paste Function – Use advanced functions without formulas
Sort Ascending - Sort column data in descending order
Sort Descending – Sort column data in descending order
Chart Wizard – Create dynamic charts with ease
Drawing – Add the drawing toolbar to bottom of screen
Zoom – View more or less of any active spreadsheet
Help – Answer questions, learn new skills
More Buttons – Missing something? Look here!