Microsoft Excel Shortcut Keys
Keyboard shortcuts make our task easier. It’s true that using keyboard shortcuts in Excel helps work more efficiently for users. Hence, find the list of important and useful Microsoft excel shortcut keys below.
Using shortcuts in excel increases your productivity and reduces your time.
Microsoft Excel is part of the Office application package. Whenever you install Microsoft Office (any version), it gets installed automatically along with other applications such as Word, PowerPoint, Access, etc.
[Read: Download Full Version of Microsoft Office Professional Plus 2019]
The below given list of MS Excel keyboard shortcuts will work with all versions starting from Microsoft Excel 2003 to Microsoft Excel 2021 and Office 365.
Excel Shortcuts you Should Know
Find the list below to learn basic excel shortcuts and their functions to make your task easy:
Note: If using laptop, below given F1, F7 and F12 shortcuts will work with the laptop’s fn key
Useful Microsoft Excel Shortcut Keys
Keyboard Shortcut | Command Function |
Ctrl + A | Select all |
Ctrl + B | Make the text bold |
Ctrl + C | Copy the selected text |
Ctrl + D | Fill cell as above cell |
Ctrl + F | Search option |
Ctrl + H | Launch the “find and replace” window |
Ctrl + I | Make text Italic |
Ctrl + K | Create a Hyperlink |
Ctrl + N | Create a new excel workbook |
Ctrl + O | Open an existing excel workbook |
Ctrl + P | Print option |
Ctrl + S | Save the excel workbook |
Ctrl + V | Paste copied text |
Ctrl + U | Underline selected text |
Ctrl + W | Close an existing workbook |
Ctrl + X | Cut selected text |
Ctrl + Z | Undo your action |
Ctrl + Y | Redo action |
Ctrl + F1 | To show or hide the ribbon |
Ctrl + F2 | Switch window to print preview |
Ctrl + F3 | Open Name Manager (Define name) |
Ctrl + F4 | Close the excel workbook |
Ctrl + F6 or Ctrl + Tab | Switch between open workbooks |
Ctrl + F9 | Minimize the workbook window |
Ctrl + Shift + U | Expand or collapse the formula bar |
Alt + F | Open the File Tab menu |
Alt + H | Jump to the Home Tab |
Alt + N | Open the Insert Tab |
Alt + P | Go to the Page Layout tab |
Alt + M | Go to the Formulas tab |
Alt + A | Go to the Data tab |
Alt + R | Go to the Review tab |
Alt + W | Go to the View tab |
Alt + Y | Go to the Help tab |
Alt + Q | Go to the Tell me what you want to do search box |
Alt + F1 | Create an embedded bar chart based on the selected data |
Alt + F8 | Create, run, edit, or delete a Macro |
Alt + F11 | Open Microsoft Visual Basic for Applications Editor |
Shift + F3 | Open insert a function window |
Shift + F11 | Insert a new worksheet |
F1 | Open the Help pane |
F7 | Check the spelling |
F12 | Open the Save As dialog box |
[Read: List of Useful Microsoft Word Shortcut Keys]
List of Microsoft Excel Keyboard Shortcuts Share on X