MPUG has done the work for you! We spent some time compiling some of the most useful Microsoft® Excel keyboard shortcuts. Keeping this page bookmarked for reference will help make your life a little bit easier. Be sure to also check out our Microsoft® Project Keyboard Shortcuts and Microsoft® SharePoint Keyboard Shortcuts.

Print or Download the Microsoft® Excel Keyboard Shortcuts

Keystroke

Result

Alt | F10Displays main access keys for Ribbon tabs
Alt + W + IOpens the View tab > Switches to Page Break Preview
Alt + W + LOpens the View tab > Switches to Normal view
Alt + W + POpens the View tab > Switches to Page Layout view
Alt + AOpens the Data tab and displays main access keys
Alt + Down ArrowOpens the drop down menu for the current cell
Alt + EnterBreaks a line in the selected cell
Alt + FOpen the File tab and displays access keys
Alt + F1Generates an embedded chart using the current range data
Alt + F11Launches Microsoft Visual Basic
Alt + F4Closes the program
Alt + F8Opens the macro dialogue box, where you can create, run, edit, or delete macros
Alt + HGoes to the Home tab and displays access keys
Alt + H > A > CCenter align contents in the selected cell
Alt + H > BOpens the borders drop down menu, where you can select a border
Alt + H > HOpens the fill drop down menu, where you can select fill color
Alt + H > D > CDeletes the current column; Opens the Home tab > opens the Delete cells menu > Selects the Delete Column option
Alt + MOpens the Formula tab and displays access keys
Alt + M > M > DOpens "Define Name" dialogue box
Alt + NOpens the Insert tab and displays access keys
Alt + POpens the Page Layout tab and displays access keys
Alt + Page DownShifts spreadsheet view, one screen to the right within the worksheet.
Alt + Page UpShifts spreadsheet view, one screen to the left within the worksheet.
Alt + Q > enter search item in dialogue boxActivates the "Tell me what you want to do" search/help function
Alt + ROpens the Review tab and displays access keys
Alt + Shift + F1Creates a new spreadsheet
Alt + SpacebarLaunches Launchy
Alt + WOpens the View tab and displays access keys
Arrow KeysNavigate (up, down, left, or right) within a worksheet
BackspaceDeletes selected cell contents and one character to the left in the formula bar
Ctrl + ' | Ctrl + D | Ctrl + Shift + "Copies content from the above cell into the selected cell
Ctrl + ;Inserts current date into selected cell
Ctrl + 0Hides selected column(s)
Ctrl + 1Opens the Format Cells dialog box
Ctrl + 2 | Ctrl + BAdd or remove bold formatting
Ctrl + 3 | Ctrl + IAdd or remove italicized formatting
Ctrl + 4 | Ctrl + UAdd or remove underline formatting
Ctrl + 5Add or removes strikethrough formatting
Ctrl + 6Hides/Unhides hidden objects, comments, and placeholders
Ctrl + 8Hide/Unhide outline symbols
Ctrl + 9Hide/Unhide current or selected rows
Ctrl+ A | Ctrl + Shift + SpacebarSelects all content on the active worksheet
Ctrl + Alt + F9 | F9Calculates all worksheets in all open workbooks
Ctrl + Alt + Shift + F9Double check your dependent formulas and calculate all worksheets in open workbooks
Ctrl + Alt + VOpens the Paste Special dialog box
Ctrl + CCopy
Ctrl + EActivates the Flash Fill - looks for patterns and auto fills cells
Ctrl + EndShifts down to the last cell on the active worksheet
Ctrl + F | Ctrl + H | Shift + F5Opens the Find and Replace dialog box
Ctrl + F1Hides or unhides the ribbon
Ctrl + F10Maximizes or restores down the active workbook
Ctrl + F2 | Ctrl + POpens the Print section on the File tab and activates the Print View on the active spreadsheet
Ctrl + F4 | Ctrl + WCloses the active workbook
Ctrl + F5Restores down the active workbook
Ctrl + F6Switch between opened workbooks
Ctrl + F7Activates the Move command (When the active workbook is not maximized)
Ctrl + F9Minimizes the active workbook
Ctrl + G | F5Opens the Go To dialog box
Ctrl + HomeMoves to the first cell (i.e. A1) in the active workbook
Ctrl + KOpens the Insert hyperlink dialog box
Ctrl + L | Ctrl + TOpens the Create Table dialog box and selects the data range on the active worksheet
Ctrl + -Opens the Delete dialog box, select desired rows or columns to delete
Ctrl + NOpens/creates a new workbook
Ctrl + OOpens the Open a new workbook section, under the File tab
Ctrl + Page DownSwitches to the next sheet (to the right) in the active workbook
Ctrl + Page UpSwitches to the previous sheet (to the left) in the active workbook
Ctrl + QOpens the Quick Analysis options for cells that have data
Ctrl + RCopies data from the cell to the left of the current cell
Ctrl + SSave
Ctrl + Shift_Removes the border formatting from the active or selected cells
Ctrl + Shift + !Changes active or selected cells to the Number format
Ctrl + Shift+ $Changes active or selected cells to the Currency format
Ctrl + Shift + %Changes active or selected cells to the Percentage format
Ctrl + Shift + &Formats cell with the Outside Border to active or selected cells
Ctrl + Shift + (Unhides hidden rows
Ctrl + Shift + )Unhides hidden columns
Ctrl + Shift + *Selects all data in the current worksheet
Ctrl + Shift + :Inserts current time into the selected cell
Ctrl + Shift + @Changes active or selected cells to the Time format
Ctrl + shift+ ^Changes active or selected cells to the Exponential number format
Ctrl + Shift + APuts argument names and parentheses in the cell, only when applied to right of a function
Ctrl + Shift + EndSelects all cells from the current cell to the end of the worksheet
Ctrl + Shift + F | Ctrl + Shift + POpens the Font tab in the Format Cells dialog box
Ctrl + Shift + HomeSelects all cells from the current cell to the beginning of the worksheet
Ctrl + Shift + OSelects all cells with comments in the current worksheet
Ctrl + Shift + Page DownMoves you to the bottom of the next worksheet (to the right)
Ctrl + Shift + Page UpMoves you to the bottom of the previous worksheet (to the left)
Ctrl + Shift + +Opens the Insert dialog box to insert new rows or columns
Ctrl + Shift + SpacebarSelects all cells with data in the current worksheet
Ctrl + Shift + ~Changes active or selected cells to the General number format
Ctrl + Shift + UHides or unhides the formula bar
Ctrl + SpacebarSelects a whole column in the current worksheet
Ctrl + VPaste
Ctrl + XCut
Ctrl + YRedo
Ctrl + ZUndo
DeleteClears cell contents
EnterCompletes the entry and move to the cell below
EscDeletes new entries in the formula bar
F1Opens the Excel Help dialog box
F11Creates a chart in a new worksheet from the current data range
F12Opens the Save As dialog box
F2Edit selected cell
F7Opens the Spell check dialog box
F8Turns extend mode on and off
HomeMoves to the first cell in the current/active row
Shift + Left/Right Arrow KeyExpands selection one cell to the left/right
Shift + EnterCompletes the entry and moves to the cell above
Shift + F10Opens the shortcut menu
Shift + F11Creates a new worksheet
Shift + F2Create or edit a comment
Shift + F3Opens the Insert Function dialog box
Shift + F4Moves one cell down
Shift + F8Adds selected cells to current selection
Shift + F9Calculates the current worksheet
Shift + SpacebarSelects a whole row in the current worksheet
TabNavigate one cell to the right

Print or Download the Microsoft® Excel Keyboard Shortcuts