Excel is one of the most popular spreadsheet programs available today. It offers a variety of tools and features that can help you organize and analyze data quickly and efficiently. One way to save time and streamline your workflow in Excel is by using keyboard shortcuts.
Keyboard shortcuts are combinations of keys that perform specific actions in Excel. By using these shortcuts, you can navigate through your spreadsheet, enter and edit data, and perform various other tasks without ever having to touch your mouse. In this article, we will provide you with a comprehensive list of all the keyboard shortcuts available in Excel.
These are just a few of the many keyboard shortcuts available in Excel. By using these shortcuts, you can save time and increase your productivity while working with spreadsheets. Remember that many of these shortcuts can be customized, so don’t be afraid to experiment and find the shortcuts that work best for you.
| Category | Shortcut |
|---|---|
| General | |
| Create new workbook | Ctrl + N |
| Save workbook | Ctrl + S |
| Open Print menu | Ctrl + P |
| Open Excel options | Alt, F, T |
| Open right-click menu | Shift + F10 |
| Protect/unprotect workbook | Alt, R, P, W |
| Protect/unprotect worksheet | Alt, R, P, S |
| Input and Editing | |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Open Paste Special window | Ctrl + Alt + V |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Copy data and formatting from the cell above | Ctrl + D |
| Use Flash Fill | Ctrl + E |
| Insert current date | Ctrl + ; (Semicolon) |
| Insert current time | Ctrl + Shift + : (Colon) |
| Navigation and Selection | |
| Move to cell | Arrow key |
| Move to the first cell | Ctrl + Home |
| Move to the last cell of the rightmost populated column | Ctrl + End |
| Move to the first cell in the current row | Home |
| Move to the edge cell within a region | Ctrl + Arrow key |
| Move one screen up/down | Page up/down |
| Move one screen right/left | Alt + Page down/up |
| Move to the next/previous sheet | Ctrl + Page down/up |
| Select cell in chosen direction | Shift + Arrow key |
| Select one screen right/left | Shift + Alt + Page down/up |
| Select row | Shift + Space |
| Select column | Ctrl + Space |
| Select additional row/column/cell | Ctrl + Left click |
| Select entire active worksheet | Ctrl + A |
| Toggle Ribbon shortcuts | Alt |
| Navigate Ribbon sections | Alt, Arrow key |
| Open Find and Replace | Ctrl + F |
| Zoom in | Ctrl + Alt + = (Equals) |
| Zoom out | Ctrl + Alt + – (Minus) |
| Visibility and Grouping | |
| Hide row | Ctrl + 9 |
| Hide column | Ctrl + 0 |
| Open Group window | Shift + Alt + Right arrow |
| Open Ungroup window | Shift + Alt + Left arrow |
| Tables and Graphs | |
| Create table | Ctrl + T |
| Open table styles window | Alt, H, T |
| Insert row above | Alt, H, I, R |
| Insert column to left | Alt, H, I, C |
| Open PivotTable menu | Alt, N, V |
| Open PivotTable wizard | Alt, D, P |
| Formatting | |
| Open Format Cells window | Ctrl + 1 |
| Apply General number format | Ctrl + Shift + ~ (Tilde) |
| Apply Currency format | Ctrl + Shift + $ (Dollar) |
| Apply Percentage format | Ctrl + Shift + % (Percent) |
| Apply Scientific format | Ctrl + Shift + ^ (Caret) |
| Apply Date format | Ctrl + Shift + # (Hash) |
| Apply Time format | Ctrl + Shift + @ (At) |
| Apply/remove bold | Ctrl + B |
| Apply/remove italic | Ctrl + I |
| Apply left align | Alt, H, A, L |
| Apply center align | Alt, H, A, C |
| Apply right align | Alt, H, A, R |
| Adjust row height | Alt, H, O, H |
| Adjust column width | Alt, H, O, W |
| Apply bottom border | Alt, H, B, |
Combining the use of these 65 Excel keyboard shortcuts with other productivity techniques like AutoFill can help you save time and effort when working on spreadsheets. By relying less on your mouse and reducing the time spent navigating through menus, you’ll be able to complete your tasks more efficiently. Incorporating these shortcuts into your workflow can make a significant difference in your productivity and help you build spreadsheets faster and with greater ease.
