Keyboard Shortcuts For MS Excel in Windows

MS Excel continues to be one of the office applications of reference after the launch of Office 2016. And today we have compiled 160 keyboard shortcuts for MS Excel in Windows 10 to speed up your work.

To make a list to be as clean and organized as possible, it has been sorted by types of combinations. We will start with what the function keys do; we will continue with more shortcuts of a single key and little by little we will introduce new combinations with Control, Alt and several of them together in MS Excel.

MS Excel

 Function keys:

Let’s start with the function keys. These go from F1 to F12. Each of them has a particular function in the application, so you should know them to speed up some processes like repeating actions, checking the spelling or going to a definite point in the data sheet that you are working.

SHORTCUT                                   ACTION


F1                                  Show Excel Help.
F2                                  Enter edit mode for the current cell.
F3                                  If defined name exists, it shows the “Paste Name.”
F4                                  Repeat the last action
F5                                  Go to
F6                                  You move between the panels of a divided book
F7                                  Spell check
F8                                  Activate the Expand Selection mode
F9                                  Solve the formulas that you have in the sheets your open books
F10                                Activate the menu bar
F11                                 Creates a chart sheet with the range of cells selected
F12                                 Save as.


Single-key shortcuts:

The simpler a keyboard shortcut will help you perform the actions as quickly as possible. So, let’s continue with the keyboard shortcuts in which we only have to press a key.

SHORTCUT                                ACTION


PAGE AV.                                      Move a screen down inside the sheet
PAG.                                               Move a screen up inside the sheet
ALT                                                Activate the menu bar
GET IN                                          Accepts the entry of a cell and selects the lower one
ESC                                                Cancel dialog and cancel entry of a cell
SPACE                                           Toggles check boxes in dialog boxes
END                                               Enables or disables the “End Mode”
START                                           Move to the top of your cell row
RECOIL                                         Deletes the contents of a cell. Enter edit mode
SUPPRESS                                     Clears the contents of a cell
TABULATOR                                  Complete the entry of a cell. Select the cell to the right
DIRECTIONAL KEYS                       Move to the top, bottom, left, or right cells.


Shortcuts with the “Control” key

Let’s put it a little harder, but not too hard. Next, you have a series of keyboard shortcuts in which you will have to combine the Control key with another to perform the desired action. Copy, paste, cut, dialog boxes or formats for the text.

SHORTCUT                                ACTION


CONTROL + A                        Open dialog box
CONTROL + B                        Search Dialog Box
CONTROL + C                        Copy the contents of the selected cells
CONTROL + D                       Copy the formula to the right of the selected range
CONTROL + E                        Select all the cells in your spreadsheet
CONTROL + G                        Save dialog box
CONTROL + I                         “Go To” dialog box
CONTROL + J                         Copy the formula down the selected range
CONTROL + K                        Set or remove the italic format in the selected text
CONTROL + L                         Replace dialog box
CONTROL + N                        Set or remove bold formatting in selected text
CONTROL + P                        “Print” dialog box
CONTROL + R                          Close your active workbook
CONTROL + S                          Put or remove the underlined format in the selected text
CONTROL + T                          Create Table dialog box
CONTROL + U                          Create a new workbook
CONTROL + V                          Paste the contents of the clipboard
CONTROL + X                          Cuts selected cells
CONTROL + Y                           Redo Undo Action
CONTROL + Z                           Undo action
CONTROL + 1                           “Format Cells” Dialog Box
CONTROL + 2                            Set or remove bold formatting in selected text
CONTROL + 3                            Set or remove the italic format in the selected text
CONTROL + 4                            Put or remove the underlined format in the selected text
CONTROL + 5                            Put or remove the strikethrough format in the selected text
CONTROL + 6                            Hides or shows objects on a sheet
CONTROL + 8                            Displays the outline symbols on the sheet
CONTROL + 9                            Hide selected rows
CONTROL + 0                            Hides selected columns


Shortcuts with the “Shift” and function keys

You have a series of keyboard shortcuts in which you will combine the Shift or Shift key with the function keys, which go from F1 to F12. With them, we can add new spreadsheets, open new dialog or calculate all the formulas that we have annotated in the sheet.

SHORTCUT                                        ACTION


