Excel

Excel keyboard shortcuts for Windows is the most useful time-saving process

most useful excel keyboard shortcut

The Excel keyboard shortcuts are most useful for using different keyboard commands to speed up our tasks using Microsoft excel for windows.

A shortcut is a set of keys pressed at one time, which allows us to execute a specific action at a higher speed. In the case of programs like Excel, it is most common to use critical combinations since they help improve productivity and speed when working.

So, if you are a user who always uses this type of program and you do not know these types of shortcuts, here we leave you a complete list of all the most keyboard shortcut keys in excel that you can perform on it through the Windows keyboards.

List of the best shortcuts and key combinations to use Excel with the keyboard for Windows

When working with Excel, we can use many key combinations to speed up specific steps when we want to bring out a particular method, be it copy, paste, save, close, cut, among other functions. Here we present you with a complete list of the most useful time-saving shortcuts key combinations that you can perform on your keyboard when using this Microsoft program for Windows.

Function keys in Excel

The function keys (F1 to F12) consist of those that we find at the top of our keyboard, where each one of them has a specific function within this excel program, either to check to spell, correct, go to some particular place on the sheet, among others.

KeysResults
F1Show the help box.
F2Enter edit mode for active cells.
F3Displays the Paste Name dialog.
F4Repeat exactly the last action you took.
F5Displays the Go to the dialog box.
F6Allows you to move between panels in a divided book.
F7Shows the window for the Spell check.
F8Activates the Expand selection mode, which allows increasing the selected range.
F9Calculate the result of all existing formulas in all open workbook sheets.
F10Activate the Menu bar.
F11Create a chart sheet through the previously selected range.
F12Displays the Save As window.

Using the “Control” key and function keys in Excel for Windows

Now we present other key combinations, but this time using “Control” related by each of the “function keys” and with which we can perform some actions in a more direct way than using the mouse. Here we present each of these combinations.

Key combinationsResults
Ctrl + F1Hide or show the ribbon.
Ctrl + F2Show the Print window.
Ctrl + F3Teach the Name Manager.
Ctrl + F4Close the current book window.
Ctrl + F5Allows you to restore the window to the current book.
Ctrl + F6Move to the next book if there is another open.
Ctrl + F7Move the workbook window when the window is not maximized.
Ctrl + F8Allows you to modify the workbook windows size when the window is not maximized.
Ctrl + F9Minimize the workbook window you are working with.
Ctrl + F10Maximize the window of a minimized book.
Ctrl + F11Insert a Microsoft Excel 4.0 Macros sheet.
Ctrl + F12Show the Open window.

Using ALT key and function keys in Excel

Key combinationResults
Alt + F1Insert a Graphic into the current sheet.
Alt + F2Show the Save As window.
Alt + F4Close the excel sheet.
Alt + F8Open the Macro window.
Alt + F10Show the Selection and visibility panel.
Alt + F11Start the Visual Basic Editor for applications.

Using the “Shift” key and function keys in Excel

In this case, we will show you most excel keyboard shortcuts key combinations that you can do to the Shift key together with each of the function keys inside an Excel sheet to obtain tools in a much faster and more direct way.

Key combinationsResults
Shift + F2Allow Add or edit any cell comment.
Shift + F3Show the Insert function window.
Shift + F4Run the command Find Next.
Shift + F5Show the Search window.
Shift + F6Allows you to change focus between sheet, ribbon, status bar, and task pane.
Shift + F7Show the Research window.
Shift + F8Allows you to add a new range to the selected cells.
Shift + F9Helps calculate formulas on the current sheet.
Shift + F10Show the right-click menu for text selection.
Shift + F11Lets you insert a new sheet.
Shift + F12Open the Save As window.

One-key shortcuts in Excel

When Excel keyboard shortcuts key is much simpler, they can learn and remember when you want to apply them. Here we present a list of a single key that will take you to a specific action in Windows.

KeyResults
AltActivate the Menu bar.
PageDownScroll one screen below the Excel sheet.
PageUpAllows you to scroll up one screen within the sheet.
EnterSelect the bottom cell after complete a cell entry.
EscClose any open dialog box and cancel an entry to a cell.
SpaceUsed to activate or deactivate a checkbox within a dialog window.
EndIt is used to activate or deactivate the final mode.
HomeLet’s move to the start of the row.
DeleteDelete the contents of a cell and enter edit mode.
BackSpaceAllows you to clear the contents of a cell.
Arrow keysMove to select the cell of the left, right, bottom, or top.
TabLet’s complete the entry of a cell and automatically selects the cell on the right.

