Excel Shortcut Codes: Essential Keys and How They Work

Excel shortcut codes usually means keyboard shortcuts: press a key or combination of keys to run a command without choosing it from a menu. In Excel for Microsoft 365 on Windows, useful starting points include Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, Ctrl+1 to open Format Cells, and Alt+= to insert AutoSum.

What Excel shortcut codes mean

Excel does not have one official system called “shortcut codes.” People use the phrase for keyboard shortcuts, which may be a single key, such as F2, or a combination, such as Ctrl+Shift+L. The plus sign means to hold the listed modifier key while pressing the next key; it is not a key you press. For a sequence such as Alt, then H, then O, press and release each key in turn.

Shortcuts act on the current selection or active cell, so the same combination can have a different practical effect depending on where you are. For example, Ctrl+C copies selected cells when a worksheet is active, but copies selected text while you are editing a cell. Shortcuts generally do not replace commands or data: they provide a faster way to invoke commands that are also available through Excel’s interface.

There is a separate meaning of “Alt code”: a Windows numeric-keypad code for typing a character. Those codes are not Excel commands, and they depend on the character and Windows input method. If you are looking to move around, format cells, or calculate totals, the keyboard shortcuts below are the relevant kind.

Useful shortcuts to learn first

These Windows shortcuts cover everyday spreadsheet work. The selection matters: for instance, a fill command needs a source cell and destination cells selected in a suitable arrangement.

Ctrl+C, Ctrl+X, and Ctrl+V: copy, cut, and paste the current selection.
Ctrl+Z and Ctrl+Y: undo and redo an action. Some actions cannot be undone, and redo is available only after an undo.
Ctrl+S: save the workbook. Ctrl+P opens the print screen.
Ctrl+F and Ctrl+H: find and replace. These can search worksheet content without manually scanning every row.
Ctrl+1: open the Format Cells dialog, where you can change number formats, alignment, fonts, borders, and other cell settings.
Ctrl+T: create an Excel table from a selected data range. Check that the range and header-row choice are correct in the dialog.
Ctrl+Shift+L: turn filters on or off for a data range. It adds filter controls to the header row when appropriate.
Alt+=: insert AutoSum. Excel proposes a range of adjacent numbers; review the selection before accepting it.

For a quick example, select a cell below a column of numbers and press Alt+=. Excel suggests a SUM formula for the nearby values. Press Enter to accept the suggestion, or adjust the range if the proposed cells omit a row or include something that should not be totaled.

Moving around and selecting data

Navigation shortcuts become especially useful in long worksheets. The arrow keys move one cell at a time. Ctrl+Arrow moves to the edge of a contiguous block of data in that direction; if the next cell is blank, the behavior is based on the current blank or data region. This makes it quick to jump through a column, but it can stop at gaps rather than travel to the last row of the sheet.

Ctrl+Shift+Arrow extends the selection from the active cell toward the edge of the data region. Ctrl+Home moves to the beginning of the worksheet, and Ctrl+End moves to the last cell Excel considers used. The latter may land farther down or across than visible data if formatting or old content has extended the used range.

Other practical selection and sheet-navigation keys include:

Ctrl+Space selects a worksheet column; Shift+Space selects a row.
Ctrl+PageUp and Ctrl+PageDown move to the previous or next worksheet tab.
Home moves to the beginning of the row, while Page Up and Page Down scroll by a screenful.

With frozen panes, split windows, or a nonstandard selection, navigation may look different from what a new user expects. If Ctrl+End jumps to an apparently empty area, deleting unused rows or columns is not always necessary; first check whether distant cells contain formatting or previously entered content.

Entering and editing cell contents

Press F2 to edit the active cell’s contents in the cell, rather than replacing them with new typing. Inside a formula, F4 cycles through reference styles for a selected reference, such as relative and absolute references. Its behavior depends on the cursor being in a formula; outside formula editing, F4 can repeat the previous action in many Excel situations.

Press Alt+Enter while editing a cell to start a new line inside that cell. This is useful for a label with two lines, but the row may need its height adjusted to show the full text. To enter the same value or formula into multiple selected cells, type the entry and press Ctrl+Enter. Excel puts the entry in each selected cell, so make the selection carefully before using it.

Ctrl+D fills down from the top cell of a selected range, and Ctrl+R fills right from the leftmost cell. These commands copy contents and relevant formatting from the source cell. They are not the same as dragging a fill handle, which can extend a series such as dates or numbers rather than simply copying a value.

