50 Must-Know Excel Shortcuts

50 must know excel shortcuts

If you work in Excel frequently, there’s a secret that separates fast analysts from everyone else:

Speed in Excel doesn’t come from more features — it comes from smarter workflows.

Excel is packed with keyboard shortcuts that collapse multi-click actions into a single move. Over time, those seconds compound into minutes, then hours, then full workdays regained throughout the year.

Below is a curated list of 50 must-know Excel shortcuts, organized by category, so you can learn the ones that matter most for day-to-day work.

1. Editing Basics (The Foundation of Speed)

These are the shortcuts every power user starts with:

ActionShortcut
CopyCtrl + C
CutCtrl + X
PasteCtrl + V
Paste SpecialCtrl + Alt + V
Delete Cell ValuesDelete

2. Essential Functions (Do Math Instantly)

Forget typing =SUM(...) by hand every time — Excel has quick insertion shortcuts:

FunctionShortcut
AutoSumAlt + =
Insert AVERAGEAlt, H, U, A
Insert COUNTAlt, H, U, C
Insert MAXAlt, H, U, X
Insert MINAlt, H, U, N

3. Formatting Numbers (Turn Data Into Meaning)

Analysts format constantly — currency, decimals, percent, etc.

FormatShortcut
CurrencyCtrl + Shift + 4
PercentCtrl + Shift + 5
DateCtrl + Shift + 3
TimeCtrl + Shift + 2
General (Text)Ctrl + Shift + ~
Number FormatCtrl + Shift + 1
AccountingAlt, H, K
ScientificCtrl + Shift + 6
Increase DecimalsAlt, H, 0
Decrease DecimalsAlt, H, 9
Conditional FormattingAlt, H, L

These are heavily used in finance, FP&A, modeling, and data cleaning workflows.

4. Font Styling (Make Sheets Readable)

Most people click the ribbon for these — but you don’t have to:

ActionShortcut
BoldCtrl + B
ItalicCtrl + I
UnderlineCtrl + U
StrikethroughCtrl + 5
Increase Font SizeCtrl + Shift + >
Decrease Font SizeCtrl + Shift + <
SuperscriptAlt, H, F, N, E
SubscriptAlt, H, F, N, B

5. Selection & Structural Editing

These are massively underrated. They eliminate mouse dragging:

ActionShortcut
Select ColumnCtrl + Space
Select RowShift + Space
Insert RowCtrl + Shift + +
Insert ColumnCtrl + Shift + +
Delete RowCtrl + – (after Shift+Space)
Delete ColumnCtrl + – (after Ctrl+Space)
Hide RowsCtrl + 9
Hide ColumnsCtrl + 0
Unhide RowsCtrl + Shift + 9
Unhide ColumnsAlt, H, O, U, L

If you build tables, reports, or do modeling — these are gold.

6. Alignment & Display

These improve readability and make sheets presentation-ready:

ActionShortcut
Center AlignAlt, H, A, C
Left AlignAlt, H, A, L
Right AlignAlt, H, A, R
Top AlignAlt, H, A, T
Middle AlignAlt, H, A, M
Bottom AlignAlt, H, A, B
Wrap TextAlt, H, W
Merge & CenterAlt, H, M, C
UnmergeAlt, H, M, U
Increase IndentAlt, H, 6
Decrease IndentAlt, H, 5

7. Borders & Layout

ActionShortcut
All BordersAlt, H, B, A
Outside BordersAlt, H, B, S
Autofit RowAlt, H, O, A
Autofit ColumnAlt, H, O, I

8. Tables, Filters, & Data Ops

These accelerate data exploration:

ActionShortcut
Add TableCtrl + T
FilterCtrl + Shift + L
Remove DuplicatesAlt, A, M
Data ValidationAlt, A, V, V
Consolidate DataAlt, A, N
SortAlt, H, S, S/O

9. Pivot Tables & Analysis

Pivot tables are a world of their own:

ActionShortcut
Insert PivotAlt + N + V + T
Refresh PivotAlt, J, T, F, A

10. Navigation & Visibility

These save hours when moving around sheets:

ActionShortcut
Go ToCtrl + G
Show FormulasCtrl + ~
Toggle GridlinesAlt, W, V, G
Freeze PanesAlt, W, F, F
Name ManagerCtrl + F3
Goal SeekAlt + A, W, G

If You Want to Actually Learn These…

Knowing shortcuts is one thing. Remembering to use them while you work is the hard part.

That’s exactly why I built Excel Shortcut Coach — a Windows app that teaches shortcuts in real time based on your actions, without forcing you into courses or flashcards.

Instead of learning abstractly, you learn in your actual workflow. Get it now HERE