Using the “Control” key + “Alphabet”

Here, we are going to use the “Control” key accompanied by another key to be able to carry out a specific action within the document, so here we present each of these Excel keyboard shortcuts.

Key combinationsResults
Ctrl + ASelect all the cells of the current sheet with which you are working.
Ctrl + BApply bold formatting to all selected text.
Ctrl + CCopy the selected cells.
Ctrl + DCopy a formula down over the range that is selected.
Ctrl + FShow the Find and Replace window.
Ctrl + GShow the sale of Go to.
Ctrl + IApply the Italic format on the selected text.
Ctrl + KInsert Hyperlink window.
Ctrl + LShow the Create table window.
Ctrl + NOpen a new workbook.
Ctrl + OShow the Open window.
Ctrl + PShow the Print window.
Ctrl + RCopy a formula right above the selected range.
Ctrl + SAllows Save the worksheet.
Ctrl + TShow the Create table window.
Ctrl + UUnderline all selected text.
Ctrl + VAllows you to paste the content of Clipboard.
Ctrl + WClose the spreadsheet or book.
Ctrl + XCut the cells that are selected.
Ctrl + YRedo the last action.
Ctrl + ZUndo the last action.

Using the “Control” key + “Number”

Key combinationsResults
Ctrl + 1Let’s start the Format Cells window.
Ctrl + 2Apply the Bold format to the text that is selected.
Ctrl + 3Apply the Italic format to the selected text.
Ctrl + 4Underline the text that is selected in the worksheet.
Ctrl + 5Apply the Strikethrough effect to the selected text.
Ctrl + 6Hide or show worksheet objects.
Ctrl + 8Show sheet outline symbols.
Ctrl + 9Hides all selected rows on the sheet.
Ctrl + 0Hides the selected columns on the sheet.

Using the “Control” + “Shift” key in Excel

In this case, the keyboard shortcuts key combinations within Excel are increasing, that is how we will now show you some shortcuts that you can get using the “Ctrl + Shift + other keys” and some symbols, letters, or numbers can be used.

Key combinationsResults
Ctrl + Shift + F3Open the Create name window.
Ctrl + Shift + F6Let’s move to the previously opened book.
Ctrl + Shift + F10Let’s activate the Menu bar.
Ctrl + Shift + F12Displays the Print window.
Ctrl + Shift + FShow the Format Cells window.
Ctrl + Shift + LEnable or disable filters within a range.
Ctrl + Shift + UExpand the formula bar.
Ctrl + Shift + EnterLet’s enter a formula as a matrix formula.
Ctrl + Shift + HomeExtend selection to start of the spreadsheet.
Ctrl + Shift + EndExtend the selection to the last cell used in the spreadsheet.
Ctrl + Shift + Page DownAllows you to add the following sheet to the spreadsheet selection.
Ctrl + Shift + Page UpAllows you to add the previous sheet to the sheet selection.
Ctrl + Shift + Direction KeyExtend the last non-empty cell selection depending on the selected key’s address.
Ctrl + Shift + SpaceSelect the current full sheet range or cell range.
Ctrl + Shift + (Allows you to see the hidden cells within the selected range.
Ctrl + Shift +)Show hidden columns within the range that is selected.
Ctrl + Shift +!Apply for the format Number with two decimal places.
Ctrl + Shift + #Apply the Date format in the form dd / mm / yy.
Ctrl + Shift + $Apply the Currency format with two decimal places in selected cells.
Ctrl + Shift +%Apply the Percentage format without decimals.
Ctrl + Shift + /Apply the format of Scientific notation.
Ctrl + Shift +:Apply the Hour format.
Ctrl + Shift + &Allows you to apply a border to the selected cell.
Ctrl + Shift + –Allows you to remove the borders of the selected cells.
Ctrl + Shift + ”Copy the contents of the top cell.

Most useful Excel keyboard Shortcuts to move within the spreadsheet in Windows

Here, we are going to show you the most helpful keyboard shortcuts key combinations that will allow us to move within the spreadsheet, which is very useful to us when working with Excel for Windows.