Two helpful entry shortcuts are Ctrl+;, which enters the current date as a fixed value, and Ctrl+Shift+:, which enters the current time as a fixed value. These are snapshots, not live date or time formulas: they do not update later. The colon key may require a different physical key combination on some keyboard layouts.

Formatting, formulas, and command sequences

Press Ctrl+1 when you need precise control over formatting. In the Format Cells dialog, choose a category such as Number, Currency, Date, or Percentage rather than relying on how a value happens to display. A percentage format changes the display of a numeric value; it does not automatically make an incorrectly entered number the intended percentage. For example, applying Percentage to 0.25 displays 25%.

To show or hide formulas in worksheet cells, press Ctrl+`, where the final key is the grave accent, usually found near the upper-left corner of a US keyboard. It toggles the worksheet’s formula display; it does not convert formulas into text. A narrow column may show hashes or cut-off content after the display changes, so widen columns if needed.

Windows also offers ribbon KeyTips. Press Alt to display letters or key combinations over ribbon tabs and commands, then follow the prompts shown on screen. A sequence such as Alt followed by displayed letters is a way to navigate the current ribbon, not a universal fixed shortcut. The letters can depend on the command, interface, and language. This is often the best option when you know where a command lives but do not remember its shortcut.

Windows, Mac, and Excel for the web

This guide uses Excel for Microsoft 365 on Windows as its baseline. In Excel for Mac, many common commands use Command where Windows uses Ctrl: for example, copy is Command+C, paste is Command+V, save is Command+S, undo is Command+Z, and find is Command+F. The exact mapping is not a universal replacement rule. Navigation, function keys, and shortcuts involving Alt or Ctrl may differ, and macOS keyboard settings can affect function-key behavior.

On a Mac, check Excel’s menus or its keyboard-shortcut help when a Windows combination does not work; the displayed menu command can identify its Mac equivalent. For laptops, you may also need the Fn key to use function keys such as F2. A shortcut that requires a symbol, such as the colon in the time-entry shortcut, can vary with the keyboard layout.

Excel for the web runs inside a browser, so browser shortcuts can compete with Excel shortcuts. Some combinations may be intercepted by the browser or may behave differently from the desktop application. When a shortcut fails in the web version, try the corresponding command in the ribbon, or check Excel’s in-product shortcut help for the browser and operating system you use.

Why a shortcut may not work

A shortcut that appears broken often has a simple cause. The workbook may be in cell-edit mode, a dialog box may be open, focus may be in the formula bar, or the selected object may be a chart rather than a worksheet cell. A key combination can also be intercepted by the operating system, a browser, a keyboard utility, or a different keyboard layout.

Confirm that Excel has focus and that the intended worksheet or cell is active.
Check whether the command expects a range, a table, or a particular selection before you press its shortcut.
For Alt sequences, press Alt and follow the letters currently displayed rather than relying on a remembered sequence.
Try the ribbon command to see whether the operation itself is available in your Excel version and current context.
On a Mac or in a browser, look up the shortcut for that platform instead of assuming every Windows key combination transfers directly.

Be cautious with shortcuts that change or clear data. Undo can reverse many ordinary edits, but it is not a guarantee for every action, and some operations cannot be undone. Save important work before making large changes, and verify the selected range before using fill, delete, or paste commands.

Frequently Asked Questions

What is the most useful Excel shortcut?
There is no single best shortcut for every task. Ctrl+Z is broadly useful for undoing a recent action, while Ctrl+1 is a strong choice for formatting and Ctrl+Arrow helps navigate large blocks of data.

How do I see Excel shortcut codes on the ribbon?
In Excel for Windows, press Alt. KeyTips appear over ribbon tabs and commands. Press the displayed letters in sequence to reach the command, and press Esc to back out of a KeyTip sequence.

How do I make a new line inside an Excel cell?
While editing the cell on Windows, press Alt+Enter where you want the line break. On Mac, the key combination can differ by Excel version and keyboard; check the Insert Line Break command or the shortcut help in the Mac app.

Why does Ctrl+End go past my visible data?
Excel treats some cells beyond the visible data as part of the used range, often because they contain old content or formatting. Check those cells before removing anything, since deleting rows or columns may affect other workbook content.

Do Excel keyboard shortcuts work the same on Mac?
No. Many familiar commands use Command instead of Windows Ctrl, while navigation and function-key combinations can differ. Check the Mac app’s menus or shortcut help for the exact command and your keyboard setup.

Are Excel shortcut codes the same as Alt codes?
No. Excel keyboard shortcuts run commands such as copy or format cells. Windows Alt codes are used to enter certain characters with a numeric keypad; they are a separate Windows input feature, not a catalog of Excel actions.

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.