MS Excel Keyboard Flashcards
Format Box
Formatting Shortcuts
CTRL + 1
Copy Format
Formatting Shortcuts
ALT + E + S + T
Increase Decimal
Formatting Shortcuts
ALT + H + 0
Copy Format
Formatting Shortcuts
ALT + E + S + T
Decrease Decimal
Formatting Shortcuts
ALT + H + 9
Boxing
Formatting Shortcuts
CTRL + SHIFT + 7
Fit Column Width
Formatting Shortcuts
ALT + O + C + A
Change Tab Name
Formatting Shortcuts
ALT + H + O + R
(Un)Split Panes
Formatting Shortcuts
ALT + W + F
(Un)freeze windows
Formatting Shortcuts
ALT + W + S
Date Format
Formatting Shortcuts
SHIFT + CTRL + #
Dollar Format
Formatting Shortcuts
SHIFT + CTRL + $
Percentage Format
Formatting Shortcuts
SHIFT + CTRL + %
Sum Function
Formatting Shortcuts
ALT + “=”
Edit Cells
Function Key Shortcuts
F2
Anchor Cells
Function Key Shortcuts
F4
Spell Check
Function Key Shortcuts
F7
Save As
Function Key Shortcuts
F12
Insert a Comment
Function Key Shortcuts
SHIFT + F2
Add to Selection
Function Key Shortcuts
SHIFT + F8
Right Click
Function Key Shortcuts
SHIFT + F10
Name a Cell
Function Key Shortcuts
CTRL + F3
Minimize Programs
Function Key Shortcuts
Windows Flag + D
Select All
CRTL Shortucts
CTRL + A
Bold
CRTL Shortucts
CTRL + B
Copy
CRTL Shortucts
CTRL + C
Fill Down
CRTL Shortucts
CTRL + D
Find
CRTL Shortucts
CTRL + F
Italic
CRTL Shortucts
CTRL + I
New Workbook
CRTL Shortucts
CTRL + N
Open
CRTL Shortucts
CTRL + O
CRTL Shortucts
CTRL + P
Fill Right
CRTL Shortucts
CTRL + R
Save Work Book
CRTL Shortucts
CTRL + S
Underline
CRTL Shortucts
CTRL + U
Paste
CRTL Shortucts
CTRL + V
Close Window
CRTL Shortucts
CTRL + W
Cut
CRTL Shortucts
CTRL + X
Undo
CRTL Shortucts
CTRL + Z
Move
Navigation Shortcuts
Arrows
Go to End of Continuous Range
Navigation Shortcuts
CTRL + Arrows
Select A Cell Range
Navigation Shortcuts
SHIFT + Arrows
Highlight A Continuous Range
Navigation Shortcuts
CTRL + SHIFT + Arrows
Switch Programs
Navigation Shortcuts
ALT + Tab
Switch Worksheets
Navigation Shortcuts
CTRL + Pg Up/Down
Enter Move below
Navigation Shortcuts
Enter
Move Up
Navigation Shortcuts
Shift + Enter
Move to Beginning of Line
Navigation Shortcuts
Home
CTRL + Home Go to Cell A1
Navigation Shortcuts
CTRL + Home
Cancel
Navigation Shortcuts
ESC
Add a Line
Navigation Shortcuts
Alt + Enter (when in a cell)
Hide Row
Columns and Rows Shortcuts
CTRL + 9
Unhide Row
Columns and Rows Shortcuts
SHIFT + CTRL + 9
Hide Column
Columns and Rows Shortcuts
CTRL + 0
Unhide Column
Columns and Rows Shortcuts
SHIFT + CTRL + 0
Highlight Row
Columns and Rows Shortcuts
SHIFT + Spacebar
Highlight Column
Columns and Rows Shortcuts
CTRL + Spacebar
Insert Blank Cells
Columns and Rows Shortcuts
SHIFT + CTRL + Plus sign
Delete Selected Cells
Columns and Rows Shortcuts
CTRL + Minus Sign
Group Rows/Columns
Columns and Rows Shortcuts
SHIFT + ALT + Left Arrow
Ungroup Rows/Columns
Columns and Rows Shortcuts
CTRL + Spacebar