Formatiing Shortcuts
Bold CTRL+B
Italic CTRL+I
Underline CTRL+U
Format Box CTRL+1
COPY CTRL+C
PASTE CTRL+V
Paste Only Format ALT+E+S+T
Paste Only Formulas ALT+E+S+F
Paste Only Values ALT+E+S+V
CUT CTRL+X
REPEAT CTRL+Y
Undo CTRL+Z
Delete Cell Contents Delete
Delete all Cell Attributes ALT+H+E+A
Delete Cell Comment ALT+H+E+M
Outline Border SHIFT+CTRL+&
Remove Border SHIFT+CTRL+_
Insert a comment SHIFT+F2
Tab navigation
Move/ Copy a tab ALT + H + O + M
Change tab name ALT + H + O + R
Moving to left/right tabs CTRL + Pg Up/Down
New tab SHIFT + F11
Insert worksheet ALT + I + W
Row / column shortcuts
Select column CTRL + Space
Select row Shift + Space
Delete row(s) / column(s) CTRL + 'minus sign'
Add row(s) / column(s) CTRL + SHIFT + 'plus sign'
Group / ungroup rows and column SHIFT + ALT + left / right arrow key
Delete Fit column width ALT + H + O + I
Data editing shortcuts
Select All CTRL + A
Fill Down CTRL + D
Fill right CTRL + R
Find CTRL + F
Replace CTRL + H
Flash Fill CTRL + E
Edit cells F2
Start a formula = (equal sign)
Insert AutoSum formula ALT + “+“ (hold down ALT)
Workbook navigation shortcuts Replace
Toggle Excel workbooks CTRL + TAB
Split Screen ALT + W + S (F6 to jump from pane to pane)
Freeze pane ALT + W + F + F
New workbook CTRL + N
Print CTRL + P
Open workbook CTRL + O (CTRL + F12)
Save workbook CTRL + S
Activate menu bar ALT or F10
Min / Restore Ribbon CTRL + F1
Print preview CTRL F2
Close window CTRL + F4
Close program ALT + F4
Cell navigation shortcuts
Go to end of contiguous range CTRL + Arrow keys
Select a cell range SHIFT + Arrow keys
Highlight contiguous range SHIFT + CTRL + Arrow keys
Move to beginning of line Home
Move to cell “A1” CTRL + Home
Move to cell above SHIFT + ENTER
Move to cell to the right TAB
Move to cell to the left SHIFT + TAB
Delete cell and get inside BACKSPACE
Delete cell/selection DELETE
Show formulas/values CTRL + ~
Fill selection w/ entry CTRL + Enter
Bold CTRL+B
Italic CTRL+I
Underline CTRL+U
Format Box CTRL+1
COPY CTRL+C
PASTE CTRL+V
Paste Only Format ALT+E+S+T
Paste Only Formulas ALT+E+S+F
Paste Only Values ALT+E+S+V
CUT CTRL+X
REPEAT CTRL+Y
Undo CTRL+Z
Delete Cell Contents Delete
Delete all Cell Attributes ALT+H+E+A
Delete Cell Comment ALT+H+E+M
Outline Border SHIFT+CTRL+&
Remove Border SHIFT+CTRL+_
Insert a comment SHIFT+F2
Tab navigation
Move/ Copy a tab ALT + H + O + M
Change tab name ALT + H + O + R
Moving to left/right tabs CTRL + Pg Up/Down
New tab SHIFT + F11
Insert worksheet ALT + I + W
Row / column shortcuts
Select column CTRL + Space
Select row Shift + Space
Delete row(s) / column(s) CTRL + 'minus sign'
Add row(s) / column(s) CTRL + SHIFT + 'plus sign'
Group / ungroup rows and column SHIFT + ALT + left / right arrow key
Delete Fit column width ALT + H + O + I
Data editing shortcuts
Select All CTRL + A
Fill Down CTRL + D
Fill right CTRL + R
Find CTRL + F
Replace CTRL + H
Flash Fill CTRL + E
Edit cells F2
Start a formula = (equal sign)
Insert AutoSum formula ALT + “+“ (hold down ALT)
Workbook navigation shortcuts Replace
Toggle Excel workbooks CTRL + TAB
Split Screen ALT + W + S (F6 to jump from pane to pane)
Freeze pane ALT + W + F + F
New workbook CTRL + N
Print CTRL + P
Open workbook CTRL + O (CTRL + F12)
Save workbook CTRL + S
Activate menu bar ALT or F10
Min / Restore Ribbon CTRL + F1
Print preview CTRL F2
Close window CTRL + F4
Close program ALT + F4
Cell navigation shortcuts
Go to end of contiguous range CTRL + Arrow keys
Select a cell range SHIFT + Arrow keys
Highlight contiguous range SHIFT + CTRL + Arrow keys
Move to beginning of line Home
Move to cell “A1” CTRL + Home
Move to cell above SHIFT + ENTER
Move to cell to the right TAB
Move to cell to the left SHIFT + TAB
Delete cell and get inside BACKSPACE
Delete cell/selection DELETE
Show formulas/values CTRL + ~
Fill selection w/ entry CTRL + Enter
No comments:
Post a Comment