🔥 100 Excel Shortcut Keys You Should Know (Boost Your Speed Like a Pro!)
100 Excel Shortcut Keys
Table of Contents
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
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
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.
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. ✅
