Windows 10 Excel Keyboard Shortcuts to Work Faster

How-to basics · Updated November 20, 2026

For Excel on Windows 10, the most useful keyboard shortcuts include Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, Ctrl+S to save, and Ctrl+Arrow keys to move to the edge of a data region. These shortcuts work in Microsoft 365 Excel for Windows; below are practical shortcuts for navigation, editing, formatting, formulas, and data, plus notes on Mac and Excel for the web.

How Excel shortcuts work on Windows 10

Excel keyboard shortcuts are key combinations that perform commands without requiring a ribbon click. Most everyday commands use Ctrl with a letter or symbol. Function keys such as F2 and F4 have specific spreadsheet uses, while Alt reveals ribbon KeyTips: press Alt, then follow the letters or numbers Excel displays on screen. KeyTips can vary with the current ribbon layout and language, so follow the visible prompts rather than memorizing a sequence from another computer.

Shortcuts are handled by Excel, Windows, and sometimes the keyboard itself. A laptop may require holding Fn to use F2 or F4, and a non-US keyboard can place symbols such as plus or backtick on different keys. If a shortcut does not behave as expected, check the key labels and Excel’s on-screen menus before concluding that the command is unavailable.

  • Ctrl is the primary modifier for most Excel shortcuts on Windows.
  • Shift commonly extends a selection or changes a shortcut’s action.
  • Alt opens ribbon KeyTips and is used by certain commands, including AutoSum.
  • Esc cancels many in-progress actions, such as editing or a selection operation.

Move around a worksheet quickly

Large worksheets are easier to navigate with movement shortcuts than by repeatedly scrolling. Ctrl+Arrow moves to the edge of the current data region in the direction pressed. For example, if a column contains an uninterrupted run of values from A2 through A50, Ctrl+Down from A2 moves to A50. If there are blank cells, Excel stops at a boundary, so the result depends on the layout.

  • Ctrl+Home moves to the beginning of the worksheet, usually cell A1.
  • Ctrl+End moves to the last cell Excel considers used. Formatting far below or to the right of visible data can make this cell appear unexpectedly distant.
  • Home moves to the first cell in the current row; Ctrl+Home moves to the worksheet start.
  • Page Up and Page Down move the view by a screenful; add Alt to move one screen left or right.
  • Ctrl+Page Up and Ctrl+Page Down switch to the previous or next worksheet tab.

These commands move the active cell or view, not the data itself. To keep a reference cell visible while scrolling through a long list, use View > Freeze Panes rather than repeatedly returning to the top.

Select cells, rows, and columns

Selection shortcuts help when applying a format or editing a block of data. Shift combined with a movement key extends the selection from the active cell. For instance, Shift+Down adds the cell below to the selection; Ctrl+Shift+Down extends to the edge of the current data region. As with Ctrl+Arrow, blank cells affect where the extension stops.

  • Ctrl+Space selects the entire column containing the active cell.
  • Shift+Space selects the entire row.
  • Ctrl+A selects the current data region in many worksheet contexts. Pressing it again can expand the selection, and behavior can depend on whether the active cell is inside a table or data block.
  • Ctrl+Shift+End selects from the active cell through the worksheet’s last used cell.
  • Shift+Arrow expands a selection one cell at a time.

Before deleting or replacing content, look at the highlighted area and the Name Box to confirm what is selected. Selecting a whole row or column is broader than selecting the visible cells in a filtered list, and a command can affect hidden rows too.

Edit cells and manage workbooks

When entering or correcting data, F2 edits the active cell in place. It is useful for changing part of a formula without replacing the whole entry. Enter confirms an edit, while Esc cancels the current edit. If a cell is selected but not being edited, typing a value replaces its existing contents, so use F2 when you intend to modify only part of what is there.

  • Ctrl+C, Ctrl+X, Ctrl+V copy, cut, and paste.
  • Ctrl+Z undoes the most recent supported action; Ctrl+Y redoes an undone action or repeats certain actions.
  • Ctrl+S saves the workbook. For a new workbook, Excel may prompt you to choose a name and location.
  • Ctrl+N creates a new workbook, and Ctrl+O opens one.
  • Ctrl+F finds content, while Ctrl+H opens Find and Replace.
  • Alt+Enter inserts a new line within a cell while you are editing its contents.

Cut and copy can leave a moving border around the source cells until you finish pasting or press Esc. Pasting over an existing range replaces its contents, so check the destination before using Ctrl+V. Undo is useful for many ordinary edits, but it is not a substitute for saving a backup before substantial changes.

Format values and cells with keys

Ctrl+1 opens the Format Cells dialog, where you can choose number formats, alignment, fonts, borders, and fill. This is particularly useful when a number looks wrong because it is displayed in an unintended format. For example, a date serial may appear as a large number; selecting the cell and choosing a date category in the dialog changes its display format, rather than changing the underlying value.

  • Ctrl+B toggles bold, Ctrl+I toggles italics, and Ctrl+U toggles underline.
  • Ctrl+Shift+L turns filter buttons on or off for a data range. It does not itself sort the rows.
  • Ctrl+T opens the Create Table dialog for a selected data range.
  • Ctrl+K opens the dialog for inserting or editing a hyperlink.
  • Ctrl+Shift+$ applies a currency format, and Ctrl+Shift+% applies a percentage format.

