Microsoft Excel keyboard shortcuts cheat sheet

Printable cheat sheet covering all 222 Microsoft Excel 2025 keyboard shortcuts and hotkeys, organized by category. Export as PDF or print directly.

All shortcuts

Shift+Tab — Move to the previous cell in a worksheet or the previous option in a dialog
ArrowUp — Move one cell up in a worksheet
ArrowDown — Move one cell down in a worksheet
ArrowLeft — Move one cell left in a worksheet
ArrowRight — Move one cell right in a worksheet
End — Activate End mode
Ctrl+End — Move to the last cell on a worksheet, to the lowest used row of the rightmost used column
Ctrl+Shift+End — Extend the selection of cells to the last used cell on the worksheet (lower-right corner)
ScrollLock — Toggle Scroll Lock mode
Ctrl+Home — Move to the beginning of a worksheet
PageDown — Move one screen down in a worksheet
Ctrl+PageDown — Move to the next sheet in a workbook
Alt+PageDown — Move one screen to the right in a workbook
PageUp — Move one screen up in a worksheet
Alt+PageUp — Move one screen to the left in a worksheet
Ctrl+PageUp — Move to the previous sheet in a workbook
Tab — Move one cell to the right in a worksheet
Alt+ArrowDown — Open the list of validation choices on a cell that has data validation options applied to it
Ctrl+Alt+5 — Cycle through floating shapes (such as text boxes or images)
Escape — Exit the floating shape navigation and return to the normal navigation
Ctrl+1 — Open the Format Cells dialog
Ctrl+Shift+F — Format fonts in the Format Cells dialog
F2 — Edit the active cell and put the insertion point at the end of its contents
Shift+F2 — Add or edit a cell comment
Ctrl+Shift+Minus — Open the Delete dialog to delete selected cells
Ctrl+Semicolon — Enter the current date
Ctrl+Backquote — Switch between displaying cell values or formulas in the worksheet
Ctrl+Quote — Copy a formula from the cell above the active cell into the cell or Formula Bar
Ctrl+X — Move the selected cells
Ctrl+C — Copy the selected cells
Ctrl+V — Paste content at the insertion point, replacing any selection
Ctrl+Alt+V — Open the Paste Special dialog
Ctrl+I — Italicize text (toggle)
Ctrl+B — Bold text (toggle)
Ctrl+U — Underline text (toggle)
Ctrl+5 — Apply or remove strikethrough formatting
Ctrl+6 — Switch between hiding objects, displaying objects, and displaying placeholders for objects
Ctrl+8 — Display or hide the outline symbols
Ctrl+D — Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl+K — Open the Insert hyperlink dialog
F7 — Check spelling in the active worksheet or selected range
Ctrl+Q — Display the Quick Analysis options for selected cells that contain data
Ctrl+L — Display the Create Table dialog
Ctrl+A — Select the entire worksheet
Ctrl+Shift+PageDown — Select the current and next sheet in a workbook
Ctrl+Shift+PageUp — Select the current and previous sheet in a workbook
F8 — Turn extend mode on and use the arrow keys to extend a selection (toggle)
Shift+F8 — Add a non-adjacent cell or range to a selection of cells by using the arrow keys
Alt+Enter — Start a new line in the same cell
Ctrl+Enter — Fill the selected cell range with the current entry
Shift+Enter — Complete a cell entry and select the cell above
Ctrl+Space — Select an entire column in a worksheet
Shift+Space — Select an entire row in a worksheet
Ctrl+Shift+Space — Select all objects on a worksheet when an object is selected
Ctrl+Shift+Home — Extend the selection of cells to the beginning of the worksheet
Ctrl+A — Select the current region if the worksheet contains data
Home — Select the first command on the menu when a menu or submenu is visible
Ctrl+Y — Repeat the last command or action, if possible
Ctrl+Z — Undo the last action
F2 — Edit the active cell and put the insertion point at the end of its contents
Ctrl+Shift+U — Expand or collapse the formula bar
Escape — Cancel an entry in the cell or Formula Bar
Enter — Complete an entry in the formula bar and select the cell below
Ctrl+End — Move the cursor to the end of the text when in the formula bar
Ctrl+Shift+End — Select all text in the formula bar from the cursor position to the end
F9 — Calculate all worksheets in all open workbooks
Shift+F9 — Calculate the active worksheet
Ctrl+Alt+F9 — Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
Shift+Alt+F10 — Display the menu or message for an Error Checking button
Ctrl+A — Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula
Ctrl+Shift+A — Insert argument names and parentheses when the insertion point is to the right of a function name in a formula
Ctrl+E — Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column
F4 — Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected
Shift+F3 — Insert a function
Ctrl+Shift+Quote — Copy the value from the cell above the active cell into the cell or formula bar
Alt+F1 — Create an embedded chart of the data in the current range
F11 — Create a chart of the data in the current range in a separate Chart sheet
Alt+M — Define a name to use in references
F3 — Paste a name from the Paste Name dialog
Enter — Move to the first field in the next record of a data form
Alt+F8 — Create, run, edit, or delete a macro
Alt+F11 — Open the Microsoft Visual Basic for Applications Editor
Ctrl+A — Select the entire table
Ctrl+C — Copy selected data
Ctrl+D — Delete the table
Ctrl+M — Move the table
Ctrl+R — Rename the table
Ctrl+S — Save the file
Ctrl+Y — Redo the last action
Ctrl+Z — Undo the last action
Ctrl+Space — Select the current column
Shift+Space — Select the current row
Shift+PageUp — Select all cells from the current location to the last cell of the column
Shift+PageDown — Select all cells from the current location to the first cell of the column
Shift+End — Select all cells from the current location to the last cell of the row
Shift+Home — Select all cells from the current location to the first cell of the row
Ctrl+PageUp — Move to the previous table
Ctrl+PageDown — Move to the next table
Ctrl+Home — Move to the first cell in the upper left corner of the selected table
Ctrl+End — Move to the last cell in the lower right corner of the selected table
Ctrl+ArrowLeft — Move to the first cell of selected row
Ctrl+ArrowRight — Move to the last cell of selected row
Ctrl+ArrowUp — Move to the first cell of selected column
Ctrl+ArrowDown — Move to the last cell of selected column
Ctrl+Escape — Close a dialog or cancel a process, such as a paste operation
Alt+ArrowDown — Open the AutoFilter Menu dialog
F5 — Open the Go To dialog
F9 — Recalculate all formulas in the Power Pivot window
Ctrl+Shift+L — Add or remove filter
Alt+H — Center align cell contents
Alt+H — Left align cell contents
Alt+H — Choose a fill color
Ctrl+W — Close workbook
Ctrl+P — Print
Ctrl+Minus — Delete selected column
Ctrl+F — Find
Ctrl+H — Replace
Shift+F4 — Find next match
Ctrl+Shift+F4 — Find previous match
Ctrl+0 — Hide selected columns
Ctrl+9 — Hide selected rows
Ctrl+N — New workbook
Shift+F10 — Open context menu
Ctrl+O — Open workbook
Delete — Remove cell contents
Alt+H — Right align cell contents
Ctrl+Shift+0 — Unhide columns
Ctrl+Shift+9 — Unhide rows
Ctrl+Alt+Equal — Zoom in
Ctrl+Alt+Minus — Zoom out
Space — Activate selected button
Ctrl+F1 — Expand / collapse the ribbon
F10 — Select active tab and activate access keys
Ctrl+G — Show Go To Dialog
Ctrl+Shift+Semicolon — Enter current time
Ctrl+T — Insert Table
Ctrl+Shift+F2 — Insert threaded comment
Ctrl+Shift+Equal — Open Insert dialog to insert cells
Shift+ArrowDown — Extend cell selection downwards
Shift+ArrowLeft — Extend cell selection to the left
Shift+ArrowRight — Extend cell selection to the right
Shift+ArrowUp — Extend cell selection upwards
Ctrl+Shift+ArrowDown — Extend selection to last bottom cell
Ctrl+Shift+ArrowLeft — Extend selection to last left cell
Ctrl+Shift+ArrowRight — Extend selection to last right cell
Ctrl+Shift+ArrowUp — Extend selection to last top cell
Ctrl+Slash — Select current array
Ctrl+Backslash — Select differences in row
Alt+Semicolon — Select only visible cells
Alt+Equal — Autosum selection of cells
Ctrl+F3 — Define name for references
Ctrl+Shift+Enter — Input array formula
Alt+Q — Go to Search field
Alt+A — Open Data tab
Alt+F — Open File page
Alt+H — Open Home tab
Alt+N — Open Insert tab
Alt+P — Open Page Layout tab
Alt+R — Open Review tab
Alt+W — Open View tab
Ctrl+Alt+V — Paste Special formats
Ctrl+Alt+V — Paste Special values
Ctrl+Alt+V — Paste Special formulas
Ctrl+Alt+V — Paste Special comments
Alt+F4 — Close Excel
Ctrl+F4 — Close workbook window
Shift+Alt+F1 — Insert new worksheet
Ctrl+F10 — Maximize workbook
Ctrl+F9 — Minimize workbook
F1 — Open Excel Help
Ctrl+F2 — Open print preview
F12 — Open Save As dialog
Shift+F7 — Open Thesaurus
Ctrl+F7 — Perform moving of window
Ctrl+F8 — Perform resizing of window
Ctrl+F5 — Restore window size of workbook
F6 — Switch panes
Shift+F6 — Switch panes in reverse
Ctrl+F6 — Switch to next workbook
Ctrl+J — Open Intellisense Dropdown
Alt+E — Redo last action
Shift+Alt+ArrowRight — Group selected items
Alt+D — Open old PivotTable Wizard
Ctrl+Alt+F5 — Refresh Pivot Table
Shift+Alt+ArrowLeft — Ungroup selected items
Ctrl+K — Comment multiple lines in DAX
Shift+Alt+ArrowDown — Copy line down in DAX
Shift+Alt+ArrowUp — Copy line up in DAX
Ctrl+Delete — Delete a word in DAX
Ctrl+Shift+K — Delete multiple lines in DAX
Ctrl+Alt+ArrowDown — Enter lines of code in DAX
Ctrl+BracketRight — Indent line in DAX
Ctrl+Shift+Backslash — Jump to matching bracket in DAX
Ctrl+Shift+B — Move an object down in layering
Alt+ArrowUp — Move line up in DAX
Ctrl+BracketLeft — Outdent line in DAX
Alt+I — Restart Intellisense
Shift+Alt+F11 — Show data
Shift+Alt+A — Toggle commenting of code
Ctrl+Equal — Toggle commenting of lines that has a word

