MS Excel Shortcut keys PDF - Basically, everyone uses MS Excel or Microsoft Excel to analyze, share and manage information for accounting purposes doing mathematical calculations, budgeting, billing, etc. MS Excel is a very useful tool for data management and analysis. It's easy to use, has tons of features, and is very flexible. It is also an extremely popular tool among students and professionals as a data management and analysis tool.
MS Excel Shortcut keys PDF
MS Excel Shortcut Keys allow you to enter text or perform other actions faster than if you had to use the mouse or trackpad. In MS Excel, the most common shortcut keys are the function keys, which allow you to access certain functions with a keystroke.
In this blog, we have provided the list of shortcut keys for excel and I have included a few of the most useful ones to help you work faster, and here you can download the MS Excel shortcut keys PDF by using the direct download link which is given at the bottom of this blog.
List of MS Excel Shortcut keys
| Shortcut Keys | Functions |
|---|---|
| Ctrl+F | Search current sheet. |
| Ctrl+G | Go to a certain area. |
| Ctrl+H | Find and replace. |
| Ctrl+I | Puts italics on all cells in the highlighted section. |
| Ctrl+K | Inserts a hyperlink. |
| Ctrl+L | Opens the Create Table dialog box. |
| Ctrl+R | Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell. |
| Ctrl+Home | Move to cell A1. |
| Ctrl+End | Move to the last cell with text on the worksheet. |
| Ctrl+Shift+P | Opens the drop-down menu for the point size. |
| Shift+Insert | Pastes what is stored on the clipboard. |
| Shift+Page Up | In a single column, highlight all cells above that are selected. |
| Shift+Page Down | In a single column, highlight all cells above that are selected. |
| Shift+Home | Highlights all text to the left of the cursor. |
| Shift+End | Highlights all text to the right of the cursor. |
| Shift+Up Arrow | Extends the highlighted area up to one cell. |
| Shift+Down Arrow | Extends the highlighted area down one cell. |
| Shift+Left Arrow | Extends the highlighted area left one character. |
| Shift +Right Arrow | Extends the highlighted area right one character. |
| Ctrl+S | Saves the open worksheet. |
| Ctrl+Z | Undo the last action. |
| Ctrl+1 | Changes the format of the selected cells. |
| Ctrl+2 | Bolds all cells in the highlighted section. |
| Ctrl+T | Open the Create Table dialog box. |
| Ctrl+W | Closes the current workbook. |
| Ctrl+X | Cuts all cells in the highlighted section. |
| Ctrl+Y | Repeats the last entry. |
| Ctrl+U | Underlines all cells in the highlighted section. |
| Ctrl+V | Pastes everything copied onto the clipboard. |
| F1 | Opens the help menu. |
| F2 | Edits the selected cell. |
| F3 | After a name is created, F3 will paste names. |
| F4 | Repeats the last action. For example, if you changed the color of the text in another cell, pressing F4 will change the text in the cell to the same color. |
| F5 | Goes to a specific cell. For example, C6. |
| F6 | Move to the next pane. |
| F7 | Spell check selected text or document. |
| F8 | Enters Extend Mode. |
| F9 | Recalculates every workbook. |
| F10 | Activates the menu bar. |
| F11 | Creates a chart from selected data. |
| F12 | Save As option. |
| Alt+Shift+F2 | Saves the current worksheet. |
| Ctrl+N | Creates a new workbook. |
| Ctrl+O | Opens a workbook. |
| Ctrl+P | Print the current sheet. |
| Ctrl+3 | Puts italics on all cells in the highlighted section. |
| Ctrl+4 | Underlines all cells in the highlighted section. |
| Ctrl+5 | Puts a strikethrough all cells in the highlighted section. |
| Ctrl+6 | Shows or hides objects. |
| Ctrl+7 | Shows or hides the toolbar. |
| Ctrl+8 | Toggles the outline symbols. |
| Ctrl+9 | Hides rows. |
| Ctrl+0 | Hides columns. |
| Ctrl+Shift+: | Enters the current time. |
| Ctrl+; | Enters the current date. |
| Ctrl+` | Changes between displaying cell values or formulas in the worksheet. |
| Ctrl+’ | Copies a formula from the cell above. |
| Ctrl+Shift+” | Copies value from the cell above. |
| Ctrl+- | Deletes the selected column or row. |
| Ctrl+Shift+= | Inserts a new column or row. |
| Ctrl+Shift+~ | Switches between showing Excel formulas or their values in cells. |
| Ctrl+Shift+! | Applies comma formatting. |
| Ctrl+Shift+$ | Applies currency formatting. |
| Ctrl+Shift+# | Applies date formatting. |
| Ctrl+Shift+% | Applies percentage formatting. |
| Ctrl+Shift+^ | Applies exponential formatting. |
| Ctrl+Shift+* | Selects the current region around the active cell. |
| CTRL+SHIFT+; | Enter the current Time |
| CTRL+; | Enter the current date |
| Shift+F3 | Open the Insert Function window |
| Shift+F5 | Opens Find and replace dialog box |
| CTRL+A | Select all contents of the worksheets |
| CTRL+B | Bold highlighted selection |
| CTRL+I | Italic highlighted selection |
| CTRL+K | Insert Link |
| CTRL+U | Underline highlighted selection |
| CTRL+P | Bring out the print dialog box to being prating |
| CTRL+Z | Undo the last action |
| CTRL+F9 | Minimize current workbook |
| CTRL+F10 | Minimize currently selected workbook |
| CTRL+F6 | Switch between open workbooks/ Windows |
| CTRL+ | Page Up Move the previous sheet between Excel worksheet in the same Excel document |
| CTRL+P | Being up the print dialog box to being printing |
| CTRL+Z | Undo the last action |
| CTRL+ Page Down | Move the next sheet between Excel worksheet in the same Excel document |
| CTRL+ Tab | Move between or more open Excel Files |
| ALT+= | Create a formula to sum all of the above cells |
| Shift + home | Go to the first cell in the current row |
| 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 percentage format |
| CTRL + [email protected] | Format number in time format |
| CTRL+ SPACE | Select entire column |
| SHIFT+SPACE | Select entire row |
MS Excel Shortcut keys PDF Download
Click on this download button to download MS Excel Shortcut Keys PDF. You must have a PDF reader application on your phone or PC to view this PDF file.