Tired of clicking around in Excel? Wish there was a faster way to copy data, apply formulas, or move between sheets?
Good news — there is. With Excel keyboard shortcuts, you can save hours every week.
This post lists 100 essential Excel shortcuts, organized by category — so whether you’re a beginner or a power user, you’ll find something to level up your Excel game.
Let’s dive in and transform you into an Excel ninja. 🥷
📌 Why Use Excel Shortcuts?
⏱️ Save time on repetitive tasks
🖐️ Work mouse-free for faster navigation
🧠 Boost productivity and efficiency
💼 Looks pro during presentations or office work
🧮 Great for data analysts, accountants, students, and anyone using Excel daily
✅ 100 Most Useful Excel Shortcut Keys (Windows)
🔹 Basic Excel Shortcuts
Action
Shortcut
Copy
Ctrl + C
Paste
Ctrl + V
Cut
Ctrl + X
Undo
Ctrl + Z
Redo
Ctrl + Y
Save
Ctrl + S
Open Workbook
Ctrl + O
New Workbook
Ctrl + N
Print
Ctrl + P
Close Workbook
Ctrl + W
🔹 Navigation Shortcuts | 100 Excel Shortcut Keys
Action
Shortcut
Move to Beginning of Row
Home
Move to Beginning of Sheet
Ctrl + Home
Move to End of Data
Ctrl + End
Move One Screen Down
Page Down
Move One Screen Up
Page Up
Move Right
Tab
Move Left
Shift + Tab
Move Between Worksheets
Ctrl + Page Up / Page Down
Jump Between Open Workbooks
Ctrl + Tab
🔹 Cell Selection Shortcuts
Action
Shortcut
Select Entire Row
Shift + Space
Select Entire Column
Ctrl + Space
Select Entire Worksheet
Ctrl + A
Extend Selection Down
Shift + Down Arrow
Extend Selection Right
Shift + Right Arrow
Select Non-Adjacent Cells
Ctrl + Click
🔹 Data Entry Shortcuts
Action
Shortcut
Insert Current Date
Ctrl + ;
Insert Current Time
Ctrl + Shift + ;
Fill Down
Ctrl + D
Fill Right
Ctrl + R
Start a New Line in Cell
Alt + Enter
Repeat Last Action
F4
🔹 Formula Shortcuts
Action
Shortcut
Insert Function
Shift + F3
Toggle Absolute/Relative Reference
F4
Calculate Active Worksheet
Shift + F9
Show Formulas
Ctrl + `
AutoSum
Alt + =
Insert Name
F3
🔹 Formatting Shortcuts
Action
Shortcut
Bold
Ctrl + B
Italic
Ctrl + I
Underline
Ctrl + U
Format Cells
Ctrl + 1
Add Border
Ctrl + Shift + &
Remove Border
Ctrl + Shift + _
Center Align
Alt + H + A + C
Format as Percentage
Ctrl + Shift + %
Format as Currency
Ctrl + Shift + $
Format as Number
Ctrl + Shift + !
🔹 Table and Row Management
Action
Shortcut
Insert Row
Ctrl + Shift + +
Delete Row
Ctrl + –
Insert Hyperlink
Ctrl + K
Group Rows or Columns
Alt + Shift + →
Ungroup Rows or Columns
Alt + Shift + ←
🔹 Pivot Table Shortcuts
Action
Shortcut
Create Pivot Table
Alt + N + V
Refresh Pivot Table
Alt + F5
Group Data
Alt + Shift + →
Ungroup Data
Alt + Shift + ←
Move to Field List
Ctrl + Shift + F
🔹 Charts and Graphics | 100 Excel Shortcut Keys
Action
Shortcut
Create Chart from Data
Alt + F1
Insert New Chart
F11
Select Chart Element
Arrow Keys
Format Chart
Ctrl + 1
🔹 Filter & Sort
Action
Shortcut
Apply Filter
Ctrl + Shift + L
Sort Ascending
Alt + A + S + A
Sort Descending
Alt + A + S + D
Clear Filter
Alt + A + C
🔹 Miscellaneous
Action
Shortcut
Open Excel Options
Alt + F + T
Run Spelling Check
F7
Open Name Manager
Ctrl + F3
Zoom In/Out
Ctrl + Mouse Scroll
Help
F1
⚡ Pro Tip: Create Your Own Shortcuts
Did you know you can customize your own Excel shortcuts using macros or the Quick Access Toolbar?
Go to:
File → Options → Quick Access Toolbar → Add popular actions for instant keyboard access. (100 Excel Shortcut Keys)
Whether you’re just starting or already working in Excel daily, keyboard shortcuts are the secret weapon of every Excel power user. Learn a few each week, and before you know it, you’ll be flying through spreadsheets with speed and confidence.
Don’t forget to bookmark this page for quick reference. ✅
