MS Excel Shortcut Keys PDF – In this article, we have provided the PDF of Microsoft Excel Shortcut Keys, and here you can download the MS Excel Keyboard Shortcut Keys PDF for Windows and macOS using the download button, which is given below.
MS Excel Shortcut Keys
MS Excel is a spreadsheet application originally designed and developed by the 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.
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!
MS Excel Shortcut Keys List PDF | 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 |