Other Productivity apps

Microsoft Excel keyboard shortcuts cheat sheet

Printable cheat sheet covering all 222 Microsoft Excel 2025 keyboard shortcuts and hotkeys, organized by category. Export as PDF or print directly.

All shortcuts

Shift+Tab — Move to the previous cell in a worksheet or the previous option in a dialog
ArrowUp — Move one cell up in a worksheet
ArrowDown — Move one cell down in a worksheet
ArrowLeft — Move one cell left in a worksheet
ArrowRight — Move one cell right in a worksheet
End — Activate End mode
Ctrl+End — Move to the last cell on a worksheet, to the lowest used row of the rightmost used column
Ctrl+Shift+End — Extend the selection of cells to the last used cell on the worksheet (lower-right corner)
ScrollLock — Toggle Scroll Lock mode
Ctrl+Home — Move to the beginning of a worksheet
PageDown — Move one screen down in a worksheet
Ctrl+PageDown — Move to the next sheet in a workbook
Alt+PageDown — Move one screen to the right in a workbook
PageUp — Move one screen up in a worksheet
Alt+PageUp — Move one screen to the left in a worksheet
Ctrl+PageUp — Move to the previous sheet in a workbook
Tab — Move one cell to the right in a worksheet
Alt+ArrowDown — Open the list of validation choices on a cell that has data validation options applied to it
Ctrl+Alt+5 — Cycle through floating shapes (such as text boxes or images)
Escape — Exit the floating shape navigation and return to the normal navigation
Ctrl+1 — Open the Format Cells dialog
Ctrl+Shift+F — Format fonts in the Format Cells dialog
F2 — Edit the active cell and put the insertion point at the end of its contents
Shift+F2 — Add or edit a cell comment
Ctrl+Shift+Minus — Open the Delete dialog to delete selected cells
Ctrl+Semicolon — Enter the current date
Ctrl+Backquote — Switch between displaying cell values or formulas in the worksheet
Ctrl+Quote — Copy a formula from the cell above the active cell into the cell or Formula Bar
Ctrl+X — Move the selected cells
Ctrl+C — Copy the selected cells
Ctrl+V — Paste content at the insertion point, replacing any selection
Ctrl+Alt+V — Open the Paste Special dialog
Ctrl+I — Italicize text (toggle)
Ctrl+B — Bold text (toggle)
Ctrl+U — Underline text (toggle)
Ctrl+5 — Apply or remove strikethrough formatting
Ctrl+6 — Switch between hiding objects, displaying objects, and displaying placeholders for objects
Ctrl+8 — Display or hide the outline symbols
Ctrl+D — Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl+K — Open the Insert hyperlink dialog
F7 — Check spelling in the active worksheet or selected range
Ctrl+Q — Display the Quick Analysis options for selected cells that contain data
Ctrl+L — Display the Create Table dialog
Ctrl+A — Select the entire worksheet
Ctrl+Shift+PageDown — Select the current and next sheet in a workbook
Ctrl+Shift+PageUp — Select the current and previous sheet in a workbook
F8 — Turn extend mode on and use the arrow keys to extend a selection (toggle)
Shift+F8 — Add a non-adjacent cell or range to a selection of cells by using the arrow keys
Alt+Enter — Start a new line in the same cell
Ctrl+Enter — Fill the selected cell range with the current entry
Shift+Enter — Complete a cell entry and select the cell above
Ctrl+Space — Select an entire column in a worksheet
Shift+Space — Select an entire row in a worksheet
Ctrl+Shift+Space — Select all objects on a worksheet when an object is selected
Ctrl+Shift+Home — Extend the selection of cells to the beginning of the worksheet
Ctrl+A — Select the current region if the worksheet contains data
Home — Select the first command on the menu when a menu or submenu is visible
Ctrl+Y — Repeat the last command or action, if possible
Ctrl+Z — Undo the last action
F2 — Edit the active cell and put the insertion point at the end of its contents
Ctrl+Shift+U — Expand or collapse the formula bar
Escape — Cancel an entry in the cell or Formula Bar
Enter — Complete an entry in the formula bar and select the cell below
Ctrl+End — Move the cursor to the end of the text when in the formula bar
Ctrl+Shift+End — Select all text in the formula bar from the cursor position to the end
F9 — Calculate all worksheets in all open workbooks
Shift+F9 — Calculate the active worksheet
Ctrl+Alt+F9 — Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
Shift+Alt+F10 — Display the menu or message for an Error Checking button
Ctrl+A — Display the Function Arguments dialog when the insertion point is to the right of a function name in a formula
Ctrl+Shift+A — Insert argument names and parentheses when the insertion point is to the right of a function name in a formula
Ctrl+E — Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column
F4 — Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected
Shift+F3 — Insert a function
Ctrl+Shift+Quote — Copy the value from the cell above the active cell into the cell or formula bar
Alt+F1 — Create an embedded chart of the data in the current range
F11 — Create a chart of the data in the current range in a separate Chart sheet
Alt+M — Define a name to use in references
F3 — Paste a name from the Paste Name dialog
Enter — Move to the first field in the next record of a data form
Alt+F8 — Create, run, edit, or delete a macro
Alt+F11 — Open the Microsoft Visual Basic for Applications Editor
Ctrl+A — Select the entire table
Ctrl+C — Copy selected data
Ctrl+D — Delete the table
Ctrl+M — Move the table
Ctrl+R — Rename the table
Ctrl+S — Save the file
Ctrl+Y — Redo the last action
Ctrl+Z — Undo the last action
Ctrl+Space — Select the current column
Shift+Space — Select the current row
Shift+PageUp — Select all cells from the current location to the last cell of the column
Shift+PageDown — Select all cells from the current location to the first cell of the column
Shift+End — Select all cells from the current location to the last cell of the row
Shift+Home — Select all cells from the current location to the first cell of the row
Ctrl+PageUp — Move to the previous table
Ctrl+PageDown — Move to the next table
Ctrl+Home — Move to the first cell in the upper left corner of the selected table
Ctrl+End — Move to the last cell in the lower right corner of the selected table
Ctrl+ArrowLeft — Move to the first cell of selected row
Ctrl+ArrowRight — Move to the last cell of selected row
Ctrl+ArrowUp — Move to the first cell of selected column
Ctrl+ArrowDown — Move to the last cell of selected column
Ctrl+Escape — Close a dialog or cancel a process, such as a paste operation
Alt+ArrowDown — Open the AutoFilter Menu dialog
F5 — Open the Go To dialog
F9 — Recalculate all formulas in the Power Pivot window
Ctrl+Shift+L — Add or remove filter
Alt+H — Center align cell contents
Alt+H — Left align cell contents
Alt+H — Choose a fill color
Ctrl+W — Close workbook
Ctrl+P — Print
Ctrl+Minus — Delete selected column
Ctrl+F — Find
Ctrl+H — Replace
Shift+F4 — Find next match
Ctrl+Shift+F4 — Find previous match
Ctrl+0 — Hide selected columns
Ctrl+9 — Hide selected rows
Ctrl+N — New workbook
Shift+F10 — Open context menu
Ctrl+O — Open workbook
Delete — Remove cell contents
Alt+H — Right align cell contents
Ctrl+Shift+0 — Unhide columns
Ctrl+Shift+9 — Unhide rows
Ctrl+Alt+Equal — Zoom in
Ctrl+Alt+Minus — Zoom out
Space — Activate selected button
Ctrl+F1 — Expand / collapse the ribbon
F10 — Select active tab and activate access keys
Ctrl+G — Show Go To Dialog
Ctrl+Shift+Semicolon — Enter current time
Ctrl+T — Insert Table
Ctrl+Shift+F2 — Insert threaded comment
Ctrl+Shift+Equal — Open Insert dialog to insert cells
Shift+ArrowDown — Extend cell selection downwards
Shift+ArrowLeft — Extend cell selection to the left
Shift+ArrowRight — Extend cell selection to the right
Shift+ArrowUp — Extend cell selection upwards
Ctrl+Shift+ArrowDown — Extend selection to last bottom cell
Ctrl+Shift+ArrowLeft — Extend selection to last left cell
Ctrl+Shift+ArrowRight — Extend selection to last right cell
Ctrl+Shift+ArrowUp — Extend selection to last top cell
Ctrl+Slash — Select current array
Ctrl+Backslash — Select differences in row
Alt+Semicolon — Select only visible cells
Alt+Equal — Autosum selection of cells
Ctrl+F3 — Define name for references
Ctrl+Shift+Enter — Input array formula
Alt+Q — Go to Search field
Alt+A — Open Data tab
Alt+F — Open File page
Alt+H — Open Home tab
Alt+N — Open Insert tab
Alt+P — Open Page Layout tab
Alt+R — Open Review tab
Alt+W — Open View tab
Ctrl+Alt+V — Paste Special formats
Ctrl+Alt+V — Paste Special values
Ctrl+Alt+V — Paste Special formulas
Ctrl+Alt+V — Paste Special comments
Alt+F4 — Close Excel
Ctrl+F4 — Close workbook window
Shift+Alt+F1 — Insert new worksheet
Ctrl+F10 — Maximize workbook
Ctrl+F9 — Minimize workbook
F1 — Open Excel Help
Ctrl+F2 — Open print preview
F12 — Open Save As dialog
Shift+F7 — Open Thesaurus
Ctrl+F7 — Perform moving of window
Ctrl+F8 — Perform resizing of window
Ctrl+F5 — Restore window size of workbook
F6 — Switch panes
Shift+F6 — Switch panes in reverse
Ctrl+F6 — Switch to next workbook
Ctrl+J — Open Intellisense Dropdown
Alt+E — Redo last action
Shift+Alt+ArrowRight — Group selected items
Alt+D — Open old PivotTable Wizard
Ctrl+Alt+F5 — Refresh Pivot Table
Shift+Alt+ArrowLeft — Ungroup selected items
Ctrl+K — Comment multiple lines in DAX
Shift+Alt+ArrowDown — Copy line down in DAX
Shift+Alt+ArrowUp — Copy line up in DAX
Ctrl+Delete — Delete a word in DAX
Ctrl+Shift+K — Delete multiple lines in DAX
Ctrl+Alt+ArrowDown — Enter lines of code in DAX
Ctrl+BracketRight — Indent line in DAX
Ctrl+Shift+Backslash — Jump to matching bracket in DAX
Ctrl+Shift+B — Move an object down in layering
Alt+ArrowUp — Move line up in DAX
Ctrl+BracketLeft — Outdent line in DAX
Alt+I — Restart Intellisense
Shift+Alt+F11 — Show data
Shift+Alt+A — Toggle commenting of code
Ctrl+Equal — Toggle commenting of lines that has a word