MS Excel Short Cut Keys

 

MS Excel Keyboard Shortcuts (Complete List)

General Shortcuts

Shortcut	Function
Ctrl + N	New Workbook
Ctrl + O	Open Workbook
Ctrl + S	Save Workbook
F12	Save As
Ctrl + P	Print
Ctrl + W	Close Workbook
Alt + F4	Exit Excel
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste
Ctrl + A	Select All
Ctrl + F	Find
Ctrl + H	Replace
Ctrl + G	Go To
Ctrl + K	Insert Hyperlink

---

Cell Editing

Shortcut	Function
F2	Edit Active Cell
Enter	Move Down
Shift + Enter	Move Up
Tab	Move Right
Shift + Tab	Move Left
Ctrl + Enter	Fill Selected Cells
Alt + Enter	New Line in Cell
Delete	Clear Cell
Backspace	Edit Cell

---

Navigation

Shortcut	Function
Ctrl + Arrow	Jump to Data Edge
Home	Beginning of Row
Ctrl + Home	Cell A1
Ctrl + End	Last Used Cell
Page Up	One Screen Up
Page Down	One Screen Down
Alt + Page Up	Left One Screen
Alt + Page Down	Right One Screen

---

Row & Column

Shortcut	Function
Ctrl + Shift + +	Insert Row/Column
Ctrl + -	Delete Row/Column
Ctrl + Space	Select Column
Shift + Space	Select Row
Ctrl + Shift + Space	Select Entire Worksheet

---

Formatting

Shortcut	Function
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Ctrl + 1	Format Cells
Ctrl + Shift + ~	General Format
Ctrl + Shift + $	Currency Format
Ctrl + Shift + %	Percentage Format
Ctrl + Shift + #	Date Format
Ctrl + Shift + @	Time Format

---

Formulas

Shortcut	Function
=	Start Formula
Alt + =	AutoSum
F4	Repeat Action / Toggle Absolute Reference ($)
Shift + F3	Insert Function
Ctrl + `	Show/Hide Formulas
F9	Calculate Workbook
Shift + F9	Calculate Active Sheet

---

Selection

Shortcut	Function
Ctrl + Shift + Arrow	Select Data Range
Ctrl + A	Select All
Shift + Arrow	Extend Selection
Ctrl + Click	Select Multiple Cells

---

Worksheet

Shortcut	Function
Shift + F11	New Worksheet
Ctrl + Page Up	Previous Sheet
Ctrl + Page Down	Next Sheet
Alt + H, O, R	Rename Sheet

---

Data

Shortcut	Function
Ctrl + T	Create Table
Ctrl + Shift + L	Toggle Filter
Alt + ↓	Open Filter Menu
Ctrl + ;	Insert Current Date
Ctrl + Shift + ;	Insert Current Time

---

Charts

Shortcut	Function
Alt + F1	Create Chart
F11	Create Chart on New Sheet

---

Useful Function Keys

Key	Function
F1	Help
F2	Edit Cell
F4	Repeat Action / Absolute Reference
F5	Go To
F7	Spelling Check
F9	Calculate
F11	Create Chart
F12	Save As

---

Top 10 Most Useful Excel Shortcuts

1. Ctrl + C → Copy
2. Ctrl + V → Paste
3. Ctrl + Z → Undo
4. Ctrl + S → Save
5. F2 → Edit Cell
6. Alt + = → AutoSum
7. Ctrl + Shift + L → Apply/Remove Filter
8. Ctrl + T → Create Table
9. Ctrl + Arrow Keys → Jump to End of Data
10. Ctrl + 1 → Open Format Cells

📗 Excel Shortcut Vault