Excel Shortcut Cheat Sheet for Windows and Mac

An Excel shortcut cheat sheet is a quick reference to keyboard commands for editing cells, moving around worksheets, formatting data, and working with tables. In Excel for Microsoft 365 on Windows, start with Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+S, Ctrl+Arrow, F2, Ctrl+1, and Alt+=; on a Mac, many common commands use Command instead of Ctrl.

How to use this shortcut cheat sheet

Shortcuts below are written first for Excel for Microsoft 365 on Windows. The plus sign means press the keys together: Ctrl+S means hold Ctrl and press S. A comma in a sequence means press the keys in order, not simultaneously. For example, Alt,H,O,I opens Excel’s AutoFit Column Width command through ribbon KeyTips.

Excel shortcuts can depend on the selected cell, the current mode, keyboard layout, and whether a laptop requires the Fn key to use function keys. A shortcut may also behave differently while you are typing inside a cell than when the cell itself is selected. If a command does not work, press Esc to leave the current editing mode and try again.

Essential shortcuts for everyday work

These are useful in almost any workbook and are a good starting set to memorize:

Ctrl+C / Ctrl+X / Ctrl+V: Copy, cut, and paste the selected cells or content.
Ctrl+Z / Ctrl+Y: Undo the last action and redo or repeat an action, respectively. What can be undone depends on the action; some operations, such as running a macro, cannot be reversed with Undo.
Ctrl+S: Save the workbook. For a new workbook, Excel may prompt you to choose a name and location.
Ctrl+P: Open the Print screen, where you can review print settings and preview pages.
Ctrl+F / Ctrl+H: Open Find and Replace. Find searches workbook content, while Replace can change matching content.
Ctrl+1: Open the Format Cells dialog, which includes number, alignment, font, border, fill, and protection settings.
Ctrl+T: Turn a selected data range into an Excel table. Check that the selected range and any header option are correct in the dialog.

Copying and pasting cells can carry formulas, formatting, and other properties along with the displayed values. If you need only values or a particular paste option, use Ctrl+Alt+V to open Paste Special and choose the appropriate option.

Move and select data quickly

Large sheets are easier to navigate with keyboard movement and selection commands. Ctrl+Arrow moves to the edge of a continuous data region in the direction pressed. If there is a blank cell in the way, Excel stops at the edge of the current region rather than leaping across the gap.

Ctrl+Home: Move to the beginning of the worksheet, usually cell A1.
Ctrl+End: Move to the last cell Excel considers used in the worksheet. Formatting left far below or to the right of your visible data can make this cell seem unexpectedly distant.
Ctrl+Shift+Arrow: Extend the selection from the active cell toward the edge of a contiguous data region.
Shift+Arrow: Extend a selection one cell at a time.
Ctrl+Space: Select the current column; Shift+Space selects the current row.
Ctrl+Page Up / Ctrl+Page Down: Move to the previous or next worksheet tab.

For example, if a column contains an uninterrupted list from B2 through B200, select B2 and press Ctrl+Shift+Down to extend the selection to the bottom of that region. If B50 is blank, the command may stop at B49. When your data is in an Excel table, navigation can follow the table’s boundaries, which is one reason tables are useful for growing datasets.

Edit cells and enter data

Small editing shortcuts prevent repetitive mouse work and reduce the risk of changing the wrong cell. Press F2 to edit the active cell’s contents in place. If you are entering a formula or text and want to discard the unfinished edit, press Esc; press Enter to accept the entry.

Alt+Enter: Start a new line within the same cell while editing its contents. The row may need a taller height to display all lines.
Ctrl+;: Insert the current date as a fixed value.
Ctrl+Shift+;: Insert the current time as a fixed value.
Alt+=: Insert an AutoSum formula, usually summing an adjacent range that Excel detects. Review the proposed range before accepting it.
Ctrl+E: Use Flash Fill to recognize and continue a pattern in a neighboring column, such as extracting first names from full names. Review the generated results, especially when the source data has inconsistent formats.

The date and time shortcuts insert values; they do not create constantly updating timestamps. If you want a date that changes with recalculation, a worksheet formula is a different tool. Also, AutoSum proposes a formula rather than guaranteeing that the intended cells have been included, so check the range when there are blanks, labels, or multiple nearby number columns.

Format numbers and improve readability

Formatting shortcuts are most helpful when applied to a selected range. Ctrl+B toggles bold, Ctrl+I toggles italic, and Ctrl+U toggles underline. Ctrl+1 gives more detailed control than a single format shortcut, particularly when you need to choose decimal places, a date display, alignment, or borders.

To fit a column to its current contents using the keyboard, select the column or a cell in it and press Alt,H,O,I in sequence. This is a ribbon KeyTips sequence: Alt displays KeyTips, then H selects Home, O opens Format, and I chooses AutoFit Column Width. It adjusts width to fit visible cell contents, but a very long entry can make the column inconveniently wide. You can instead drag the column boundary or set a specific width.