SHIFT + F2                                        Add comment in cell
SHIFT + F3                                       “Insert Function” dialog box. editing formulas displays the “Function Arguments.”
SHIFT + F4                                       “Find next” when doing a search
CAPITAL + F5                                   Search Dialog Box
SHIFT + F6                                        Move between the worksheet, the options, the status bar, and the task pane
SHIFT + F7                                       “Reference” task pane
CAPITAL + F8                                   Add a cell or range of cells to your selection with the arrow keys
CAPITAL + F9                                   Calculate all the formulas on your active sheet
CAPITAL + F10                                 Displays the context menu of a selected item
CAPITAL + F11                                  Insert a new spreadsheet
SHIFT + F12                                      Save As dialog box.


MS Excel Shortcuts with “Alt” + function keys

Next, you have a series of keyboard shortcuts in which you will combine the Alt key with the function keys, those that go from F1 to F12. This time is just a few shortcuts, but with them, you can save jobs, open Visual Basic or close the application.

SHORTCUT                                             ACTION


ALT + F1                                               Creates an embedded graph from current range data
ALT + F2                                               Save As dialog box
ALT + F4                                               Close Excel
ALT + F8                                               Macro dialog box
ALT + F10                                             Panel “Selection and Visibility”
ALT + F11                                             Initiate the Microsoft Visual Basic.


Shortcuts with the “Control” and Function Keys

We combine the Control key again, only this time we will match it with the function keys. Again there are not many, but they allow you to start doing some actions in the book. Understand that each book opens as a different Excel, and inside you can have several spreadsheets.

SHORTCUT                                                     ACTION


CONTROL + F1                                                Show or hide options
CONTROL + F2                                              “Print” dialog box
CONTROL + F3                                                Name Manager
CONTROL + F4                                                Close the book
CONTROL + F5                                                Restores book size
CONTROL + F6                                                Move to the next book
CONTROL + F7                                                Move the book window
CONTROL + F8                                                Change the size of the book window
CONTROL + F9                                                Minimize the book
CONTROL + F10                                              Maximize a minimized book
CONTROL + F11                                              Create a Macros sheet
CONTROL + F12                                              Open dialog box.


MS Excel Shortcuts With The “Control” and “Shift” Keys

Combinations are growing, and now we’re going to offer a few shortcuts where you pressed both keys Control, Shift with another that can be function keys, letters or symbols.

SHORTCUT                                                            ACTION


CONTROL + SHIFT + F3                                ” Create Names from Selection” Dialog Box
CONTROL + SHIFT + F6                                   Go to the previous book that you have open
CONTROL + SHIFT + F10                                 Go to the menu bar
CONTROL + SHIFT + F12                                 Print” dialog box
CONTROL + SHIFT + F                                     Open the “Format Cells” menu in the “Fonts” tab
CONTROL + SHIFT + L                                     Enables and disables filters in a range
CONTROL + SHIFT + O                                    Select cells that have comments
CONTROL + SHIFT + U                                     Extend the formula bar
CONTROL + SHIFT + ENTER                          Enter a formula as a matrix formula
CONTROL + SHIFT + HOME                           Extend the selection of cells to the beginning of the spreadsheet
CONTROL + SHIFT + END                               Extends cell selection to the last used cell in the spreadsheet
CONTROL + SHIFT + PAGE DOWN               Select the current and next sheet in a book
CONTROL + SHIFT + PAGE UP                      Select the current and previous sheet in a book
CONTROL + SHIFT + DIRECTION KEY           Extends the selection of cells to the last non-empty cell
CONTROL + SHIFT + SPACE                           Select entire spreadsheet
CONTROL + SHIFT + (                                      Displays the hidden rows in the selected range
CONTROL + SHIFT +)                                       Displays the hidden columns in the selected range
CONTROL + SHIFT +!                                       Applies the number format with two decimal places
CONTROL + SHIFT + #                                     Applies the Date format to the day, month, and year
CONTROL + SHIFT + $                                     Applies the Currency format to two decimal places
CONTROL + SHIFT +%                                     Apply the Percentage without decimals format
CONTROL + SHIFT + /                                     Apply the Scientific Notation format
CONTROL + SHIFT +:                                       Applies the Time format
CONTROL + SHIFT + &                                    Applies a border to the active cell
CONTROL + SHIFT + ”                                      Copy the contents of the top cell
CONTROL + SHIFT + MINUS SIGN (-)         Clears the edges of the cell
CONTROL + SHIFT + PLUS SIGN (+)           Insert dialog box to insert blank cells.


