HOME | SITEMAP | COMMENTS

Uncle Jim's Web Designs
Development Tools for the Internet and Your Computer


Microsoft Excel Tutorial

 

 
Page Properties Keyboard Shortcuts 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.
(A plus sign indicates that the keys need to be pressed at the same time.)

ActionKeystroke

Document actions
Open a fileCTRL+O
New fileCTRL+N
Save AsF12
SaveCTRL+S
PrintCTRL+P
FindCTRL+F
ReplaceCTRL+H
Go toF5

Cursor Movement
One cell upup arrow
One cell downdown arrow
One cell rightTab
One cell leftSHIFT+Tab
Top of worksheet (cell A1)CTRL+Home
End of worksheet
(last cell with data)
CTRL+End
End of rowHome
End of columnCTRL+left arrow
Move to next worksheetCTRL+PageDown

Formulas
Apply AutoSumALT+=
Current dateCTRL+;
Current timeCTRL+:
SpellingF7
HelpF1
MacrosALT+F8
ActionKeystroke

Selecting Cells
All cells left of current cellSHIFT+left arrow
All cells right of current cellSHIFT+right arrow
Entire columnCTRL+Spacebar
Entire rowSHIFT+Spacebar
Entire worksheetCTRL+A

Text Style
BoldCTRL+B
ItalicsCTRL+I
UnderlineCTRL+U
StrikethroughCTRL+5

Formatting
Edit active cellF2
Format as currency with 2 decimal places SHIFT+CTRL+$
Format as percent with no decimal placesSHIFT+CTRL+%
CutCTRL+X
CopyCTRL+C
PasteCTRL+V
UndoCTRL+Z
RedoCTRL+Y
Format cells dialog boxCTRL+1

Page Properties Keyboard Shortcuts Tutorial menu