Windows 11 Excel Keyboard Shortcuts for Faster Work

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows 11, the most useful keyboard shortcuts include Ctrl+S to save, Ctrl+Z to undo, Ctrl+Arrow to move through data, Ctrl+1 to format cells, and Alt+= to insert AutoSum. These shortcuts work in the Excel desktop app; Excel in a browser can handle some keys differently, and Mac shortcuts are not always the same.

How Excel shortcuts work on Windows 11

Windows 11 does not have a separate set of Excel shortcuts: the shortcuts below are for the Windows desktop version of Excel, regardless of whether the computer runs Windows 11 or another supported Windows version. In the key combinations, Ctrl means the Control key, Alt means the Alt key, and Shift means the Shift key. A plus sign means to hold the keys together. For example, press and hold Ctrl, then press S to save.

Some combinations depend on what Excel is doing. F4, for instance, can repeat an action or cycle through reference styles while you are editing a formula. On a laptop, function keys may also control brightness or volume; if pressing F2 or F4 triggers a hardware function, try holding Fn as well, or check the laptop’s function-key setting.

Excel also offers ribbon KeyTips. Press Alt to show letters for ribbon tabs and commands, then press the displayed letters in sequence. This is useful when a command has no shortcut you remember: follow the on-screen prompts rather than guessing a key sequence, which can vary with the ribbon and interface.

Shortcuts for workbooks and everyday editing

These combinations cover common file and cell-editing tasks. They are a good starting set to learn before memorizing less frequent commands.

  • Ctrl+N: Create a new workbook. Ctrl+O: Open a workbook. Ctrl+S: Save the current workbook.
  • Ctrl+P: Open print settings. Check the preview and selected print area before printing, since a shortcut does not ensure that the intended cells fit on a page.
  • Ctrl+C, Ctrl+X, Ctrl+V: Copy, cut, and paste. Ctrl+Z undoes an action; Ctrl+Y generally redoes an undone action.
  • Ctrl+F: Find text or values. Ctrl+H: Open Find and Replace. Review the search scope and replacement options before using Replace All.
  • Ctrl+K: Insert a hyperlink. Ctrl+W: Close the current workbook window.
  • F2: Edit the active cell. This lets you change a value or formula in place without replacing the entire cell contents.

Excel’s undo history is useful but not unlimited, and some operations cannot be undone. Saving regularly with Ctrl+S is a sensible habit, particularly before broad replacements, imports, or other workbook-wide changes.

Move around a worksheet and select cells

Keyboard navigation is especially useful in large sheets, where scrolling can make it hard to keep track of the active cell. The arrow keys move one cell at a time; these combinations cover longer jumps and selections.

  • Ctrl+Arrow: Move to the edge of a continuous block of data in the arrow’s direction. A blank cell or gap can change where Excel stops, so this does not always mean “go to the last row.”
  • Ctrl+Home: Move to the beginning of the worksheet. Ctrl+End moves to the last cell Excel considers used, which may be farther down or across than the visible data if formatting was applied to extra cells.
  • Ctrl+Page Up and Ctrl+Page Down: Move to the previous or next worksheet tab in the workbook.
  • F5 or Ctrl+G: Open Go To, where you can enter a cell address such as D250 and jump directly there.
  • Shift+Arrow: Extend a selection by one cell. Ctrl+Shift+Arrow extends it to the edge of a data region.
  • Ctrl+Space: Select the current column. Shift+Space selects the current row.
  • Ctrl+Shift+End: Extend the selection from the active cell to Excel’s last used cell.

Ctrl+A selects the current data region in many worksheet contexts; pressing it again can expand the selection, and behavior depends on where the active cell is. For a reliable full-sheet selection, use the Select All button at the corner where the row and column headings meet. This distinction matters when you intend to format or copy an entire worksheet rather than one table.

Enter data and fill repeated values

Several shortcuts make data entry faster without relying on the mouse. They are particularly helpful when filling a consistent date, label, formula, or value across a selected range.

  • Enter confirms an entry and typically moves the selection down; Tab confirms it and moves right.
  • Alt+Enter inserts a line break within a cell while you are editing it. It does not move to another cell.
  • Ctrl+Enter enters the same typed content into all cells in a selected range. Select the range first, type the content, then press the shortcut.
  • Ctrl+D fills down from the cell above into the selected cells. Ctrl+R fills right from the cell to the left.
  • Ctrl+; inserts the current date as a fixed value. Ctrl+Shift+; inserts the current time as a fixed value.
  • Ctrl+E runs Flash Fill when Excel can infer a pattern from nearby examples, such as separating first names from full names. Review the results, especially where the source data is inconsistent.

These are not all equivalent to formulas. A date inserted with Ctrl+; is a value that stays unchanged; it does not update each day. Likewise, Fill Down copies or adjusts what is above according to Excel’s rules, while Ctrl+Enter repeats what you typed in the selected cells.

Work with formulas and calculations

For quick totals, place the active cell beside or below a suitable range and press Alt+= to insert AutoSum. Excel proposes a range for a SUM formula; check the highlighted cells before confirming, since blank rows or neighboring values can affect the proposed selection.

