This article is about MS Excel Shortcut Keys PDF. MS Excel is one of the most important and widely used applications found on the computer. Everyone basically uses MS Excel for analyzing, sharing, and managing information for accounting purposes performing mathematical calculations, budgeting, billing, & so on.
MS Excel Shortcut keys
MS Excel is a spreadsheet application originally designed and developed by Microsoft Corporation. The first version of Excel was released in the 1980s and since then it has evolved and expanded to become one of the most powerful business software programs in the world.
It is one of the most widely used office suites on the market today and is trusted by millions of users worldwide to perform complex data manipulations, organize and present information visually, and much more. Originally designed as a tool for managing business data, it has evolved into so much more. Today, Excel is used by individuals to track their finances, by small business owners to manage their day-to-day operations, and by students to prepare for exams.
List of MS Excel Shortcut keys | MS Excel Shortcut Keys PDF
| Shortcut Keys | Functions |
|---|---|
| Ctrl+F | Search the 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 the 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 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 | Repeat the last entry. |
| 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 action. For example, if you change the color of the text in another cell, pressing F4 will change the text in the cell to the same color. |
| 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 | Enter the current date. |
| 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+; | Open the Insert Function window |
| 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 | Bring out the print dialog box to begin prating |
| 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 worksheets in the same Excel document |
| CTRL+P | Being up a print dialog box to being printing |
| CTRL+Z | Undo the last action |
| CTRL+ Page Down | Move the next sheet between Excel worksheets 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 a percentage format |
| CTRL + shift+@ | Format number in time format |
| CTRL+ SPACE | Select entire column |
| SHIFT+SPACE | Select entire row |
Benefits of MS Excel Shortcut Keys
As such, it has a plethora of shortcuts and functions that can make your work in MS Excel much easier. This MS Excel Shortcut Keys List PDF will teach you some of the most useful MS Excel shortcuts and functions that can help you be more efficient when working in Excel.
It will also teach you how to create custom macros in Excel to automate the work that you want to have performed over and over again. If you want to learn how to use Microsoft Excel to its fullest potential, then you’ve come to the right place.
Download MS Excel Shortcut Keys PDF
Click on the download button to download the MS Excel Shortcut Keys List in a PDF format. If you want to know more advanced shortcut keys for the computer, then write a comment below.
