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 reduce your time.
Microsoft Excel is a 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]
Excel Shortcuts you Should Know
The given list of MS Excel keyboard shortcuts will work with all versions starting from Microsoft Excel 2003 until Microsoft Excel 2019 or Office 365. Find out the list below to know basic excel shortcuts and their functions.
Note: If using laptop, below given F1, F7 and F12 shortcuts will work with laptop’s fn key
Useful Microsoft Excel Shortcut Keys
Keyboard Shortcut | Command Function |
Ctrl + A | Select all |
Ctrl + B | Make text bold |
Ctrl + C | Copy selected text |
Ctrl + D | Fill cell as above cell |
Ctrl + F | Search option |
Ctrl + H | Launch find and replace window |
Ctrl + I | Make text Italic |
Ctrl + K | Create Hyperlink |
Ctrl + N | Create a new excel workbook |
Ctrl + O | To open an existing excel workbook |
Ctrl + P | Print option |
Ctrl + S | Save a excel workbook |
Ctrl + V | Paste copied text |
Ctrl + U | Underline selected text |
Ctrl + W | To 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 an 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 select data |
Alt + F8 | Create, run, edit, or delete a Macro |
Alt + F11 | Open the 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 Click To Tweet