Excel Shortcuts List: Essential Keys for Faster Work

For Excel for Microsoft 365 on Windows, the most useful shortcuts include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+Arrow keys to move to the edge of a data region, and Alt+= to insert AutoSum. This Excel shortcuts list groups common keys by task and notes where Mac or Excel for the web behaves differently.

How Excel shortcuts work

A shortcut combines keys to perform a command without choosing it from a ribbon or menu. In most Windows shortcuts below, hold Ctrl while pressing the letter or other key; a plus sign means the keys are pressed together. A sequence such as Alt, H, O, I is different: press and release each key in order. It uses ribbon KeyTips, which appear after you press Alt.

Shortcuts can depend on what is selected. For example, Ctrl+Arrow moves through a continuous region of data, but may travel to the next occupied cell or the edge of the worksheet if the current cell is blank. Some shortcuts also depend on whether you are editing a cell, selecting cells, or working in a dialog box. If a key does something unexpected, press Esc to leave the current mode and try again.

The tables below describe Excel for Microsoft 365 on Windows. On a Mac, many familiar Ctrl shortcuts use Command (⌘) instead: ⌘+C, ⌘+V, ⌘+X, ⌘+Z, ⌘+S, and ⌘+F are common examples. Some Excel Mac shortcuts retain Control or use Option, and function-key behavior can depend on macOS settings and the keyboard. Excel for the web may also have conflicts with browser shortcuts. Check the relevant Excel menu or shortcut help if a key differs in your setup.

Everyday workbook and editing shortcuts

These are useful across many kinds of workbooks. Saving regularly is especially important when a workbook contains changes that would be difficult to reconstruct.

Ctrl+S: Save the current workbook. If it has not been saved before, Excel asks where to save it and what to name it.
Ctrl+Z: Undo the most recent action. Excel can undo a series of actions, although some operations cannot be undone.
Ctrl+Y: Redo or repeat an action, depending on what you did previously.
Ctrl+C, Ctrl+X, Ctrl+V: Copy, cut, and paste the selection. Copy leaves the original in place; cut moves it when pasted.
Ctrl+F: Find text or values in the workbook. Use the Find options when you need to search within formulas, comments, or a specific sheet.
Ctrl+H: Open Find and Replace. Review the replacement scope before choosing Replace All, particularly when the workbook has multiple sheets.
Esc: Cancel an edit or close a menu or dialog where appropriate. When copied cells show a moving border, Esc stops the copy selection.

On Mac, the common equivalents for save, undo, copy, cut, paste, and find use Command: ⌘+S, ⌘+Z, ⌘+C, ⌘+X, ⌘+V, and ⌘+F. Excel’s menus show the available command and shortcut on that platform.

Moving around sheets and selecting data

Navigation shortcuts are most effective when you understand whether they move the active cell or expand the selection. Try them on a copy of a complex sheet if you are unsure how blank cells or separated data blocks will affect the result.

Arrow keys: Move one cell in the indicated direction.
Ctrl+Arrow key: Jump to the edge of a contiguous data region, or to the next filled cell in that direction. A blank cell can change where the jump ends.
Ctrl+Shift+Arrow key: Extend the selection toward the edge of the data region.
Ctrl+Home: Go to the beginning of the worksheet, usually cell A1.
Ctrl+End: Go to the last cell Excel considers used. This can be beyond the visible data if formatting or old entries remain in the sheet.
Ctrl+Page Down / Ctrl+Page Up: Move to the next or previous worksheet tab in the workbook.
Ctrl+Space: Select the current column. Shift+Space selects the current row.
Shift+Arrow key: Extend a selection one cell at a time.

For instance, if a column contains an uninterrupted list from A2 through A50 and A2 is active, Ctrl+Shift+Down generally selects through the bottom of that block. If there is a blank cell in the middle, the selection stops at the boundary instead. On a Mac, many navigation shortcuts still use Control, and Home, End, or function-key combinations can differ with the keyboard. Use Excel’s menu commands as a fallback rather than assuming every Windows Ctrl shortcut becomes Command.

Entering and editing cell contents

These keys help when correcting values or entering repeated information. Excel distinguishes between changing the contents of a cell and replacing the entire cell value, so check the formula bar or cell before committing an edit.

F2: Edit the active cell’s contents. In many laptop configurations, you may need Fn+F2 if the function row controls brightness or media.
Enter: Commit an entry and move to another cell, typically the cell below.
Alt+Enter: Start a new line inside the same cell while entering or editing text.
Ctrl+Enter: Enter the same value or formula into all cells in a selected range. Select the range, type the entry, then press Ctrl+Enter.
Ctrl+D: Fill down from the top cell of a selected range. It copies the top cell’s contents and formatting into the cells below.
Ctrl+R: Fill right from the leftmost cell of a selected range.
F4: While editing a formula reference, cycle through relative and absolute reference forms, such as A1, $A$1, A$1, and $A1. Outside that context, F4 can repeat the last action in some situations.

As a practical example, select B2:B6, type 0, and press Ctrl+Enter to place zero in all five selected cells. This is different from typing 0 and pressing Enter, which fills only the active cell. On a Mac, the equivalent for F2 or Ctrl+Enter may depend on the Excel version and keyboard settings; use the menu command or shortcut help if the listed Windows key does not apply.

Formatting and displaying information

Formatting shortcuts change how values appear, not necessarily the underlying value. A date format, for example, changes how a stored date is displayed; it does not turn a date into ordinary text.