Number-format shortcuts change how values appear, not their stored values. A percentage format, for example, displays 0.25 as 25%; it does not turn 25 into 25 percent. In some keyboard layouts the symbols in these combinations require different physical keys, so Ctrl+1 is a useful fallback for choosing a specific format in the dialog.

Enter formulas and repeat useful actions

To total a row or column, select the cell where the result should appear and press Alt+=. Excel inserts an AutoSum formula using a range it detects nearby; inspect the highlighted range before pressing Enter, especially if the data contains blank rows or other numbers nearby. AutoSum is a quick starting point, not a guarantee that Excel has guessed the intended range.

  • F4 cycles through relative and absolute references while editing a formula and the insertion point is on a cell reference. For example, it can change A1 to $A$1. Outside that context, F4 may repeat the last action, depending on what was done and the Excel interface.
  • Ctrl+` toggles between displaying formula results and showing formulas in worksheet cells. The backtick key’s position varies by keyboard.
  • Ctrl+; inserts the current date as a fixed value.
  • Ctrl+Shift+; inserts the current time as a fixed value.

The date and time shortcuts enter values at the moment you press the keys; they do not create a live clock. This differs from a formula that recalculates. When reviewing a formula, click its cell or press F2 to inspect the expression, and use F4 only while the cell reference is active if you want to adjust its dollar signs.

Work with lists, tables, and inserted cells

Ctrl+T is a convenient way to turn a rectangular list into an Excel table. Select a cell in the list, press Ctrl+T, verify the proposed range, and indicate whether the first row contains headers. Tables provide filter buttons and can extend when new rows are added immediately below them. They also make it easier to use consistent formatting and structured references.

For a quick fill based on a recognizable pattern, Ctrl+E runs Flash Fill. For example, if a column contains full names and you type a first name beside the first example, Flash Fill may identify the pattern and suggest the remaining first names. Review the suggested results: Flash Fill creates values from a detected pattern rather than a formula that automatically updates when source data changes.

To add or remove cells, Ctrl+Shift+plus opens an Insert dialog, while Ctrl+minus opens a Delete dialog. Excel may ask whether to shift cells, rows, or columns, because inserting or deleting cells can change the surrounding layout. If your keyboard lacks a dedicated plus key, the combination may require Shift with the equals key. For whole-row or whole-column operations, selecting the row or column first makes the intended scope clearer.

Common shortcut problems and practical fixes

A shortcut may appear not to work for several ordinary reasons. Excel might be in cell-edit mode, a dialog may have focus, or the keyboard layout may interpret a symbol differently. A laptop’s Fn setting can also change what its function keys do. Try pressing Esc once, clicking a worksheet cell, and using the shortcut again. For function keys, check whether Fn is required on that device.

  • If Ctrl+Arrow stops early, check for blank cells or gaps in the data region.
  • If Ctrl+End jumps far past the visible list, formatting or old entries may have extended the used area. Inspect distant cells before deleting anything; clearing unnecessary formatting may help, but save a copy first.
  • If a shortcut triggers a browser or Windows command instead, another application may have focus or may have claimed the key combination.
  • If a ribbon command is hard to locate, press Alt and use the KeyTips Excel displays, or search for the command with the Excel search box.

Shortcuts can also differ across Excel editions, operating systems, and language settings. This guide is for Microsoft 365 Excel on Windows. Excel for the web runs inside a browser, so some key combinations may be intercepted by the browser or differ from desktop Excel; use its ribbon or command search when a desktop shortcut does not work.

Windows and Mac shortcut differences

On a Mac, many familiar commands use Command instead of Ctrl: Command+C, Command+V, Command+X, Command+Z, Command+S, and Command+F are common counterparts for copy, paste, cut, undo, save, and find. This is a useful starting point, not a rule for every Excel shortcut. Some Mac commands use different modifiers, and function keys may require Fn depending on macOS settings and the keyboard.

Do not assume that replacing Ctrl with Command will reproduce every Windows action. For a specific Mac command, consult Excel’s shortcut reference for Mac or the menus in the installed version. If you share a workbook between Windows and Mac, the formulas and data generally travel with the file, but the keyboard sequence used to edit them can differ. Excel for the web also has its own browser context, so desktop Windows combinations are not guaranteed there.

Frequently Asked Questions

What are the most useful Excel shortcuts for beginners?
Start with Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+S, Ctrl+F, Ctrl+Arrow, and F2. Together they cover copying, pasting, undoing, saving, finding, navigating, and editing a selected cell.

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

What is the shortcut to insert the current date in Excel?
Press Ctrl+; on Windows to enter today’s date as a fixed value in the selected cell. It will not update automatically on a later day.

Why does Ctrl+End go to a blank-looking cell?
Excel treats cells with content or formatting as used, even if they look blank. The last used cell can therefore be farther down or across than the visible data.

Are Windows Excel shortcuts the same on a Mac?
No. Common commands often use Command on Mac where Windows uses Ctrl, but other shortcuts differ and function keys may require Fn. Check the Mac-specific shortcut reference for a command you use regularly.

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.