Tables
Action Keystroke
Go to next cell Tab
Go to previous cell SHIFT+Tab
Go to beginning of column ALT+PageUp
Highlight to beginning of column ALT+SHIFT+PageUp
Go to end of column ALT+PageDown
Highlight to end of column ALT+SHIFT+PageDown
Go to beginning of row ALT+Home
Highlight to beginning of row ALT+SHIFT+Home
Go to end of row ALT+End
Highlight to end of row ALT+SHIFT+End
Column break CTRL+SHIFT+Enter
Formatting
Action Keystroke
Select all CTRL+A
Copy CTRL+C
Cut CTRL+X
Paste CTRL+V
Undo CTRL+Z
Redo CTRL+Y
Left alignment CTRL+L
Center alignment CTRL+E
Right alignment CTRL+R
Justified CTRL+J
Indent from left CTRL+M
Decrease indent from left CTRL+SHIFT+M
Hanging indent CTRL+T
Decrease hanging indent CTRL+SHIFT+T
Page break CTRL+Enter
Promote list item ALT+SHIFT+Left arrow
Demote list item ALT+SHIFT+Right arrow or TAB
Part II: Microsoft Excel Keyboard Shortcuts
Spreadsheet Actions
Action Keystroke
Open a workbook CTRL+O
New workbook CTRL+N
Close a workbook CTRL+W
Open the Save As dialog box F12
Save a workbook CTRL+S
Print a workbook CTRL+P
Help F1
Open the Find tab of the Find and
Replace dialog box
CTRL+F
Open the Replace tab of the Find and
Replace dialog box
CTRL+H
Go to CTRL+G / F5
Quit/Exit Excel ALT+F4
Insert a new worksheet SHIFT + F11
Hide selected columns CTRL + 0
Display hidden columns CTRL + SHIFT + 0
Hide selected rows CTRL + 9
Display hidden rows CTRL + SHIFT + 9
Selecting & Navigating
Action Keystroke
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
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
Move to previous worksheet CTRL+PageUp
Cycle between open workbooks CTRL+F6
Format painter CTRL+SHIFT+C
Delete previous word CTRL+Backspace
Apply bulleted list CTRL+SHIFT+L
Style CTRL+SHIFT+S
Normal style CTRL+SHIFT+N
Cursor Movement
Action Keystroke
Select from cursor to beginning of line SHIFT+Home
Select from cursor to end of line SHIFT+End
Go to beginning of line Home
Go to end of line End
Go to beginning of document CTRL+Home
Go to end of document CTRL+End
Miscellaneous
Action Keystroke
Copyright symbol - © ALT+CTRL+C
Insert current date ALT+SHIFT+D
Insert current time ALT+SHIFT+T
Go to footnotes ALT+CTRL+F
Show/Hide ¶ CTRL+SHIFT+8
Thesaurus SHIFT+F7
Advanced – F1 to F12
Keystroke Action
F1 Help
Alt+F1 Next field
Alt+Shift+F1 Previous field
Shift+F1 ‘What is This’ Help
F2 Move text or graphic
Alt+F2 Unassigned
Alt+Shift+F2 File Save
Ctrl+F2 File Print Preview
Shift F2 Copy Text
F3 Edit AutoText
Ctrl+F3 Store in Spike
Ctrl+Shift+F3 Insert Spike and empty contents
Shift+F3 Changes case
F4 Edit Repeat frame
Alt+F4 File Exit
Ctrl+F4 File Close
Shift+F4 Repeat a Go To or Find command
F5 Edit Go To
Alt+F5 Previous application window size
Ctrl+F5 Previous document window size
Ctrl+Shift+F5 Edit bookmark
Shift+F5 Previous position
F6 Next pane
Ctrl+F6 Next window
Ctrl+Shift+F6 Previous window
Shift+F6 Previous pane
F7 Tools Spelling
Ctrl+F7 Move window
Ctrl+Shift+F7 Update link
Shift+F7 Tools Thesaurus
F8 Extend selection
Ctrl+F8 Size window
Ctrl+Shift+F8 Select column or display/hide tab and paragraph marks
Shift+F8 Shrink selection
F9 Update field
Alt+Shift+F9 Go To/Macro button fields
Ctrl+F9 Field characters
Ctrl+Shift+F9 Unlink field
Shift+F9 Switch field codes or results
F10 Menu bar
Alt+F10 Enlarge Application window
Ctrl+F10 Enlarge Document window
Shift+F10 Cut/Copy/Paste/Font/Paragraph/Bullets and Numbering menu
bar
F11 Next field
Ctrl+F11 Lock field
Ctrl+Shift+F11 Unlock field
Shift+F11 Previous field
F12 File Save As
Ctrl+F12 File Open
Ctrl+Shift+F12 File Print
Shift+F12 File Save
0 comments:
Post a Comment