Key combinationsResults
Ctrl + Page UpAllows you to move to the previous sheet.
Ctrl + Page DownMove to the next spreadsheet.
Ctrl + HomeLet’s move to cell A1 or the top-left cell of the sheet.
Ctrl + EndLet’s move to the last used cell in the current range.
Alt + Page UpYou can move a screen to the left of the sheet.
Alt + Page DownGives the possibility to move one screen to the right of the sheet.
Ctrl + TabLet’s move to the next open book.
Ctrl + Arrow KeysIt gives the possibility to move to the end of the row or column depending on the key’s direction.

Shortcuts to select Excel data

With these shortcuts, you have the opportunity to select rows or columns to perform actions together or extend a selection. So, you can use different key combinations, which we will show you below.

Key combinationsResults
Ctrl + *Select the current region of cells with data.
Ctrl + SpaceSelect the current column.
Shift + Page DownExtend selection to the bottom by one screen.
Shift + Page UpAllows you to extend selection up one screen.
Shift + HomeExtend the selection to the beginning of a row.
Shift + SpaceSelect the current row.
Shift + Arrow keyExtends the selection by one cell in the same direction as the pressed key.

Most useful shortcuts to enter Excel data and formulas

Another benefit of using shortcuts is when you want to enter formulas and data once you have selected the cells you want to work on. In the same way, here we show you that are the main keys combinations to carry out this.

Key combinationsResults
Alt + =Let’s insert an auto sum in the adjacent cell.
Alt + DownUsed to display all the options in a data validation list.
Alt + EnterAllows you to insert a line break inside the cell where you work.
Ctrl +;To insert the current date.
Ctrl +:To insert the current time.
Ctrl + ”Copy the value of the current cell.
Ctrl + ‘Copy the cell formula.
Ctrl + EnterLet’s fill the range of selected cells with the current entry.
Shift + EnterComplete the cell entry and select the top cell.
Shift + TabSelect the cell on the left.

Other Excel most useful keyboard shortcuts in Excel

Now we show you other shortcuts or keys combinations that you can use in Excel & that will surely be very useful when working with this program, which is given below.

Key combinationsResults
Alt + SpaceHelps you open the Excel sale control menu.
Alt + ‘Show the Style window.
Alt + Ctrl + LeftMoves to the left side between non-adjacent cells in a selected range.
Alt + Ctrl + RightMoves to the right side between non-adjacent cells in a selected range.
Ctrl + –Show the Delete cells window.
Ctrl ++Show the Insert cells window.
Ctrl + Alt + VDisplays the Paste Special window.

How to change and customize Microsoft Excel shortcuts keys for Windows?

Often able to start using a shortcut keyboard in Excel ends up becoming a primary tool that will work with greater efficiency and speed. Especially for all those who have mobility or visual disabilities.

In many cases, the shortcuts are very easy to use, and they become an alternative to the handling of the mouse. Besides, they are considered to be much easier to use than on the touch screen.

Start all this. It’s significant to be able to access the ribbon with the keyboard first. Please note that this section will help you better understand the keyboard shortcut. This ribbon includes the new Microsoft Excel shortcuts, which have been called “Key Tips” which can make them appear without the need to press the “Alt + letter or number” key.

Customize shortcuts key in Excel

Now, you just press the “Alt” key alone & in a second, the shortcut key will appear, then you have to press the letter of the action you want to perform. For example, if you’re going to enter “Insert” you just have to press the “N” key, in the case of entering “formulas” the “M” key, for the “View” tab, press the “W” key, and so on successively with the key of the tool that we want to use.

Need more help with keyboard shortcuts? You can enter help at any time by pressing F1. Opens a Help panel and allows you to search for help on any topic. Search for “keyboard shortcuts” for more information.

You Might Also Like

2 Comments

  • Reply How to insert hyperlinks in PowerPoint and where to use them April 29, 2021 at 2:07 pm

    […] by using a keyboard shortcut [Ctrl+k].In my blog, I already published an article about the Excel keyboard shortcut. I think this is very helpful to […]

  • Reply How to split a single cell in half in Excel | Easy Learn Methods August 10, 2021 at 5:25 pm

    […] In the Format Cells dialog box, the Alignment tab displays. Using the keyboard shortcut “Ctrl+1,” open the Format Cells dialog […]

  • Leave a Reply

    back to top