WORD
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
Close a file CTRL+W
Save As F12
Save CTRL+S or SHIFT+F12
Print Preview CTRL+F2
Print CTRL+P
Show/Hide paragraph symbols CTRL+*
Spelling and grammar F7
Help F1
Find CTRL+F
Replace CTRL+H
Go To CTRL+G
Cursor movement
Select all - entire document CTRL+A
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
FORMATTING
Cut CTRL+X
Copy CTRL+C
Paste CTRL+V
Undo CTRL+Z
Redo CTRL+Y
Format painter CTRL+SHIFT+C
Left alignment CTRL+L
Center alignment CTRL+E
Right alignment CTRL+R
Justified CTRL+J
Delete previous word CTRL+Backspace
Apply bulleted list CTRL+SHIFT+L
Indent CTRL+M
Page break CTRL+Enter
TEXT STYLE
Font face CTRL+SHIFT+F
Font size CTRL+SHIFT+P
Bold CTRL+B
Italics CTRL+I
Underline CTRL+U
Double underline CTRL+SHIFT+D
Word underline CTRL+SHIFT+W
All caps CTRL+SHIFT+A
Change case SHIFT+F3
Subscript CTRL+=
Superscript CTRL+SHIFT+=
Make web hyperlink CTRL+K
TABLES
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
MISCELLENOUS
Copyright symbol - © ALT+CTRL+C
Date field ALT+SHIFT+D
Go to footnotes ALT+CTRL+F
Show/Hide ¶ CTRL+SHIFT+8
Thesaurus SHIFT+F7
EXCEL KEYBOARD SHORTCUTS
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
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

No comments:
Post a Comment