Excel Shortcut Keys: Examples for Everyday Tasks

Excel shortcut keys let you edit, format, calculate, and move around a workbook without repeatedly reaching for the ribbon. In Excel for Microsoft 365 on Windows, for example, press Ctrl+C to copy, Ctrl+Shift+L to add filter buttons, or Alt+= to insert a SUM formula for nearby numbers.

How Excel shortcuts work

A keyboard shortcut is a key or combination of keys that performs an Excel command. Many Windows shortcuts use Ctrl plus a letter, while others use Alt, Shift, or a function key such as F2. The shortcut generally operates on the current selection, so selecting the right cell or range first is often as important as pressing the right keys.

Some shortcuts perform an action immediately; others open a dialog or menu. For example, Ctrl+1 opens the Format Cells dialog, where you can choose number formats, alignment, borders, and other settings. A sequence such as Alt followed by ribbon key tips is different: press and release Alt, then follow the letters Excel displays on screen.

Shortcuts can behave differently depending on context. Pressing F4 while editing a formula cycles through reference styles such as A1, $A$1, A$1, and $A1. Outside formula editing, F4 may repeat the last action that Excel can repeat. Laptop function-key settings may require holding Fn as well.

Move around a worksheet efficiently

Navigation shortcuts are especially useful in large worksheets. They can move the active cell quickly, but pay attention to blank rows and columns: many movement shortcuts stop at the edge of a continuous block of data.

Arrow keys move one cell at a time. Tab moves one cell right, and Enter usually moves down after you finish entering a value.
Ctrl+Arrow jumps to the edge of the current data region in that direction. From a cell in a continuous column of entries, Ctrl+Down moves to the last filled cell in that block.
Ctrl+Home moves to the beginning of the worksheet, usually cell A1. Ctrl+End moves to the last cell Excel considers used; formatting left far below the visible data can make this cell farther away than expected.
Ctrl+Page Down and Ctrl+Page Up switch to the next and previous worksheet tabs.
Alt+Down Arrow opens a filter or data-validation list when the active cell supports one, such as a filtered column heading or a cell with a drop-down list.

For example, if a sales list runs from A1 to D500 with no blank rows, click A2 and press Ctrl+Down to jump to the bottom of that uninterrupted section. If a blank cell divides the list, the shortcut stops at the boundary instead. Use Ctrl+End as a quick way to inspect the worksheet’s used area, not as a guaranteed way to find the last meaningful record.

Select cells, rows, and data blocks

Selection shortcuts help apply an action to multiple cells without dragging the mouse. Start from an appropriate cell, then expand the selection in the direction you need.

Shift+Arrow extends a selection one cell at a time.
Ctrl+Shift+Arrow extends the selection to the edge of a continuous data region. For instance, starting at A2 and pressing Ctrl+Shift+Down selects through the bottom of the adjacent block.
Ctrl+Space selects the current column, while Shift+Space selects the current row.
Ctrl+A selects the current region or, in some contexts, the whole worksheet. Press it again when needed to expand the selection.

To select a complete table of records, click inside the data and use Ctrl+A; check the highlighted range before applying a destructive action. In an Excel table, selection behavior can depend on whether the active cell is in the body, header, or total row. If a selection looks broader than intended, click a single cell to reset it before continuing.

Edit and enter data faster

For routine cell editing, F2 edits the active cell’s contents. It is useful for correcting part of a formula without replacing the whole entry. Press Esc to cancel an edit, or Enter to accept it. Ctrl+Z undoes a recent action, and Ctrl+Y redoes an undone action in many common cases.

Several shortcuts make repeated entry quicker:

Ctrl+Enter enters the same typed value or formula into every cell in a selected range. Select the range, type the entry, then press the shortcut instead of plain Enter.
Ctrl+D fills the top cell’s contents down through the selected range. Ctrl+R fills the leftmost cell’s contents to the right.
Alt+Enter inserts a line break within a cell while editing text, so a label can occupy multiple lines without moving to another cell.
Ctrl+; inserts the current date as a value. Ctrl+Shift+; inserts the current time. These entries do not keep updating like a date or time formula would.
Ctrl+F opens Find, and Ctrl+H opens Replace. Review the search scope and options before replacing values across a whole workbook.

As a practical example, select B2:B20, type Pending, and press Ctrl+Enter to place that text in every selected cell. This is different from filling a formula down: the same formula entered into every cell may refer to different relative cells if Excel adjusts its references, so inspect the results when formulas are involved.

Format cells and organize lists

Formatting shortcuts can save time when applied to the correct selection. Ctrl+B toggles bold, Ctrl+I toggles italics, and Ctrl+U toggles underline. Ctrl+1 opens Format Cells, which is more dependable than guessing a number-format shortcut when you need a specific display such as a date, percentage, or currency.

To turn a range of related data into an Excel table, click inside it and press Ctrl+T. Confirm the proposed range and indicate whether the table has headers. Tables provide filter buttons, structured formatting, and automatic expansion when data is added directly below them. To toggle filter buttons on a selected range, use Ctrl+Shift+L; using it again removes them.

