In this tutorial, we will share the list of complete Microsoft Excel shortcut keys with description. It will help you to increase your productivity in your work. If you are a beginner, then it helps you to understand the basic computer functionality and Microsoft Excel.
Microsoft Excel keyword shortcut keys make your work easier, quicker to navigating and executing commands in computer software programs.
Shortcut Key | Description |
---|---|
F2 | Edit the selected cell |
F5 | Go to a specific cell |
F7 | Spell check selected text and/or document |
F11 | Create chart |
Ctrl + Shift + ; | Enter the current time |
Ctrl + ; | Enter the current date |
Alt + Shift + F1 | Insert new worksheet |
Shift + F3 | Open the Excel formula window |
Shift + F5 | Bring up search box |
Ctrl + K | Insert link |
Ctrl + F | Open find and replace options |
Ctrl + G | Open go-to options |
Ctrl + H | Open find and replace options |
Ctrl + U | Underline highlighted selection |
Ctrl + Y | Redo the changes |
Ctrl +5 | Strikethrough highlighted selection |
Ctrl + O | Open options |
Ctrl + N | Open new document |
Ctrl + P | Open print dialog box |
Ctrl + S | Save |
Ctrl +Z | Undo last action |
Ctrl + F9 | Minimize current window |
Ctrl + F10 | Maximize currently selected window |
Ctrl + F6 | Switch between open workbooks / windows |
Ctrl + F9 | Move between Excel worksheets in the same document |
Ctrl + Tab | Move between two or more open Excel files |
Alt + = | Create formula to sum all of above cells |
Ctrl + ‘ | Insert value of above cell into current cell |
Ctrl + [ | Decrease selected font -1 |
Ctrl + Shift + ! | Format number in comma format |
Ctrl + Shift + $ | Format number in currency format |
Ctrl + Shift + # | Format number in date format |
Ctrl + Shift + ^ | Format number in scientific format |
Ctrl + Shift + @ | Format number in time format |
Ctrl + → | Move to next section of text |
Ctrl + Space | Select entire column |
Shift + Space | Select entire row |
Ctrl + W | Close document |
If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.