Excel Shortcut Keys A to Z: What Each Letter Means

Excel does not assign a standard action to every Ctrl-plus-letter combination, but many of the most useful Windows shortcuts do follow that pattern. The A-to-Z guide below explains what each Ctrl+letter does in Excel for Microsoft 365 on Windows, identifies letters without a common built-in shortcut, and shows how to adapt the shortcuts to your task.

What “A to Z” means in Excel

When people ask for Excel shortcut keys from A to Z, they usually mean the keyboard combinations made by holding Ctrl and pressing a letter. These are not a complete alphabetic command system: Excel has no widely used, built-in worksheet command for every Ctrl+letter. Some combinations are reserved for particular contexts, and add-ins or custom macros can change what a key does.

Shortcuts can also depend on what is selected. Ctrl+D, for example, fills cells downward based on the top cell in a selected range; it does not mean the same thing as pressing D while editing a formula. In the list below, “Ctrl” refers to the Windows key combination, and actions describe the normal worksheet context unless stated otherwise.

Excel Ctrl shortcuts from A to Z

Ctrl+A: Selects the current data region in many worksheet situations; press it again to expand the selection, eventually including the whole worksheet. The exact selection depends on the active cell and data layout.
Ctrl+B: Applies or removes bold formatting for selected cells, or for text being edited.
Ctrl+C: Copies selected cells or content to the Clipboard.
Ctrl+D: Fills the selected range downward, copying the top cell’s content and formatting into the cells below.
Ctrl+E: Runs Flash Fill, which can detect a pattern in nearby data and fill values to match it. Check the results, especially when the source data is inconsistent.
Ctrl+F: Opens Find, where you can search for text, numbers, or other values in the workbook.
Ctrl+G: Opens Go To, allowing you to jump to a cell address or a named range.
Ctrl+H: Opens Find and Replace. Use it to replace matching content, and review the search scope and options before choosing Replace All.
Ctrl+I: Applies or removes italic formatting.
Ctrl+J: Has no common, general-purpose worksheet command assigned by default. A key may behave differently in a dialog, add-in, or customized Excel setup.
Ctrl+K: Opens the Insert Hyperlink dialog for adding a link to selected content.
Ctrl+L: Opens the Create Table dialog when working in a worksheet. Ctrl+T opens the same dialog in standard Windows Excel.
Ctrl+M: Has no common built-in worksheet shortcut in Excel for Windows.
Ctrl+N: Creates a new workbook.
Ctrl+O: Opens the file-opening screen or dialog.
Ctrl+P: Opens the print screen, where you can inspect print settings and preview the worksheet.
Ctrl+Q: Opens Quick Analysis for a selected range when that feature is available. It offers context-sensitive options such as formatting, charts, totals, and tables.
Ctrl+R: Fills the selected range to the right, using the leftmost cell as the source.
Ctrl+S: Saves the current workbook. If it has not been saved before, Excel prompts you to choose a name and location.
Ctrl+T: Opens the Create Table dialog for the current data range, like Ctrl+L.
Ctrl+U: Applies or removes underline formatting.
Ctrl+V: Pastes Clipboard content. Depending on how you copied, the paste may include formulas, formatting, or both.
Ctrl+W: Closes the active workbook window. Save changes first if you want to keep them.
Ctrl+X: Cuts selected cells or content so it can be moved elsewhere.
Ctrl+Y: Redoes an action that was undone, or repeats certain recent actions where Excel supports repeating.
Ctrl+Z: Undoes the most recent action. Some operations cannot be undone, so save important work before carrying out risky changes.

Shortcuts for editing and formatting

The alphabetic shortcuts are easiest to learn in groups. Ctrl+C, Ctrl+X, and Ctrl+V cover copy, cut, and paste; Ctrl+Z and Ctrl+Y handle undo and redo. For emphasis, Ctrl+B, Ctrl+I, and Ctrl+U toggle bold, italic, and underline. These combinations are useful in cells and, in many cases, while editing text within a cell.

Fill shortcuts can speed up repeated work. Select a range with the value or formula in its first row, then press Ctrl+D to fill down; select a range with the source at its left edge and press Ctrl+R to fill right. For example, if B2 contains a formula and B2:B20 is selected, Ctrl+D copies the formula down the selection, adjusting relative references as Excel normally does. Inspect the resulting formulas if absolute and relative references matter.

Flash Fill is different from copying a formula. If column A contains full names and you type a first name in B2, Ctrl+E may recognize the pattern and fill neighboring rows. It works by detecting a pattern rather than calculating a rule, so it is sensible to verify its output when names, punctuation, or formats vary.

Finding data and moving around

Ctrl+F and Ctrl+H are useful for locating or changing content, while Ctrl+G is a direct route to a known location. In Go To, you can enter a reference such as D250 to jump to that cell. This can be faster than scrolling through a large worksheet, and it also works with defined names in a workbook.

Ctrl+A is often misunderstood as “select every cell immediately.” Excel’s selection behavior depends on context: when the active cell is inside a contiguous block of data, the first press commonly selects that region, and a further press can broaden the selection. If you need a precise block, use the mouse or keyboard navigation to establish the range rather than assuming Ctrl+A has selected only the data you intended.

