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