ADVERTISEMENT
Top Most Useful Shortcuts In Excel | Shortcut Keys
Excel shortcuts key is a time-saving technique that increases productivity. Learn the most useful Excel keyboard shortcuts to boost your efficiency.
Formatting Shortcuts
Excel Shortcuts | Description |
|---|---|
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
Excel Shortcuts | Description |
|---|---|
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 |
CTRL Shortcuts
Excel Shortcuts | Description |
|---|---|
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 |
Navigation Shortcuts
Excel Shortcuts | Description |
|---|---|
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 Begin of the Line |
CTRL + Home | Go to Cell A1 |
ESC | Cancel |
Alt + Enter (when in a cell) | Add a Line |
Columns & Rows Shortcuts
Excel Shortcuts | Description |
|---|---|
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 |
Top Most Useful Shortcuts In Excel