September 19, 2007

Microsoft Excel Shortcut Keys

Note: 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
Close a fileCTRL+W
Save AsF12
SaveCTRL+S or SHIFT+F12
Print PreviewCTRL+F2
PrintCTRL+P
Show/Hide paragraph symbolsCTRL+*
Spelling and grammarF7
HelpF1
FindCTRL+F
ReplaceCTRL+H
Go ToCTRL+G

































Cursor movement
Select all - entire documentCTRL+A
Select from cursor to beginning of lineSHIFT+Home
Select from cursor to end of lineSHIFT+END
Go to beginning of lineHOME
Go to end of lineEND
Go to beginning of documentCTRL+Home
Go to end of documentCTRL+End





























































Formatting
CutCTRL+X
CopyCTRL+C
PasteCTRL+V
UndoCTRL+Z
RedoCTRL+Y
Format painterCTRL+SHIFT+C
Left alignmentCTRL+L
Center alignmentCTRL+E
Right alignmentCTRL+R
JustifiedCTRL+J
Delete previous wordCTRL+Backspace
Apply bulleted listCTRL+SHIFT+L
IndentCTRL+M
Page breakCTRL+Enter

src=





ActionKeystroke





















































Text Style
Font faceCTRL+SHIFT+F
Font sizeCTRL+SHIFT+P
BoldCTRL+B
ItalicsCTRL+I
UnderlineCTRL+U
Double underlineCTRL+SHIFT+D
Word underlineCTRL+SHIFT+W
All capsCTRL+SHIFT+A
Change caseSHIFT+F3
SubscriptCTRL+=
SuperscriptCTRL+SHIFT+=
Make web hyperlinkCTRL+K

















































Tables
Go to next cellTab
Go to previous cellSHIFT+Tab
Go to beginning of columnALT+PageUp
Highlight to beginning of columnALT+SHIFT+PageUp
Go to end of columnALT+PageDown
Highlight to end of columnALT+SHIFT+PageDown
Go to beginning of rowALT+Home
Highlight to beginning of rowALT+SHIFT+Home
Go to end of rowALT+End
Highlight to end of rowALT+SHIFT+End
Column breakCTRL+SHIFT+Enter

























Miscellaneous
Copyright symbol - ©ALT+CTRL+C
Date fieldALT+SHIFT+D
Go to footnotesALT+CTRL+F
Show/Hide ¶CTRL+SHIFT+8
ThesaurusSHIFT+F7


EXCEL

Note: 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

src=





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 placesSHIFT+CTRL+$
Format as percent with no decimal placesSHIFT+CTRL+%
CutCTRL+X
CopyCTRL+C
PasteCTRL+V
UndoCTRL+Z
RedoCTRL+Y
Format cells dialog boxCTRL+1


POWERPOINT












ActionKeystroke





























Document actions
Open a presentationCTRL+O
New presentationCTRL+N
Save AsF12
SaveCTRL+S
PrintCTRL+P
HelpF1













































Presentation actions
Begin slide showF5
Next slideENTER or
Down arrow key
Previous slideBACKSPACE or
Up arrow key
Activate pen toolCTRL+P
Erase pen strokesE
Deactivate pen toolCTRL+A
Show/Hide black screenB
Show/Hide white screenW
Show/Hide pointer & buttonA
End slide showESC

src=





ActionKeystroke





























































Formatting
Select allCTRL+A
CopyCTRL+C
CutCTRL+X
PasteCTRL+V
UndoCTRL+Z
RedoCTRL+Y
BoldCTRL+B
ItalicsCTRL+I
UnderlineCTRL+U
Left justifiedCTRL+L
Center justifiedCTRL+E
Right justifiedCTRL+R
Promote list itemALT+SHIFT+Left arrow
Demote list itemALT+SHIFT+Right arrow or TAB





























Editing
FindCTRL+F
ReplaceCTRL+H
Insert hyperlinkCTRL+K
New slideCTRL+M
Spell checkerF7
MacrosALT+F8


Run the slide show and press the F1 key to view all keyboard shortcuts applicable when running a slide show.

ACCESS












ActionKeystroke

























































Database actions
Open existing databaseCTRL+O
Open a new databaseCTRL+N
SaveCTRL+S
Save recordSHIFT+ENTER
PrintCTRL+P
Display database windowF11
Find and ReplaceCTRL+F
CopyCTRL+C
CutCTRL+X
PasteCTRL+V
UndoCTRL+Z
HelpF1
Toggle between Form and Design viewF5





























Other
Insert line break in a memo fieldCTRL+ENTER
Insert current dateCTRL+;
Insert current timeCTRL+:
Copy data from previous recordCTRL+
Add a recordCTRL++
Delete a recordCTRL+-

-





ActionKeystroke





















































Editing
Select allCTRL+A
CopyCTRL+C
CutCTRL+X
PasteCTRL+V
UndoCTRL+Z
RedoCTRL+Y
FindCTRL+F
ReplaceCTRL+H
Spell checkerF7
Toggle between Edit mode and Navigation modeF2
Open window for editing large content fieldsSHIFT+F2
Switch from current field to current recordESC





































Navigating Through a datasheet
Next fieldTAB
Previous fieldSHIFT+TAB
First field of recordHOME
Last field of recordEND
Next recordDOWN ARROW
Previous recordUP ARROW
First field of first recordCTRL+HOME
Last field of last recordCTRL+END

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)