🔹 Basic Excel Shortcuts
Ctrl + N → New workbook
Ctrl + O → Open file
Ctrl + S → Save
Ctrl + P → Print
Ctrl + W → Close workbook
🔹 Navigation Shortcuts
Arrow Keys → Move one cell
Ctrl + Arrow Key → Jump to last data cell
Ctrl + Home → Go to A1 (start)
Ctrl + End → Go to last used cell
Page Up / Page Down → Move one screen
👉 Example from your file:
Ctrl + Home quickly takes you to the top of the sheet
🔹 Selection Shortcuts
Shift + Arrow Key → Select cells
Ctrl + A → Select all
Ctrl + Shift + Arrow Key → Select large data range
🔹 Editing Shortcuts
Ctrl + C → Copy
Ctrl + X → Cut
Ctrl + V → Paste
Ctrl + Z → Undo
Ctrl + Y → Redo
🔹 Formatting Shortcuts
Ctrl + B → Bold
Ctrl + I → Italic
Ctrl + U → Underline
Ctrl + 1 → Format cells
🔹 Important Advanced Shortcuts
Ctrl + Alt + V → Paste Special
(Used for transpose, values only, etc.)
Ctrl + Shift + Enter → Array formula
(Used for advanced formulas like TRANSPOSE)
Alt + H + V + S → Paste Special (menu way)
🔹 Sheet Control
Shift + F11 → New sheet
Ctrl + Page Up → Previous sheet
Ctrl + Page Down → Next sheet
MICROSOFT EXCEL SHORTCUT KEYS (TOP 150)
🔹 BASIC SHORTCUTS
Ctrl + N – New workbook
Ctrl + O – Open file
Ctrl + S – Save
F12 – Save As
Ctrl + P – Print
Ctrl + W – Close workbook
Alt + F4 – Exit Excel
Ctrl + F – Find
Ctrl + H – Replace
Ctrl + A – Select all
🔹 NAVIGATION SHORTCUTS
Arrow Keys – Move one cell
Ctrl + Arrow – Jump to data edge
Ctrl + Home – Go to A1
Ctrl + End – Last used cell
Page Up / Down – Move screen
Ctrl + Page Up – Previous sheet
Ctrl + Page Down – Next sheet
🔹 SELECTION SHORTCUTS
Shift + Arrow – Select cells
Ctrl + Shift + Arrow – Select data range
Ctrl + Space – Select column
Shift + Space – Select row
Ctrl + Shift + * – Select data region
🔹 EDITING SHORTCUTS
Ctrl + C – Copy
Ctrl + X – Cut
Ctrl + V – Paste
Ctrl + Alt + V – Paste Special
Ctrl + Z – Undo
Ctrl + Y – Redo
F2 – Edit cell
Alt + Enter – New line in cell
🔹 FORMATTING SHORTCUTS
Ctrl + B – Bold
Ctrl + I – Italic
Ctrl + U – Underline
Ctrl + 1 – Format cells
Ctrl + Shift + $ – Currency
Ctrl + Shift + % – Percentage
🔹 FORMULA SHORTCUTS
= – Start formula
Alt + = – AutoSum
F4 – Lock cell reference
Ctrl + ` – Show formulas
Shift + F3 – Insert function
Ctrl + Shift + Enter – Array formula
🔹 ROW & COLUMN SHORTCUTS
Ctrl + Shift + + – Insert row/column
Ctrl + – – Delete row/column
Ctrl + 9 – Hide row
Ctrl + Shift + 9 – Unhide row
Ctrl + 0 – Hide column
Ctrl + Shift + 0 – Unhide column
🔹 ADVANCED SHORTCUTS
Alt + F1 – Create chart
F11 – Chart in new sheet
Ctrl + T – Create table
Ctrl + Shift + L – Apply filter
Alt + H + O + I – Auto-fit column
🎯 EXAM TIPS
• Focus on Ctrl, Shift, Alt combinations
• Practice daily
• Remember Navigation + Formula shortcuts
💡 PRO TIP
Use Ctrl + Alt + V (Paste Special) and
Ctrl + Shift + Enter (Array formula) for advanced Excel tasks.
🔥 F1 TO F12 KEYS IN EXCEL
🔹 F1 – Help
👉 Opens Excel Help window
📌 Use when you need guidance on any feature
🔹 F2 – Edit Cell
👉 Edits the active cell
📌 Very important for exams
🔹 F3 – Paste Name
👉 Pastes defined names (ranges) into formulas
🔹 F4 – Repeat / Lock Reference
👉 Repeats last action
👉 In formulas: Locks cell reference ($A$1)
🔹 F5 – Go To
👉 Opens “Go To” dialog box
📌 Quickly jump to any cell (e.g., A1000)
🔹 F6 – Switch Panels
👉 Moves between worksheet, ribbon, task pane
🔹 F7 – Spelling Check
👉 Checks spelling in worksheet
🔹 F8 – Extend Selection
👉 Turns ON selection mode (extend selection with arrows)
🔹 F9 – Calculate
👉 Recalculates formulas
🔹 F10 – Activate Menu Bar
👉 Activates ribbon shortcuts (same as Alt key)
🔹 F11 – Create Chart
👉 Creates chart instantly from selected data
🔹 F12 – Save As
👉 Opens “Save As” window
🎯 Important Combinations (Very Useful)
- Shift + F2 → Insert/Edit comment
- Shift + F3 → Insert function
- Shift + F10 → Right-click menu
- Shift + F11 → New worksheet
- Ctrl + F2 → Print preview
- Ctrl + F9 → Minimize workbook
- Alt + F4 → Close Excel
💡 Quick Memory Trick
- F1–F5 → Basic actions (Help, Edit, Go To)
- F6–F10 → Navigation & tools
- F11–F12 → Output (Chart & Save)
🎯 Practice Task
- Open Excel
- Type any data
-
Try:
- Press F2 (edit)
- Press F5 (go to A10)
-
Press F11 (create chart)
I can’t directly attach a downloadable PDF here, but I’ll give you ready-to-use PDF notes format 📄
👉 You can copy this into Word / Google Docs → Save as PDF (very easy)📘 EXCEL SHORTCUT KEYS – PDF NOTES
MICROSOFT EXCEL SHORTCUT KEYS (TOP 150)
🔹 BASIC SHORTCUTS
Ctrl + N – New workbook
Ctrl + O – Open file
Ctrl + S – Save
F12 – Save As
Ctrl + P – Print
Ctrl + W – Close workbook
Alt + F4 – Exit Excel
Ctrl + F – Find
Ctrl + H – Replace
Ctrl + A – Select all🔹 NAVIGATION SHORTCUTS
Arrow Keys – Move one cell
Ctrl + Arrow – Jump to data edge
Ctrl + Home – Go to A1
Ctrl + End – Last used cell
Page Up / Down – Move screen
Ctrl + Page Up – Previous sheet
Ctrl + Page Down – Next sheet🔹 SELECTION SHORTCUTS
Shift + Arrow – Select cells
Ctrl + Shift + Arrow – Select data range
Ctrl + Space – Select column
Shift + Space – Select row
Ctrl + Shift + * – Select data region🔹 EDITING SHORTCUTS
Ctrl + C – Copy
Ctrl + X – Cut
Ctrl + V – Paste
Ctrl + Alt + V – Paste Special
Ctrl + Z – Undo
Ctrl + Y – Redo
F2 – Edit cell
Alt + Enter – New line in cell🔹 FORMATTING SHORTCUTS
Ctrl + B – Bold
Ctrl + I – Italic
Ctrl + U – Underline
Ctrl + 1 – Format cells
Ctrl + Shift + $ – Currency
Ctrl + Shift + % – Percentage🔹 FORMULA SHORTCUTS
= – Start formula
Alt + = – AutoSum
F4 – Lock cell reference
Ctrl + ` – Show formulas
Shift + F3 – Insert function
Ctrl + Shift + Enter – Array formula🔹 ROW & COLUMN SHORTCUTS
Ctrl + Shift + + – Insert row/column
Ctrl + – – Delete row/column
Ctrl + 9 – Hide row
Ctrl + Shift + 9 – Unhide row
Ctrl + 0 – Hide column
Ctrl + Shift + 0 – Unhide column🔹 ADVANCED SHORTCUTS
Alt + F1 – Create chart
F11 – Chart in new sheet
Ctrl + T – Create table
Ctrl + Shift + L – Apply filter
Alt + H + O + I – Auto-fit column🎯 EXAM TIPS
• Focus on Ctrl, Shift, Alt combinations
• Practice daily
• Remember Navigation + Formula shortcuts💡 PRO TIP
Use Ctrl + Alt + V (Paste Special) and
Ctrl + Shift + Enter (Array formula) for advanced Excel tasks.✅ How to convert into PDF
Copy the above notes
Paste into MS Word / Google Docs
Click File → Save As → PDF
No comments:
Post a Comment