While editing a formula, F4 cycles the reference under the insertion point through relative and absolute forms. For example, selecting the A1 reference in a formula and pressing F4 changes it to $A$1; pressing again cycles to other combinations of fixed row and column references. This is useful when copying formulas, because a reference such as A1 normally adjusts when copied, while $A$1 stays fixed.

Ctrl+` toggles the display between formula results and formulas in the worksheet. The grave accent is usually the key near the upper-left of a standard keyboard, though layouts vary. This display mode helps inspect a sheet’s formulas, but it does not change the calculations themselves.

Excel usually recalculates formulas automatically. If a workbook is set to manual calculation, use the Formulas tab’s calculation options to check the setting. Keyboard recalculation commands also exist, but the appropriate one depends on whether you want to recalculate a sheet or a broader set of open workbooks; changing calculation settings is different from simply showing formulas.

Format cells and make tables easier to read

Ctrl+1 opens the Format Cells dialog, a practical shortcut when you need to choose a number format, alignment, font, border, or fill without searching through ribbon tabs. It is often more precise than applying a quick format when the displayed values need a specific number of decimal places or date style.

  • Ctrl+B, Ctrl+I, Ctrl+U: Toggle bold, italic, and underline for selected cells or text being edited.
  • Ctrl+Shift+$: Apply a currency format. Ctrl+Shift+%: Apply a percentage format.
  • Ctrl+Shift+#: Apply a date format. Ctrl+Shift+@: Apply a time format.
  • Ctrl+Shift+!: Apply a number format with two decimal places and a thousands separator. Ctrl+Shift+~ applies the General format.

Formatting changes how a value appears, not necessarily the underlying value. For example, a percentage format displays a numeric value as a percentage, so check the cell’s actual value and the resulting display before sharing a report.

Shortcuts for tables, filters, and rows

When a range contains related records with column headings, Ctrl+T opens the Create Table dialog. Confirm that Excel identified the correct range and whether the table has headers. Tables provide built-in filter buttons and help keep formatting and formulas consistent as rows are added.

  • Ctrl+Shift+L: Turn AutoFilter buttons on or off for a range. If a table already has filter buttons, use its header dropdown to filter the records.
  • Alt+Down Arrow: Open a dropdown list or filter menu from a cell where that dropdown is available, such as a table heading.
  • Ctrl++ (Ctrl and the plus key) opens the Insert dialog for cells, rows, or columns, depending on the selection. Ctrl+- opens the Delete dialog.

Filtering hides rows that do not match the selected criteria; it does not delete those records. Before copying or reporting filtered data, check which rows are visible and whether the next operation applies to visible cells only. For a simple sort or filter, using the header controls can also make the chosen criteria easier to review later.

When shortcuts do not work

A shortcut that appears unresponsive may be intercepted by the operating system, the keyboard, or the version of Excel rather than being absent. Try these checks before assuming the command is unavailable:

  • Click a worksheet cell first. If a dialog, menu, or the formula bar has focus, the same keys may act on that control instead of the worksheet.
  • Check whether you are in Excel desktop or Excel for the web. A browser can reserve combinations for browser actions, and web Excel does not support every desktop shortcut in the same way.
  • On a laptop, try Fn with a function key. Also check whether Sticky Keys or another Windows accessibility setting has changed how modifier keys behave.
  • Check the keyboard layout and the location of punctuation keys. Shortcuts involving plus, minus, or the grave accent can be awkward on non-US layouts.
  • Use Alt to reveal ribbon KeyTips if you cannot remember a command, or look for the command on the ribbon. Some shortcuts vary by context or Excel version.

On a Mac, many familiar actions use Command instead of Ctrl—for example, Command+C to copy and Command+S to save—but that substitution is not universal. Mac keyboards and system-level shortcuts differ, so consult Excel for Mac’s shortcut reference for a specific command. Excel for the web on a Windows 11 computer is still the browser version, not the desktop app, so the device’s Windows version alone does not determine shortcut behavior.

Frequently Asked Questions

What is the shortcut to save an Excel file in Windows 11?
Press Ctrl+S in the Excel desktop app. If the workbook has not been saved before, Excel prompts you to choose a name and location.

How do I jump to the last row or column in Excel?
Press Ctrl+Down or Ctrl+Right to move to the edge of a continuous data region. If the region has blanks, Excel may stop at a blank or the next block; Ctrl+End instead moves to the worksheet’s last used cell, which may include cells with leftover formatting.

How can I select an entire row or column?
Click a cell in the row and press Shift+Space to select the row. Press Ctrl+Space to select the column containing the active cell.

What shortcut adds a line break inside an Excel cell?
While editing the cell, press Alt+Enter on Windows. This inserts a line break within the cell rather than confirming the entry and moving to another cell.

Why does Ctrl+F4 or F4 behave differently on my computer?
F4 has different uses depending on context: it can repeat an action, or cycle a formula reference while you edit a formula. A laptop may require Fn with a function key, and Ctrl+F4 is not the same as F4 by itself.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.