Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Excel 2000 Tutorial
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
 
« Page Properties and Printing Keyboard Shortcuts Excel tutorial menu »

Keyboard shortcuts can save time and the effort of switching from the keyboard to the mouse to execute simple commands. Print this list of Excel keyboard shortcuts and keep it by your computer for a quick reference.

Note: A plus sign indicates that the keys need to be pressed at the same time.

Action Keystroke

Document actions
Open a file CTRL+O
New file CTRL+N
Save As F12
Save CTRL+S
Print CTRL+P
Find CTRL+F
Replace CTRL+H
Go to F5

Cursor Movement
One cell up up arrow
One cell down down arrow
One cell right Tab
One cell left SHIFT+Tab
Top of worksheet (cell A1) CTRL+Home
End of worksheet
(last cell with data)
CTRL+End
End of row Home
End of column CTRL+left arrow
Move to next worksheet CTRL+PageDown

Formulas
Apply AutoSum ALT+=
Current date CTRL+;
Current time CTRL+:
Spelling F7
Help F1
Macros ALT+F8
Action Keystroke

Selecting Cells
All cells left of current cell SHIFT+left arrow
All cells right of current cell SHIFT+right arrow
Entire column CTRL+Spacebar
Entire row SHIFT+Spacebar
Entire worksheet CTRL+A

Text Style
Bold CTRL+B
Italics CTRL+I
Underline CTRL+U
Strikethrough CTRL+5

Formatting
Edit active cell F2
Format as currency with 2 decimal places SHIFT+CTRL+$
Format as percent with no decimal places SHIFT+CTRL+%
Cut CTRL+X
Copy CTRL+C
Paste CTRL+V
Undo CTRL+Z
Redo CTRL+Y
Format cells dialog box CTRL+1

« Page Properties and Printing Keyboard Shortcuts Excel tutorial menu »
 

Office 2000 Tutorials · Word · Excel · Power Point · Access · FrontPage

FGCU does not provide personal support for Office 2000 programs to outside parties.

 

© FGCU 2009. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory