Ms-Excel Shortcut Keys-Most Common Short Keys.
MS Excel – Most Common Shortcut Keys
Excel shortcut keys are quick keyboard combinations that let you perform commands or actions in Microsoft Excel without using the mouse.
Key points about Excel shortcut keys
Speed – They make your work much faster than navigating menus.
Convenience – No need to search through the ribbon for commands.
-
Efficiency – Great for handling large amounts of data.
-
Consistency – Most shortcuts are the same across different versions of Excel.
📂 File & Workbook Management
| Action | Shortcut |
|---|---|
| Create new workbook | Ctrl + N |
| Open workbook | Ctrl + O |
| Save workbook | Ctrl + S |
| Save As | F12 |
| Print file | Ctrl + P |
| Open Print Preview | Ctrl + F2 |
| Close current workbook | Ctrl + W |
| Close Excel | Alt + F4 |
| Open Excel Options | Alt + F, T |
| Open Help | F1 |
✏ Editing & Formatting
| Action | Shortcut |
|---|---|
| Undo last action | Ctrl + Z |
| Redo last action | Ctrl + Y |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste Special | Ctrl + Alt + V |
| Repeat last action | F4 |
| Find | Ctrl + F |
| Replace | Ctrl + H |
| Find next match | Shift + F4 |
| Find previous match | Ctrl + Shift + F4 |
📊 Data & Table Tools
| Action | Shortcut |
|---|---|
| Insert Table | Ctrl + T |
| Toggle Autofilter | Ctrl + Shift + L |
| Activate Filter | Alt + ↓ |
| Select entire row | Shift + Space |
| Select entire column | Ctrl + Space |
| Select all cells | Ctrl + A |
| Toggle Total Row (Table) | Ctrl + Shift + T |
| Clear slicer filter | Alt + C |
🧭 Navigation
| Action | Shortcut |
|---|---|
| Move one screen right | Alt + PgDn |
| Move one screen left | Alt + PgUp |
| Move one screen up | PgUp |
| Move one screen down | PgDn |
| Move to right edge of data | Ctrl + → |
| Move to left edge of data | Ctrl + ← |
| Move to top of data | Ctrl + ↑ |
| Move to bottom of data | Ctrl + ↓ |
| Go to start of row | Home |
| Go to last used cell | Ctrl + End |
| Go to first cell (A1) | Ctrl + Home |
📄 Worksheets & Panes
| Action | Shortcut |
|---|---|
| New worksheet | Shift + F11 |
| Next worksheet | Ctrl + PgDn |
| Previous worksheet | Ctrl + PgUp |
| Move to next pane | F6 |
| Move to previous pane | Shift + F6 |
| Next workbook | Ctrl + Tab |
| Previous workbook | Ctrl + Shift + Tab |
📏 Rows, Columns & Cells
| Action | Shortcut |
|---|---|
| Insert row/column | Ctrl + Shift + + |
| Delete row/column | Ctrl + – |
| Hide rows | Ctrl + 9 |
| Unhide rows | Ctrl + Shift + 9 |
| Hide columns | Ctrl + 0 |
| Unhide columns | Ctrl + Shift + 0 |
| Group rows/columns | Alt + Shift + → |
| Ungroup rows/columns | Alt + Shift + ← |
🎨 Cell Formatting
| Action | Shortcut |
|---|---|
| Align left | Alt + H, A, L |
| Align right | Alt + H, A, R |
| Increase indent | Alt + H, 6 |
| Decrease indent | Alt + H, 5 |
| Increase font size | Alt + H, F, G |
| Decrease font size | Alt + H, F, K |
| Apply general format | Ctrl + Shift + ~ |
| Apply currency format | Ctrl + Shift + $ |
| Apply percentage format | Ctrl + Shift + % |
| Apply scientific format | Ctrl + Shift + ^ |
| Apply date format | Ctrl + Shift + # |
| Apply time format | Ctrl + Shift + @ |
| Apply number format | Ctrl + Shift + ! |
0 Comments
Please comment any query