MS Excel Shortcuts To Move In Spreadsheet

Now let’s show you a slightly different list. This time, instead of focusing on the type of key combination we need we will focus on the type of function they perform. We will start with the keyboard shortcuts to move in the spreadsheet going to concrete cells.

SHORTCUT                                                                                 ACTION


ALT + PAGE DOWN                                                         Move a screen to the right on a spreadsheet
ALT + PG                                                                             Move a screen to the left in a spreadsheet
CONTROL +.                                                                      Go to the next corner of a selected range
CONTROL + PAGE DOWN                                             Go to the next sheet of a book
CONTROL + PG                                                                 Go to the previous sheet of a book
CONTROL + HOME                                                          Go to the beginning of a spreadsheet
CONTROL + END                                                              Go to the last cell of a spreadsheet
CONTROL + BACKSPACE                                               Displays the active cell
CONTROL + TAB                                                               Go to the next open book
CONTROL + DIRECTIONAL KEYS                               Go to the end of the current data area in a spreadsheet.


Shortcuts for selecting data

Now we show you shortcuts to select data. With them, you can select rows and columns to perform joint actions or extend a selection in the adjacent cells to which you have selected first.

SHORTCUT                                                                                ACTION


SHIFT + SPACE                                                                   Select the current row
CONTROL + SPACE                                                           Select the current column
UPPERCASE + HOME                                                       Extend the selection to the beginning of the row
SHIFT + PAGE DOWN                                                       Extend selection down
SHIFT + PAGE UP                                                              Extend selection up
SHIFT + DIRECTIONAL KEYS                                        Extend selection one cell up, down left or right
CONTROL + SHIFT + DIRECTIONAL KEYS               Extends the selection of cells to the last non-empty cell
CONTROL + SHIFT + HOME                                          Extends cell selection to first used cell in spreadsheet
CONTROL + SHIFT + END                                              Extends cell selection to the last used cell in the spreadsheet
CONTROL + SHIFT + *                                                     Selects the current area around the active cell.


Shortcuts for entering formulas and data

To finish, let’s focus on the shortcuts for entering formulas and data once you have selected the cells in which you want to act. You can copy the value of nearby cells or complete a value by automatically moving to the adjoining cell you want.

SHORTCUT                                                                         ACTION


ALT + =                                                                                    Inserts autosuma
ALT + DOWN                                                                         Opens a data validation list
ALT + ENTER                                                                         Insert a line break within a cell
CONTROL +                                                                            Insert the current date
CONTROL +:                                                                           Insert current time
CONTROL + ”                                                                         Copy the value of the cell above
CONTROL + ‘                                                                          Copy the formula from the cell above
CONTROL + ENTER                                                             Fill in the range of cells selected with the current entry
CONTROL + DELETE                                                           Delete the text to the end of the line
CONTROL + ALT + K                                                            Insert a hyperlink
SHIFT + ENTER                                                                     Complete the cell entry and go to the top cell
GET IN                                                                                      Complete the cell entry and go to the lower cell
CAPITAL + TAB                                                                      Complete the cell entry and go to the cell on the left
TABULATOR                                                                           Complete the cell entry and go to the cell to the right.


Other keyboard shortcuts

And we ended up with a selection of other keyboard shortcuts that we have left over or we have not been able to categorize on any other list. If you think that we have left some keyboard shortcut to tell us in the comments and we will add it to this last table.

SHORTCUT                                                                                 ACTION


ALT + SPACE                                                                           Excel window control menu
ALT + ‘ “Style”                                                                         dialog box
ALT + CONTROL + LEFT                                                     Move to the left between nonadjacent cells
ALT + CONTROL + RIGHT                                                  Move to the right between nonadjacent cells
CONTROL + SIGN MINUS (-)                                             Delete cells dialog box
CONTROL + SIGN PLUS (+)                                                Insert cells” dialog box
CONTROL + ALT + V                                                             Special Paste Dialog Box

Add a Comment

Your email address will not be published. Required fields are marked *