Excel Shortcut Keys: Essential Commands for Windows

For Excel for Microsoft 365 on Windows, the most useful shortcut keys include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+Arrow keys to move through data, Ctrl+1 to format cells, and Alt+= to insert AutoSum. Shortcuts can speed up editing, navigation, formatting, and calculations; the right ones depend on the task and whether you use Windows, Mac, or Excel for the web.

How Excel shortcuts work

A keyboard shortcut combines keys to run a command without selecting it from the ribbon. In most Windows shortcuts, you hold Ctrl or Alt while pressing another key. For example, hold Ctrl and press C to copy. A plus sign in a shortcut listing means to press the keys together; a comma means to press one combination and then another.

Some keys behave differently depending on what Excel is doing. F4, for instance, can repeat an action, but while editing a formula it cycles through reference styles such as A1 and $A$1. Ribbon KeyTips are another kind of keyboard control: press Alt in desktop Excel to display letters for ribbon tabs and commands, then follow the on-screen prompts. Those letters can depend on the current ribbon and language, so treat the displayed prompts as the guide.

Shortcuts are useful, but they do not replace understanding the command. If you are unsure what a key combination will do, check Excel’s ribbon or tooltip first, especially before using commands that change a large selection.

Everyday editing and workbook shortcuts

These common Windows shortcuts cover routine actions. They work in many other Windows programs too, which makes them easy to remember:

Ctrl+C / Ctrl+X / Ctrl+V: Copy, cut, and paste selected cells or content.
Ctrl+Z / Ctrl+Y: Undo the last action and redo an undone action. Ctrl+Y can also repeat certain actions.
Ctrl+S: Save the workbook. For a new workbook, Excel may ask you to choose a name and location.
Ctrl+O / Ctrl+P: Open a workbook and open the print screen.
Ctrl+F / Ctrl+H: Find content and open Find and Replace.
Ctrl+B / Ctrl+I / Ctrl+U: Apply or remove bold, italic, and underline formatting.
Ctrl+K: Open the dialog for inserting or editing a hyperlink.

To edit the active cell without replacing its contents, press F2. Press Enter to accept the edit, or Esc to cancel it. To start a new line inside a cell while editing, press Alt+Enter. That is different from pressing Enter, which normally commits the entry and moves the selection.

Ctrl+1 opens the Format Cells dialog, where you can set number formats, alignment, borders, fills, and other cell properties. It is often faster than searching through several ribbon controls when you need a specific format.

Moving around a worksheet

Navigation shortcuts are especially helpful in large sheets. Ctrl+Arrow moves to the edge of the current data region in that direction. For example, if B2:B100 contains uninterrupted values, select B2 and press Ctrl+Down to move to the bottom of that block. If there is a blank cell in the way, the movement stops at the edge of the current region rather than skipping over the gap.

Ctrl+Home: Move to the beginning of the worksheet, usually cell A1.
Ctrl+End: Move to the last cell Excel considers used, which may be beyond the visible data if formatting or old entries extend the used range.
Home: Move to the beginning of the current row.
Ctrl+Page Up / Ctrl+Page Down: Switch to the previous or next worksheet tab.
F5: Open Go To, where you can enter a cell address or choose a named range.

Ctrl+End can therefore land farther down or to the right than expected. If that happens, the sheet may contain leftover formatting or previously used cells. The shortcut reports Excel’s used area; it does not necessarily identify the last meaningful value.

Selecting cells, rows, and columns

Selection shortcuts help apply the same operation to a group of cells without dragging across the sheet. Ctrl+Shift+Arrow extends the selection from the active cell toward the edge of a data region. For example, from A2 in a continuous list, Ctrl+Shift+Down selects through the bottom of that list. A blank cell can stop the selection, just as it can stop navigation.

Ctrl+Space: Select the entire column containing the active cell.
Shift+Space: Select the entire row containing the active cell.
Ctrl+A: Select the current data region; pressing it again in some contexts expands the selection.
Ctrl+Enter: Enter the same typed content into every cell in a selected range.

For example, select C2:C20, type Pending, and press Ctrl+Enter to place that entry in every selected cell. This is useful for repeated labels, but take care to select only the intended range: Ctrl+Enter applies the entry to the whole selection.

To select a complete column or row, remember that Ctrl+Space and Shift+Space are different: the first selects a column, the second a row. If a shortcut appears not to work, check whether you are editing a cell; press Enter or Esc to leave edit mode before trying it.

Formatting and data-entry shortcuts

Shortcuts can also reduce repetitive formatting work. Ctrl+Shift+L turns AutoFilter on or off for a range or table. It adds filter controls to the heading row when appropriate; it does not itself sort the records. To create an Excel table, select a cell in the data and press Ctrl+T, then confirm whether the range has headers.

Alt+= inserts the AutoSum function, commonly SUM, for a nearby row or column of numbers. Check the proposed range before pressing Enter: Excel guesses which adjacent values you want to total, and a blank or extra value can affect that guess.

