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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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