249+ Excel Shortcuts Keys for Windows & Mac | Excel Shortcuts

The following table lists the default shortcut keys (which are also called shortcut keys or key combinations) that are available in Excel. For more information about the shortcut keys available in Excel, see the Microsoft help topic Keyboard Shortcut in Excel.

KeyAction
Ctrl+ASelects the entire worksheet or the current data region (the rectangular region containing filled cells around the active cell). Pressing Ctrl+A a second time selects the entire worksheet. If the insertion point is to the right of a function name in a formula, pressing Ctrl+A opens the Function Arguments dialog box.
Ctrl+Shift+AIf the insertion point is to the right of a function name in a formula, inserts the argument names and parentheses.
Ctrl+BToggles bold formatting (same as Ctrl+2).
Ctrl+CCopies the selection to the clipboard (same as Ctrl+Insert).
Ctrl+DCopies the contents and format of the uppermost selected cell in each column of the selected range into the other selected cells in the column.
Ctrl+FOpens the Search and Replace dialog box to the Find tab (same as Shift+F5).
Ctrl+GOpens the Go To dialog box (same as F5).
Ctrl+HOpens the Find and Replace dialog box to the Replacement tab.
Ctrl+IToggles italic formatting (same as Ctrl+3).
Ctrl+KOpens the Insert Hyperlink dialog box when the cursor is not at a hyperlink or the Edit Hyperlink dialog box for a selected existing hyperlink.
Ctrl+LOpens the Create List dialog box.
Ctrl+NCreate a new workbook.
Ctrl+OOpens the Open dialog box to locate or specify a file to open.
Ctrl+Shift+OSelects all cells that contain comments.
Ctrl+POpens the Print dialog box.
Ctrl+RCopies the contents and format of the rightmost selected cell in each row of the selected range into the other selected cells in the row.
Ctrl+SSaves the active workbook (same as Shift+F12 and Alt+Shift+F2).
Ctrl+UToggles underlining (same as Ctrl+4).
Ctrl+VPastes the clipboard contents (same as Shift+Insert).
Alt+Ctrl+VOpens the Paste Special dialog box.
Ctrl+WCloses the active workbook.
Ctrl+XCuts (copies to the clipboard and deletes) the selection (same as Shift+Del).
Ctrl+YRepeats the last action performed, if possible (same as F4).
Ctrl+ZUndoes the last action performed (same as Alt+Backspace).
Ctrl+Shift+ZUndoes or redoes the last automatic correction when AutoCorrect Smart Tags are displayed.
F1Shows the Help pane.
Ctrl+F1Shows or hides the Ribbon (double-clicking any Ribbon tab also shows or hides the Ribbon).
Alt+F1Creates a chart of the data in the current range (same as F11).
Alt+Shift+F1Creates a new worksheet (same as Shift+F11).
F2Enables editing of the contents of the selected cell (same as double-click).
Shift+F2Adds a comment or edit an existing comment.
Alt+Shift+F2Saves the active workbook (same as Ctrl+S and Shift+F12).
F3Opens the Paste Name dialog box to paste a defined name into a formula.
Ctrl+F3Opens the Define Name dialog box.
Shift+F3Opens the Insert Function dialog box.
F4Repeats the last action performed, if possible (same as Ctrl+Y).
Ctrl+F4Closes the active workbook.
Shift+F4
Ctrl+Shift+F4
Repeats the previous search.
Alt+Shift+F4Closes Excel.
F5Opens the Go To dialog box (same as Ctrl+G).
Ctrl+F5Reduces the size of the workbook window.
Shift+F5Opens the Find and Replace dialog box to the Find tab (same as Ctrl+F).
F6Switches to the previous pane in a worksheet that has been split, the Ribbon, the open task pane, and the zoom controls.
Ctrl+F6Switches to the next worksheet window.
Shift+F6Switches to the next pane in a worksheet that has been split, the zoom controls, the open task pane, and the Ribbon.
Ctrl+Shift+F6Switches to the previous worksheet window.
F7Checks spelling in the selected range or the active worksheet.
Ctrl+F7Switches to move window mode if the workbook window is not maximized.
F8Turns extend mode on or off. In extend mode, EXT appears in the status bar, and the arrow keys extend the selection. Pressing Esc also turns off extend mode. Scroll lock must be turned off to use extend mode.
Alt+F8Opens the Macro dialog box to run, create, modify, or delete a macro.
F9Calculate all worksheets in all open workbooks.
Ctrl+F9Minimizes the workbook window.
Shift+F9Calculates the active workbook.
Cntrl+Alt+F9Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Cntrl+Alt+Shift+F9Rechecks dependent formulas and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.
F10Selects the menu bar or close an open menu and submenu.
Ctrl+F10Toggles the size of the active workbook window between normal and maximized.
Shift+F10Displays the shortcut menu for the selected item (right-click also displays the shortcut menu).
Alt+Shift+F10Displays the menu or message for a smart tag. If more than one smart tag is present, switch to the next smart tag and display its menu or message.
F11Creates a chart of the data in the current range (same as Alt+F1).
Shift+F11Creates a new worksheet (same as Alt+Shift+F1).
Alt+F11Opens or switches to the Microsoft Visual Basic editor.
Alt+F11Opens the Microsoft Script Editor, in which you can add text, edit HTML tags, and modify any script code.
F12Opens the Save As dialog box.
Shift+F12Saves the active workbook (same as Ctrl+S and Alt+Shift+F2).
Scroll LockTurns on or off scroll lock. When scroll lock is turned on, SCRL appears in the status bar, the arrow keys do not move or extend the selection. Instead, they let you scroll the active worksheet.
Ctrl+`Toggles between displaying the values and the formulas in cells.
Ctrl+~Applies the General number format.
Ctrl+1Opens the Format Cell dialog box.
Ctrl+!Applies the Number format with two digits after the decimal point, a thousands separator, and a minus sign (-) for negative values.
Ctrl+2Toggles bold formatting (same as Ctrl+B).
Ctrl+@Applies the Time format with the hour, the minute, and AM or PM.
Ctrl+3Toggles italic formatting (same as Ctrl+I).
Ctrl+#Applies the Date format with the date, month, and year.
Ctrl+4Toggles underlining (same as Ctrl+U).
Ctrl+$Applies the Currency format with two decimal digits after the decimal point and negative numbers in parentheses.
Ctrl+5Toggles strikethrough formatting.
Ctrl+%Applies the Percentage format with no digits after the decimal point.
Ctrl+6Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
Ctrl+^Applies the Exponential format with two digits after the decimal point.
Ctrl+7Shows or hides the Standard toolbar.
Ctrl+&Applies the outline border to the selected cells.
Ctrl+8Shows or hides the outline levels.
Ctrl+*Selects the current data region (the rectangular region containing filled cells around the active cell).
Ctrl+9Hides the current row or selected rows.
Ctrl+(Unhides any hidden rows within the selection.
Ctrl+0Hides the current column or selected columns.
Ctrl+)Unhides any hidden columns within the selection.
Ctrl+-Opens the Delete dialog box to indicate how the selected cells should be deleted.
Ctrl+_Removes the outline border from the selected cells.
Ctrl++Opens the Insert dialog box to insert empty cells.
Ctrl+;Inserts the current date.
Ctrl+:Inserts the current time.
Ctrl+’Copies the formula from the cell above the active cell into the active cell.
Ctrl+”Copies the value from the cell above the active cell into the active cell.
EnterStops editing the current cell and selects the cell below it.
Ctrl+EnterFills the cells in the selected range with the current contents of the formula bar.
Shift+EnterStops editing the current cell and selects the cell above it.
Alt+EnterMakes a new line within a cell (inserts a line feed (ASCII 10)).
Ctrl+Shift+EnterEnters the contents of the formula bar as an array formula into the current cell or the selected range of cells. The curly brackets ({}), which should not be added manually, are added automatically.
Shift+InsertCopies the selection to the clipboard (same as Ctrl+C).
Shift+InsertPastes the clipboard contents (same as Ctrl+V).
Shift+DelCuts (copies to the clipboard and deletes) the selection (same as Ctrl+X).
Alt+BackspaceUndoes the last action performed (same as Ctrl+Z).
Ctrl+RightMoves to the right-hand edge of the current data region (range of cells that contain data).
Shift+RightExtends or collapses the selection to the right by one cell.
Ctrl+Shift+RightExtends the selection to the right-hand edge of the current data region.
Ctrl+LeftMoves to the left-hand edge of the current data region.
Shift+LeftExtends or collapses the selection to the left by one cell.
Ctrl+Shift+LeftExtends the selection to the left-hand edge of the current data region.
Ctrl+UpMoves to the upper edge of the current data region.
Shift+UpExtends or collapses the selection upward by one cell.
Ctrl+Shift+UpExtends the selection to the upper edge of the current data region.
Ctrl+DownMoves to the lower edge of the current data region.
Shift+DownExtends or collapse the selection downward by one cell.
Alt+DownOpens the selected drop-down list.
Ctrl+Shift+DownExtends the selection to the lower edge of the current data region.
HomeMoves to the first cell of the current row.
Ctrl+HomeMoves to the first cell of the active worksheet.
Ctrl+Shift+HomeExtends the selection to the first cell of the active worksheet.
Ctrl+EndMoves to the cell located in the lowest row containing data of the rightmost used column containing data on the active worksheet.
Ctrl+Shift+EndExtends the selection to the cell located in the lowest row containing data of the rightmost used column containing dtaa on the active worksheet.
Page UpMoves up to the previous screen of the worksheet.
Shift+Page UpExtends the selection to the end of the previous screen.
Ctrl+Page Up
Ctrl+Shift+Page Up
Selects the corresponding range in the previous worksheet or moves to the previous chart in the workbook.
Alt+Page UpMoves one screen to the left in the worksheet.
Page DownMoves down to the next screen of the worksheet
Shift+Page DownExtends the selection to the beginning of the next screen.
Ctrl+Page Down
Ctrl+Shift+Page Down
Selects the corresponding range in the next worksheet or moves to the next chart in the workbook.
Alt+Page DownMoves one screen to the right in the worksheet.
Ctrl+SpaceSelects the current column in the worksheet.
Shift+SpaceSelects the current row in the worksheet.
Ctrl+Shift+SpaceSelects the entire worksheet or the current data region (the rectangular region containing filled cells around the active cell). Pressing Ctrl+Shift+Space a second time selects the entire worksheet.
EscCancels the current action, such as editing of the current cell.

Leave a Reply

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