All Shortcut Keys of Microsoft Excel
📂 1. File Management Shortcuts
| Shortcut Key | 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 |
✂️ 2. Editing Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + A | Select All |
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Delete | Clear cell contents |
| Backspace | Delete left character |
🔤 3. Formatting Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 1 | Format Cells dialog |
| Ctrl + Shift + & | Apply border |
| Ctrl + Shift + _ | Remove border |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + % | Percentage format |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + @ | Time format |
| Ctrl + Shift + ! | Number format |
| Ctrl + Shift + ^ | Scientific format |
📐 4. Alignment Shortcuts
| Shortcut Key | Function |
|---|
| Alt + H + A + L | Align Left |
| Alt + H + A + C | Center Align |
| Alt + H + A + R | Align Right |
| Alt + H + A + T | Top Align |
| Alt + H + A + M | Middle Align |
| Alt + H + A + B | Bottom Align |
| Alt + H + W | Wrap Text |
🔢 5. Rows & Columns Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + Space | Select Column |
| Shift + Space | Select Row |
| Ctrl + + | Insert row/column |
| Ctrl + – | Delete row/column |
| Alt + H + O + I | AutoFit Column Width |
| Alt + H + O + A | AutoFit Row Height |
🧭 6. Navigation Shortcuts
| Shortcut Key | Function |
|---|
| Arrow Keys | Move one cell |
| Ctrl + Arrow Key | Jump to data edge |
| Home | Beginning of row |
| Ctrl + Home | Beginning of worksheet |
| Ctrl + End | Last used cell |
| Page Up / Page Down | Move one screen |
🧮 7. Formula & Function Shortcuts
| Shortcut Key | Function |
|---|
| = | Start formula |
| Alt + = | AutoSum |
| F2 | Edit active cell |
| Ctrl + ` | Show/Hide formulas |
| Shift + F3 | Insert Function |
| F4 | Toggle absolute/relative reference |
| Ctrl + Shift + Enter | Array formula (older Excel) |
📊 8. Chart & Data Shortcuts
| Shortcut Key | Function |
|---|
| Alt + F1 | Insert chart in same sheet |
| F11 | Insert chart in new sheet |
| Ctrl + Shift + L | Apply/Remove Filter |
| Alt + A + S + S | Sort Ascending |
| Alt + A + S + D | Sort Descending |
🔄 9. PivotTable Shortcuts
| Shortcut Key | Function |
|---|
| Ctrl + P | Print Preview |
| Alt + P + O | Page Orientation |
| Alt + P + S | Page Size |
| Alt + P + M | Margins |
| Alt + P + R | Print Titles |
🖨️ 10. Printing & Page Setup
| Shortcut Key | Function |
|---|
| Ctrl + P | Print Preview |
| Alt + P + O | Page Orientation |
| Alt + P + S | Page Size |
| Alt + P + M | Margins |
| Alt + P + R | Print Titles |
🔐 11. Protection & Review Shortcuts
| Shortcut Key | Function |
|---|
| Alt + R + P + S | Protect Sheet |
| Alt + R + P + W | Protect Workbook |
| Ctrl + Alt + M | New Comment |
| F7 | Spell Check |
⭐ 12. Most Important (Exam + Office)
Ctrl + N, Ctrl + O, Ctrl + S, Ctrl + P
Ctrl + C, Ctrl + X, Ctrl + V
Ctrl + 1, Alt + =, F2, F4
Ctrl + Shift + L, Alt + F1
🎯 Quick Tip for Students
👉 Practice shortcuts daily while working in Excel.
👉 Using shortcuts increases speed, accuracy, and confidence in exams and office work.
| All Courses | View List | Enroll Now |
| Mock Tests/Quizzes All Courses | Mock Tests/Quizzes |
| Student Registration | Register Now |
| Become an Instructor | Apply Now |
| Dashboard | Click Here |
| Student Zone | Click Here |
| Our Team | Meet Members |
| Contact Us | Get in Touch |
| About Us | Read More |
| Knowledge Base | Click Here |
| Classes/Batches: Class 6th to 12th, BA, B.Sc, B.Com (All Subjects) — Online & Offline Available | Click Here |
Exam Preparation: SSC, Railway, Police, Banking, TET, UPTET, CTET, and More
| Click Here |
| Shree Narayan Computers & Education Center | Home Page |
Post Views: 22