For an additional useful Windows shortcut, Ctrl+Shift+L turns worksheet filters on or off for a data range. It is not part of the Ctrl+A-to-Z list, but it pairs well with Ctrl+F and table shortcuts when sorting or reviewing records. Filter controls do not delete hidden rows; they temporarily hide records that do not match the filter.

Working with tables, workbooks, and printing

Ctrl+L and Ctrl+T both bring up Excel’s Create Table dialog. A table adds filter buttons and can automatically extend when you add adjacent data. Before accepting the dialog, check that Excel has detected the full range and that the “My table has headers” option matches your data. If the selection includes a title row or blank columns, correct the range first.

Ctrl+N, Ctrl+O, Ctrl+S, and Ctrl+W are workbook-level commands: create, open, save, and close. Ctrl+P opens print settings rather than immediately sending a job to the printer. Check the preview, orientation, margins, scaling, and selected print area before printing; a worksheet that looks clear on screen can otherwise split across pages or shrink to unreadable size.

Using Alt, function keys, and ribbon KeyTips

Not every useful shortcut is Ctrl plus a letter. Pressing Alt in Excel for Windows displays KeyTips: small letters or letter combinations over ribbon tabs and commands. Press the displayed keys in sequence to reach a command without using the mouse. The KeyTips shown on screen are the reliable guide because sequences can differ by ribbon layout, language, and application updates.

Function keys also provide important commands. F2 edits the active cell, F4 repeats the last action in some contexts or cycles reference types while editing a formula, and F12 opens Save As. Context matters: F4 inside a formula can change a reference such as A1 to $A$1, while outside formula editing it may repeat an action. Laptop keyboards may require holding Fn to send an F-key rather than a hardware function.

Excel also has shortcuts with other modifiers, such as Ctrl+Shift+L for filters and Ctrl+1 to open Format Cells. Learning a few relevant combinations is usually more useful than memorizing every possible key. Use Alt KeyTips for ribbon commands you rarely need, then memorize the commands used repeatedly in your own work.

Windows, Mac, and Excel for the web differences

This guide uses Excel for Microsoft 365 on Windows. On a Mac, many familiar editing shortcuts use Command instead of Ctrl: for example, Command+C copies, Command+V pastes, Command+Z undoes, and Command+S saves. This is a helpful starting point, not a universal substitution rule. Excel for Mac has differences in some shortcuts, and macOS or another app may already use a key combination.

Excel for the web runs in a browser, so a shortcut can sometimes be intercepted by the browser or operating system. The available combinations also differ from desktop Excel. If a key does not perform the expected action, use the ribbon or consult Excel’s in-product shortcut help for the version and platform you are using. Do not assume that a Windows desktop shortcut will work identically on Mac or in a browser.

Common problems and how to choose shortcuts

A shortcut that appears not to work is often being used in the wrong context. The active cell may be in edit mode, a dialog may have focus, the worksheet may be protected, or the selected range may not match what a fill command needs. Click a worksheet cell, check the selection, and try the command again. If you use an external keyboard, confirm that Ctrl is registering correctly.

Nothing happens: Check whether a dialog, browser, or other application has focus, and whether a Mac or laptop keyboard requires a different modifier.
The wrong cells change: Undo immediately with Ctrl+Z if available, then verify the active cell and selected range before repeating the operation.
A shortcut differs from a guide: Confirm the guide’s platform and Excel version; add-ins, language settings, and customizations can also affect behavior.
You cannot remember a sequence: Use Alt to reveal Windows KeyTips or choose the command from the ribbon. A visible command is safer than guessing a key combination.

Choose shortcuts by frequency and risk. Start with save, undo, find, and the editing commands you use every day. Add table, fill, or print shortcuts when they match regular tasks. For Replace All, filling a large selection, or changing a workbook’s structure, first check the target range and keep a recoverable copy when the change is important.

Frequently Asked Questions

Is there a Ctrl shortcut for every letter in Excel?
No. Excel has useful Ctrl shortcuts for many letters, but not every Ctrl+A-to-Z combination has a standard worksheet command. The behavior can also depend on the dialog, add-ins, or custom settings.

What does Ctrl+E do in Excel?
Ctrl+E runs Flash Fill when the feature can recognize a pattern in nearby data. It may extract or combine text based on examples you enter, but review the results because it detects patterns rather than applying a formula rule.

Are Ctrl+L and Ctrl+T different in Excel?
In standard Excel for Windows, both open the Create Table dialog. Check the proposed range and header setting before creating the table.

What is the Mac equivalent of Ctrl+C and Ctrl+V?
In Excel for Mac, the common equivalents are Command+C to copy and Command+V to paste. Other shortcuts may differ, so treat Command as a practical equivalent only where the Mac version supports that combination.

How can I see Excel shortcuts without memorizing them?
In Windows desktop Excel, press Alt to display ribbon KeyTips, then follow the letters shown on screen. You can also choose commands directly from the ribbon or use Excel’s built-in help for your platform.

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.