Tips Tricks
100 Essential Shortcut Keys in Microsoft Excel
Shortcut Keys in Microsoft Excel: Microsoft Excel is a powerful spreadsheet program that offers numerous features and capabilities to enhance productivity. One of the keys to working efficiently in Excel is knowing the right shortcut keys. In this article, we have compiled a list of 100 essential shortcut keys in Microsoft Excel. By familiarizing yourself with these shortcuts, you can navigate Excel with ease and accomplish tasks more quickly and efficiently.
100 Basic Shortcut Keys in Microsoft Excel:
| Shortcut Key | Description |
|---|---|
| Ctrl + N | Create a new workbook |
| Ctrl + O | Open a saved workbook |
| Ctrl + S | Save a workbook |
| Ctrl + A | Select all the contents in a workbook |
| Ctrl + B | Turn highlighted cells bold |
| Ctrl + C | Copy cells that are highlighted |
| Ctrl + D | Fill the selected cell with the content of the cell right above |
| Ctrl + F | Search for anything in a workbook |
| Ctrl + G | Jump to a certain area with a single command |
| Ctrl + H | Find and replace cell contents |
| Ctrl + I | Italicize cell contents |
| Ctrl + K | Insert a hyperlink in a cell |
| Ctrl + L | Open the create table dialog box |
| Ctrl + P | Print a workbook |
| Ctrl + R | Fill the selected cell with the content of the cell on the left |
| Ctrl + U | Underline highlighted cells |
| Ctrl + V | Paste anything that was copied |
| Ctrl + W | Close your current workbook |
| Ctrl + Z | Undo the last action |
| Ctrl + 1 | Format the cell contents |
| Ctrl + 5 | Put a strikethrough in a cell |
| Ctrl + 8 | Show the outline symbols |
| Ctrl + 9 | Hide a row |
| Ctrl + 0 | Hide a column |
| Ctrl + Shift + : | Enter the current time in a cell |
| Ctrl + ; | Enter the current date in a cell |
| Ctrl + ` | Change the view from displaying cell values to formulas |
| Ctrl + ‘ | Copy the formula from the cell above |
| Ctrl + – | Delete columns or rows |
| Ctrl + Shift + = | Insert columns and rows |
| Ctrl + Shift + ~ | Switch between displaying Excel formulas or their values in a cell |
| Ctrl + Shift + @ | Apply time formatting |
| Ctrl + Shift + ! | Apply comma formatting |
| Ctrl + Shift + $ | Apply currency formatting |
| Ctrl + Shift + # | Apply date formatting |
| Ctrl + Shift + % | Apply percentage formatting |
| Ctrl + Shift + & | Place borders around the selected cells |
| Ctrl + Shift + _ | Remove a border |
| Ctrl + – | Delete a selected row or column |
| Ctrl + Spacebar | Select an entire column |
| Ctrl + Shift + Spacebar | Select an entire workbook |
| Ctrl + Home | Redirect to cell A1 |
| Ctrl + Shift + Tab | Switch to the previous workbook |
| Ctrl + Shift + F | Open the fonts menu under format cells |
| Ctrl + Shift + O | Select the cells containing comments |
| Ctrl + Drag | Drag and copy a cell or duplicate a worksheet |
| Ctrl + Shift + Drag | Drag and insert copy |
| Ctrl + Up arrow | Go to the top most cell in a current column |
| Ctrl + Down arrow | Jump to the last cell in a current column |
| Ctrl + Right arrow | Go to the last cell in a selected row |
| Ctrl + Left arrow | Jump back to the first cell in a selected row |
| Ctrl + End | Go to the last cell in a workbook |
| Alt + Page Down | Move the screen towards the right |
| Alt + Page Up | Move the screen towards the left |
| Ctrl + F2 | Open the print preview window |
| Ctrl + F1 | Expand or collapse the ribbon |
| Alt | Open the access keys |
| Tab | Move to the next cell |
| Alt + F + T | Open the options |
| Alt + Down arrow | Activate filters for cells |
| F2 | Edit a cell |
| F3 | Paste a cell name if the cells have been named |
| Shift + F2 | Add or edit a cell comment |
| Alt + H + H | Select a fill color |
| Alt + H + B | Add a border |
| Ctrl + 9 | Hide the selected rows |
| Ctrl + 0 | Hide the selected columns |
| Esc | Cancel an entry |
| Enter | Complete the entry in a cell and move to the next one |
| Shift + Right arrow | Extend the cell selection to the right |
| Shift + Left arrow | Extend the cell selection to the left |
| Shift + Space | Select the entire row |
| Page Up/Down | Move the screen up or down |
| Alt + H | Go to the Home tab in the Ribbon |
| Alt + N | Go to the Insert tab in the Ribbon |
| Alt + P | Go to the Page Layout tab in the Ribbon |
| Alt + M | Go to the Formulas tab in the Ribbon |
| Alt + A | Go to the Data tab in the Ribbon |
| Alt + R | Go to the Review tab in the Ribbon |
| Alt + W | Go to the View tab in the Ribbon |
| Alt + Y | Open the Help tab in the Ribbon |
| Alt + Q | Quickly jump to search |
| Alt + Enter | Start a new line in a current cell |
| Shift + F3 | Open the Insert function dialog box |
| F9 | Calculate workbooks |
| Shift + F9 | Calculate an active workbook |
| Ctrl + Alt + F9 | Force calculate all workbooks |
| Ctrl + F3 | Open the name manager |
| Ctrl + Shift + F3 | Create names from values in rows and columns |
| Ctrl + Alt + + | Zoom in inside a workbook |
| Ctrl + Alt + – | Zoom out inside a workbook |
| Alt + 1 | Turn on Autosave |
| Alt + 2 | Save a workbook |
| Alt + F + E | Export your workbook |
| Alt + F + Z | Share your workbook |
| Alt + F + C | Close and save your workbook |
| Alt or F11 | Turn key tips on or off |
| Alt + Y + W | Know what’s new in Microsoft Excel |
| F1 | Open Microsoft Excel help |
| Ctrl + F4 | Close Microsoft Excel |
- How to Fix a Cell in Excel: A Step-by-Step Guide
- How to use Excel for data analysis and visualization
- Microsoft Excel tips you can use to inch closer to mastery
- Smooth Scrolling Feature in MS Excel Insider
- What is MS Excel? An Overview, Features & History (2022)
- How to Enable Developer Mode on Excel
- How to Remove a excel sheet Password
- HOW TO USE IF FUNCTION IN EXCEL
Conclusion:
Mastering shortcut keys in Microsoft Excel can greatly enhance your productivity and efficiency. In this article, we have covered 100 essential shortcut keys that will help you perform a wide range of operations in Excel, from basic workbook operations to advanced formatting and navigation. By incorporating these shortcuts into your Excel workflow, you can save time and streamline your work processes. Practice using these shortcuts regularly, and you’ll become an Excel power user in no time.