Formatting changes how a value is displayed, not necessarily the value stored in the cell. For example, showing a number with two decimal places may hide additional stored decimals without rounding the underlying value. If calculations must use rounded values, use an appropriate formula or change the source data deliberately rather than assuming display formatting changes the calculation.

Shortcuts for lists, filters, and data cleanup

Ctrl+Shift+L toggles AutoFilter for a selected data range. Filter arrows let you show rows that meet selected criteria without deleting the other rows. When the data is already an Excel table, filter controls are normally part of the table headers.

When a cell in a filtered column is selected, Alt+Down Arrow opens that column’s filter menu. This can be quicker than moving to the small arrow with the mouse. Remember that filtering hides rows from view; it does not remove them. Before copying or summarizing filtered data, check whether you intend to work with visible rows only or with the full dataset.

Ctrl+T is often a better long-term step than applying a filter to an ordinary range. Tables provide structured headers, filter controls, and automatic expansion when you add adjacent rows. Before creating one, make sure the range has a single header row and no unintended blank rows or columns inside the dataset. If your range includes existing formatting, creating a table may also apply a table style.

Switching between Windows and Mac

On a Mac, many familiar Windows shortcuts use Command in place of Ctrl: for example, Command+C copies, Command+V pastes, Command+Z undoes, Command+S saves, and Command+F finds. This is a useful rule of thumb for common editing commands, not a guarantee that every Windows shortcut has a direct Command-key equivalent.

Function-key behavior also differs by Mac model and system settings. F2 or other function keys may require holding Fn, and some key combinations can be intercepted by macOS or assigned to system features. Excel for Mac has its own shortcut list and may offer a different key combination for a command. If a Windows ribbon sequence such as Alt,H,O,I is not available, use the Mac ribbon interface or Excel’s shortcut documentation rather than assuming the same sequence applies.

Excel for the web can also differ from the desktop app, and browser shortcuts may conflict with Excel commands. When an expected shortcut opens a browser feature or does nothing, check whether the workbook is open in the desktop application and consult the shortcut list for the version you are using.

Common shortcut problems and fixes

A shortcut that appears not to work is often a context issue rather than an Excel fault. First confirm whether a cell is selected or whether you are editing its contents. F2, for instance, edits a selected cell, but while a cell is already being edited, other keys may act on the text cursor instead.

Ctrl+Arrow stops early: Look for a blank cell separating data into regions. The shortcut stops at data boundaries.
Ctrl+End goes too far: Excel may still consider distant formatted cells part of the used area. Check for stray formatting or content beyond the intended data.
F-keys control the computer: On some keyboards, press Fn with the function key or adjust the keyboard’s function-key setting.
A shortcut behaves differently on a Mac: Try the documented Mac combination; do not replace Ctrl with Command automatically for every command.
Typing replaces existing content: Press Esc if the edit is not committed, then check the selected cell before entering data again.

Shortcuts can also be affected by keyboard layouts and other applications. If a command is important, verify its effect on a small test range before using it on a workbook with valuable data. Saving first with Ctrl+S is a simple precaution before substantial edits.

Build a practical shortcut routine

Learning every shortcut at once is rarely necessary. Pick commands that match the work you actually do, then add a few at a time. Someone who cleans imported lists may benefit most from navigation, Find and Replace, Flash Fill, filters, and tables. Someone who prepares reports may use formatting, AutoSum, sheet navigation, and print preview more often.

Choose one repeated task, such as selecting a long column or opening Format Cells.
Use the shortcut consistently for a few days, checking the selection before applying any change.
Add a related shortcut once the first one feels familiar, such as Ctrl+Arrow after learning Ctrl+Shift+Arrow.
Keep a short reference beside your workstation for commands you use infrequently.

For less common commands, Excel’s ribbon KeyTips can help you discover a keyboard route: press Alt on Windows and follow the letters displayed on screen. This is safer than memorizing a sequence that may vary by version, language, or ribbon configuration. The most effective cheat sheet is the one that supports your actual workflow while leaving you able to verify what Excel is about to do.

Frequently Asked Questions

What is the most useful Excel shortcut? There is no single best shortcut for everyone, but Ctrl+Z is broadly useful because it undoes many recent actions. Ctrl+S, Ctrl+Arrow, and Ctrl+1 are also strong choices for everyday workbook work.

How do I select a whole column or row in Excel? On Windows, select a cell in the desired column and press Ctrl+Space to select the column. Press Shift+Space to select the row containing the active cell.

What shortcut opens Format Cells? Press Ctrl+1 on Windows to open the Format Cells dialog. On Mac, consult Excel’s Mac shortcut reference or use the ribbon because modifier keys and available combinations differ.

How do I insert today’s date in Excel? On Windows, press Ctrl+; to enter the current date as a fixed value in the selected cell. It will not update automatically on a later day.

Why does Ctrl+End move beyond my data? Excel may treat cells with leftover content or formatting as used, even if they look empty. Inspect distant rows and columns for stray entries or formatting; remove unintended material if appropriate, then save and check the used area again.

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.