Ctrl+1: Open the Format Cells dialog, where you can change number formats, alignment, font, borders, and other cell properties.
Ctrl+B, Ctrl+I, Ctrl+U: Toggle bold, italic, and underline for the selection.
Ctrl+Shift+~: Apply the General number format.
Ctrl+Shift+$: Apply a currency format; the exact symbol and display can depend on regional settings.
Ctrl+Shift+%: Apply a percentage format.
Ctrl+;: Insert the current date as a fixed value in the active cell.
Ctrl+Shift+;: Insert the current time as a fixed value.
Ctrl+`: Toggle display of formulas instead of their calculated results in the worksheet.

The date and time shortcuts insert a snapshot, not a live clock. If the date must update automatically, a formula or another data-refresh method is more appropriate. For example, the worksheet function TODAY returns the current date, while a manually inserted Ctrl+; date stays as entered. On some keyboards, the grave accent key for Ctrl+` may require a different physical key combination.

Working with tables, filters, and totals

Shortcuts can make common data tasks quicker, but they do not replace good table structure. Keep one header row, avoid merged cells in the data range, and use consistent columns so Excel can interpret the records reliably.

Ctrl+T: Create an Excel table from the selected data range. Confirm whether the range has headers in the dialog before selecting OK.
Ctrl+Shift+L: Turn AutoFilter buttons on or off for a range. If the active cell is inside a data region, Excel usually applies the filters to that region.
Alt+=: Insert AutoSum. Excel proposes a range of adjacent numbers; inspect the highlighted range before confirming if there are blanks or nearby totals.
Ctrl+K: Open the dialog for inserting a hyperlink.

For example, if monthly sales are in B2:B13 and B14 is the cell where the total should go, select B14 and press Alt+=. Excel typically proposes a sum of B2:B13, but the proposed range is not guaranteed in every layout. A filter hides rows from view without deleting them; check whether a total should include hidden rows before relying on a displayed result. Turning a clean data range into a table can also provide filter buttons and structured formatting, but it does not correct inconsistent or missing source data.

Choosing the shortcuts worth learning first

There is no need to memorize every key combination. Start with shortcuts that match frequent actions, then add specialized ones when a recurring task makes them valuable. A sensible learning order is:

Protect your work: Learn Ctrl+S and Ctrl+Z first.
Handle routine edits: Add copy, paste, find, and F2.
Move efficiently: Practice Ctrl+Arrow and Ctrl+Shift+Arrow on a small sample range.
Speed up repeated data entry: Learn Ctrl+D, Ctrl+R, and Ctrl+Enter.
Match your actual work: Add Ctrl+1 for formatting, Ctrl+T for tables, or Alt+= for totals as needed.

A useful shortcut is one that saves time without making an operation harder to review. For financial models or important reports, inspect the selected range and resulting values after using fill, replace, or AutoSum. If a shortcut is difficult to remember, use the ribbon or context menu until the action becomes familiar. Excel’s Alt KeyTips can also help locate ribbon commands without requiring you to memorize a long combination.

Common shortcut problems and platform differences

If a shortcut appears not to work, first check the active cell, selection, and editing state. A key may act differently while a cell is being edited, while a dialog is open, or when the workbook is protected. Function keys can also be assigned to hardware controls on laptops, making Fn necessary.

A browser captures the keys: In Excel for the web, the browser may use a combination for its own command. Try the Excel ribbon or desktop app if the browser intercepts it.
Mac uses different modifiers: Command replaces Ctrl for many everyday actions, but not all Excel shortcuts. Confirm the shortcut in Excel for Mac rather than applying a blanket substitution.
The jump stops early: Ctrl+Arrow navigation follows contiguous blocks of filled cells. Blanks and separate regions affect the destination.
The wrong range is filled or totaled: Ctrl+D, Ctrl+R, and Alt+= use the current selection and nearby cells. Review the range before committing important changes.
The shortcut conflicts with an add-in or system setting: Use the ribbon command, check add-in behavior, and consult the Excel help for your platform.

Excel for the web supports many familiar shortcuts, but desktop and web behavior is not identical because a browser and operating system may reserve keys. Mac keyboards may lack dedicated keys found on full Windows keyboards, or may require Fn. These are platform differences rather than evidence that the workbook itself is damaged.

Frequently Asked Questions

What is the shortcut for saving an Excel file?
On Windows, press Ctrl+S. On Mac, press ⌘+S. If the workbook is new, Excel opens a save dialog so you can choose a name and location.

How do I select an entire row or column with a shortcut?
On Windows, press Shift+Space to select the active cell’s row, or Ctrl+Space to select its column. Selection behavior can be affected by whether you are editing a cell or using a Mac keyboard.

How do I insert today’s date in Excel?
On Windows, press Ctrl+; to enter the current date as a fixed value. It will not automatically change tomorrow. Use a date function if the cell needs to recalculate.

What is the shortcut to add a total in Excel?
Press Alt+= in the cell where you want the total. Excel inserts AutoSum and suggests a range; check the range before accepting, especially if the data contains blanks or other totals.

Why does Ctrl+Arrow not go to the last row of my worksheet?
It moves to the edge of a contiguous data region or to the next filled cell, not necessarily to the worksheet’s final row. Blank cells and separate blocks change where it stops. Ctrl+End goes to the last cell Excel considers used, which may also differ from the last row containing visible data.

Do Excel shortcuts work the same on Mac and Windows?
No. Many everyday Mac actions use Command instead of Ctrl, while navigation and other commands can use different modifiers or function-key combinations. Excel for the web can also be affected by browser shortcuts, so check the command in the version you use.

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.