Ctrl+; inserts the current date as a fixed value.
Ctrl+Shift+; inserts the current time as a fixed value.
Ctrl+` toggles the display of formulas in place of calculated results. The grave-accent key is commonly near the top-left of a US keyboard; its position varies by layout.
Ctrl+D / Ctrl+R: Fill down or fill right from the top or left cell of a selected range.

The date and time shortcuts insert values, not live clocks. They will not update automatically as the date or time changes. Ctrl+` only changes how formulas are displayed; it does not convert formulas into text or alter their calculations.

Formula editing and cell references

When entering a formula, F2 edits the active cell and the arrow keys can help position the insertion point or select references, depending on the editing state. Press F4 while the cursor is on a cell reference in a formula to cycle through relative and absolute forms. For example, A1 can cycle to $A$1, A$1, and $A1. The dollar signs lock the column, row, or both when a formula is copied.

Consider a formula such as =B2*$E$1. If it is copied down a column, B2 adjusts to B3, B4, and so on, while $E$1 stays fixed. This makes F4 useful when building formulas that refer to one constant rate or assumption. The shortcut changes the reference under the formula cursor; it does not automatically make the entire formula correct, so inspect the result after copying.

To calculate a formula, type an equals sign, enter the expression, and press Enter. If Excel displays the formula itself instead of its result, check whether Show Formulas is enabled with Ctrl+`, and check whether the cell is formatted as Text. If it is Text, change the cell to a suitable number format and re-enter the formula.

Windows and Mac differences

This guide lists Windows shortcuts for desktop Excel. On a Mac, many familiar commands use Command instead of Ctrl: for example, Command+C copies, Command+V pastes, Command+Z undoes, Command+S saves, and Command+F finds. Command+B, Command+I, and Command+U apply common text formatting.

Not every Windows shortcut has a simple Ctrl-to-Command substitution. Function keys may be assigned to macOS features, and keyboard layouts differ. You may need to hold the Fn key to use an F-key as an Excel function key, depending on your Mac’s keyboard settings. For less familiar commands, consult Excel’s shortcut list for Mac or check the menu command’s displayed shortcut rather than assuming the Windows combination will work.

Excel for the web runs inside a browser, where some key combinations may be intercepted by the browser or operating system. If a shortcut does not behave as expected, use the ribbon command or open the workbook in the Excel desktop app. The desktop Windows shortcuts above are not a promise that every browser, Mac, or mobile version behaves identically.

Common shortcut problems and practical habits

A shortcut can seem unreliable when Excel is in a different state than expected. Editing inside a cell, selecting a chart, working in a dialog, or using a laptop with special function-key behavior can change the result. Check the active selection and mode before repeating a command.

Nothing happens: Click a worksheet cell, leave edit mode with Enter or Esc, and try again. On a laptop, check whether Fn is needed for function keys.
The wrong range is selected: Look for blank cells or gaps; Ctrl+Arrow and Ctrl+Shift+Arrow stop at data-region boundaries.
A date or time does not update: Ctrl+; and Ctrl+Shift+; insert fixed values, not continuously updating functions.
Excel jumps too far with Ctrl+End: The used range may include old formatting or entries outside the data you currently see.
A shortcut conflicts with the browser: Use the Excel ribbon or switch to the desktop app.

Learn a small group of shortcuts that match your regular work rather than trying to memorize a long list at once. A useful starting set is copy, paste, undo, save, find, Ctrl+Arrow navigation, Ctrl+1, and Ctrl+Shift+L. Try each on a small sample before using it on an important workbook, and save before making substantial changes.

Frequently Asked Questions

What is the shortcut for saving an Excel file?
In Excel for Microsoft 365 on Windows, press Ctrl+S. On a Mac, use Command+S. If the workbook has not been saved before, Excel will prompt you to choose a file name and location.

How do I quickly add a total in Excel?
Select the cell where the total should appear and press Alt+= on Windows. Excel proposes an AutoSum range; review it before pressing Enter. The Mac shortcut can differ, so use the AutoSum command on the ribbon if the keyboard combination is not available.

How do I switch between Excel worksheets with the keyboard?
In Windows desktop Excel, use Ctrl+Page Up for the previous sheet and Ctrl+Page Down for the next one. Mac keyboards and function-key settings can change how sheet-navigation combinations work, so check Excel’s Mac shortcut reference if those keys do not respond.

What shortcut edits the contents of a cell?
Select the cell and press F2 in Windows Excel to edit its contents. Press Enter to accept the change or Esc to cancel it. If F2 controls a laptop feature instead, try Fn+F2.

What is the difference between Ctrl+; and Ctrl+Shift+;?
Ctrl+; inserts the current date, while Ctrl+Shift+; inserts the current time in Windows desktop Excel. Both enter fixed values that do not refresh automatically.

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.