Excel Shortcut Keys
Mastering Excel shortcut keys can significantly boost your productivity, allowing you to work faster without relying on the mouse. Whether you're navigating worksheets, formatting cells, or performing calculations, these shortcuts will help you work more efficiently.
1️⃣ Basic Navigation Shortcuts
🚀 These shortcuts help you move quickly within a worksheet.
| Shortcut | Action |
|---|---|
| Arrow Keys | Move one cell up, down, left, or right |
| Ctrl + Arrow Key | Jump to the last filled cell in a column/row |
| Ctrl + Home | Move to the first cell (A1) in the worksheet |
| Ctrl + End | Move to the last used cell in the worksheet |
| Page Up / Page Down | Move up/down one screen |
| Alt + Page Up / Page Down | Move left/right one screen |
2️⃣ Selecting Data Quickly
🚀 Speed up your data selection process.
| Shortcut | Action |
|---|---|
| Shift + Arrow Key | Select one cell in the direction of the arrow |
| Ctrl + Shift + Arrow Key | Select from the current cell to the last filled cell |
| Ctrl + A | Select the entire worksheet |
| Ctrl + Space | Select the entire column |
| Shift + Space | Select the entire row |
| Ctrl + Shift + Space | Select the entire data set |
3️⃣ Data Entry and Editing
🚀 Make data input and editing more efficient.
| Shortcut | Action |
|---|---|
| F2 | Edit the active cell |
| Ctrl + Enter | Fill the selected range with the entered value |
| Alt + Enter | Insert a new line inside a cell |
| Ctrl + D | Copy data from the cell above |
| Ctrl + R | Copy data from the cell on the left |
| Ctrl + ; | Insert today's date |
| Ctrl + Shift + ; | Insert the current time |
4️⃣ Formatting Shortcuts
🚀 Quickly format your data for better presentation.
| Shortcut | Action |
|---|---|
| Ctrl + B | Bold text |
| Ctrl + I | Italicize text |
| Ctrl + U | Underline text |
| Ctrl + 1 | Open the Format Cells dialog box |
| Ctrl + Shift + $ | Apply currency format |
| Ctrl + Shift + % | Apply percentage format |
| Ctrl + Shift + # | Apply date format |
| Ctrl + Shift + @ | Apply time format |
| Ctrl + Shift + ^ | Apply exponential number format |
5️⃣ Working with Formulas
🚀 Speed up calculations and formula handling.
| Shortcut | Action |
|---|---|
| = (Equal Sign) | Start a formula |
| F4 | Toggle absolute and relative references (e.g., A1 → $A$1) |
| Ctrl + ` (Grave Accent) | Show or hide formulas |
| Alt + = | AutoSum the selected range |
| Ctrl + Shift + Enter | Enter an array formula (Excel 2019 and earlier) |
| F9 | Evaluate a selected part of a formula |
| Ctrl + ' (Apostrophe) | Copy the formula from the cell above |
6️⃣ Managing Worksheets
🚀 Navigate and organize worksheets efficiently.
| Shortcut | Action |
|---|---|
| Ctrl + N | Create a new workbook |
| Ctrl + S | Save the workbook |
| Ctrl + P | Open the Print dialog box |
| Ctrl + F | Find data in the worksheet |
| Ctrl + H | Find and replace |
| Ctrl + Tab | Switch between open workbooks |
| Ctrl + Page Up / Page Down | Move to the next/previous worksheet |
| Alt + H + O + R | Rename the active worksheet |
| Shift + F11 | Insert a new worksheet |
7️⃣ Managing Rows and Columns
🚀 Organize your data efficiently.
| Shortcut | Action |
|---|---|
| Ctrl + Shift + + | Insert a new row or column |
| Ctrl + - | Delete the selected row or column |
| Ctrl + 9 | Hide selected rows |
| Ctrl + Shift + 9 | Unhide hidden rows |
| Ctrl + 0 | Hide selected columns |
| Ctrl + Shift + 0 | Unhide hidden columns |
8️⃣ Copying, Pasting, and Special Actions
🚀 Work faster with copying and pasting.
| Shortcut | Action |
|---|---|
| Ctrl + C | Copy selected data |
| Ctrl + X | Cut selected data |
| Ctrl + V | Paste data |
| Ctrl + Alt + V | Open Paste Special dialog box |
| Ctrl + Shift + V | Paste formatting only |
| Ctrl + Z | Undo last action |
| Ctrl + Y | Redo last undone action |
9️⃣ Pivot Tables and Charts
🚀 Create reports quickly with these shortcuts.
| Shortcut | Action |
|---|---|
| Alt + N + V | Insert a Pivot Table |
| Alt + J + T + R | Refresh Pivot Table |
| Alt + F1 | Insert a default chart from selected data |
| F11 | Create a chart in a new sheet |
🔟 Miscellaneous Shortcuts
🚀 Other useful Excel shortcuts.
| Shortcut | Action |
|---|---|
| Esc | Cancel entry in a cell |
| F12 | Open Save As dialog box |
| Alt + H + H | Open Fill Color menu |
| Alt + H + B | Add borders to selected cells |
| Alt + Enter | Insert a line break in a cell |
| Alt + Shift + F1 | Insert a new worksheet |
📌 Conclusion
Using these 50 Excel shortcut keys, you can significantly improve your efficiency, reduce manual effort, and work faster in Excel. Practice regularly to build muscle memory and become an Excel power user! 🚀