For row and column changes, Ctrl++ opens the Insert dialog and Ctrl+- opens the Delete dialog. On a typical keyboard, the plus shortcut involves the plus key, which may require Shift with the equals key. Selecting a row or column first makes the intended operation clearer. A common mistake is assuming Delete removes cells: the Delete key generally clears cell contents, while Ctrl+- removes cells, rows, or columns and can shift other data.

Write and check formulas with shortcuts

Alt+= inserts AutoSum. For example, if numbers are in B2:B6 and B7 is the blank cell directly below them, select B7 and press Alt+=. Excel proposes a SUM formula for the nearby range; check the highlighted references and press Enter to accept. The shortcut proposes a range based on context, so verify it when the data layout is irregular.

When building formulas, use F2 to edit the active cell and F4 to cycle the reference style for a selected cell reference. Suppose a formula in C2 refers to the tax rate in F1. If you need to copy the formula down while keeping the tax-rate row fixed, change that reference to F$1 using F4 as you edit. A dollar sign before the row number locks the row when the formula is copied; one before the column letter locks the column.

Press Ctrl+` (the grave-accent key, often near the upper-left of a Windows keyboard) to switch between displaying formula results and displaying formulas in cells. This is useful for reviewing a sheet’s formulas, but it changes the worksheet view rather than the formula values. Press the shortcut again to return to the usual results display.

Save, print, and manage workbook tasks

Some of the most useful shortcuts are familiar beyond Excel. Ctrl+S saves the workbook, Ctrl+P opens the print screen, and F12 opens Save As in desktop Excel for Windows. Save before making large structural changes, and check the file name and location when using Save As so you do not accidentally overwrite a different workbook.

Before printing, use Ctrl+P to inspect the preview and settings. A worksheet that looks tidy on screen may span several printed pages. Check orientation, scaling, margins, and the selected print area in the print settings rather than assuming a shortcut will fix the layout. In Microsoft 365 for Windows, ribbon commands can also be located by pressing Alt and following the on-screen key tips; those key-tip letters can change with the selected ribbon tab or Excel version.

Windows and Mac shortcut differences

This guide gives Windows shortcuts. In Excel for Mac, many common actions use Command instead of Windows Ctrl: for example, copy is Command+C, paste is Command+V, undo is Command+Z, save is Command+S, and Find is Command+F. Format Cells is commonly opened with Command+1. These examples cover familiar commands, not a blanket rule for every shortcut.

Mac keyboards, macOS settings, and Excel versions can affect function-key behavior, and some Windows combinations have different Mac mappings. In Excel for the web, browser shortcuts may also overlap with Excel commands; use the desktop app when a browser intercepts a keystroke. If a shortcut does not work, check Excel’s shortcut help for the platform and version you are using, or use the corresponding ribbon command. Do not assume that replacing every Ctrl with Command will produce the same result.

Choose shortcuts and troubleshoot problems

It is easier to remember shortcuts by task than to memorize a long list. Start with the actions you repeat most: navigation, editing, formatting, or formula review. Learn a small group, use it on real work, and add more when you notice a recurring mouse operation. Shortcuts are tools, not a requirement; the ribbon remains a useful way to confirm a command or discover an unfamiliar feature.

If a shortcut edits a cell instead of moving the selection, check whether you are in cell-edit mode; press Esc or Enter to leave it.
If Ctrl+Arrow stops early, look for a blank cell or a break in the data block.
If a function-key shortcut does nothing on a laptop, try the key with Fn, or check the keyboard’s function-key setting.
If a shortcut affects the wrong cells, undo immediately with Ctrl+Z when the action is undoable, then verify the selection before trying again.

Shortcuts do not override workbook protection or change what a command means. For example, deleting a row can shift neighboring data, while clearing contents leaves the cells in place. Understanding the result matters more than speed, particularly when editing shared files or large datasets.

Frequently Asked Questions

What is the shortcut for AutoSum in Excel?
In Excel for Windows, select the cell where the total should appear and press Alt+=. Check Excel’s proposed range before accepting it, especially if blanks or unrelated values sit beside the numbers.

How do I insert today’s date with a keyboard shortcut?
On Windows, press Ctrl+; to enter the current date as a fixed value. It will not automatically change tomorrow. On Mac, the corresponding date shortcut is commonly Command+;.

How can I add filters using a shortcut?
Select a cell in the range and press Ctrl+Shift+L in Excel for Windows to toggle filter buttons. If the data is a properly structured list, you can also create a table with Ctrl+T, which includes filter controls.

What does Ctrl+End do in Excel?
It moves to the last cell Excel considers part of the worksheet’s used area. That may extend beyond the last meaningful entry if cells below or to the right were previously formatted or edited.

Why do Excel shortcuts differ on a Mac?
Excel follows different keyboard conventions on macOS, and some commands have platform-specific mappings. Common actions often use Command, but not every Windows Ctrl shortcut has a direct Command-key equivalent, so check the Mac shortcut help for less familiar commands.

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.