Excel Shortcut Keys: Essential Windows and Mac Tips

Excel shortcut keys are keyboard combinations that let you edit cells, format data, navigate a worksheet, and manage workbooks without repeatedly reaching for the ribbon. In Excel for Microsoft 365 on Windows, start with Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S to save, and Ctrl+Arrow keys to move to the edge of a data region; on a Mac, many familiar Ctrl shortcuts use Command instead.

Essential Excel shortcuts to learn first

A few everyday shortcuts cover a surprisingly large share of routine spreadsheet work. They apply in Excel for Microsoft 365 on Windows unless noted. Learn them gradually and use them in a sample workbook until the combinations feel natural.

Ctrl+C / Ctrl+X / Ctrl+V: Copy, cut, and paste the selected cells or content.
Ctrl+Z / Ctrl+Y: Undo the previous action and redo an action that was undone.
Ctrl+S: Save the current workbook.
Ctrl+F: Find text or values; Ctrl+H opens Find and Replace.
Ctrl+B / Ctrl+I / Ctrl+U: Toggle bold, italic, and underline for selected cells or text.
Ctrl+1: Open the Format Cells dialog, where number formats, alignment, borders, and other properties can be changed.
Ctrl+P: Open the print screen, where you can review print settings and preview the worksheet.

On Excel for Mac, common commands such as copy, paste, save, find, undo, bold, and print generally use Command in place of Ctrl: for example, Command+C, Command+V, Command+S, and Command+Z. Keyboard shortcuts can differ for particular features, so do not assume every Windows combination has a direct Mac equivalent.

Move around a worksheet quickly

Navigation shortcuts are especially useful in large sheets because they reduce scrolling and help you reach the boundaries of a block of data. Pressing an arrow key moves the active cell one position. Holding Ctrl while pressing an arrow key on Windows jumps to the edge of the current data region, or to the next populated cell or worksheet boundary, depending on what lies in that direction.

Ctrl+Arrow: Jump through a data region. For example, from the first filled cell in a continuous column, Ctrl+Down moves to its last filled cell.
Ctrl+Home: Move to the beginning of the worksheet, normally cell A1.
Ctrl+End: Move to the last cell Excel considers used in the worksheet. Formatting left far below or to the right of visible data can make this destination seem unexpectedly distant.
Page Up / Page Down: Move the view up or down by roughly one screen.
Ctrl+Page Up / Ctrl+Page Down: Switch to the previous or next worksheet tab.
F5 or Ctrl+G: Open Go To, where you can enter a cell reference such as D250 to jump directly there.

To select as you move, add Shift. For example, Ctrl+Shift+Down selects from the active cell toward the end of the data region. This is useful for selecting a column of records, but check the destination first: a blank cell inside the data can change where the jump stops. On Mac, Command+Arrow often moves to the edge of a data region, while the exact behavior of navigation combinations can depend on the Mac keyboard and Excel settings.

Enter and edit cell contents

Excel has shortcuts for both changing a cell and controlling how entries are committed. Press F2 on Windows to edit the active cell in place. This is handy when correcting part of a long label or formula: use the arrow keys to position the cursor, edit the text, and press Enter to accept the change. Press Esc to cancel an edit that has not been committed.

When entering a value or formula, Enter normally accepts it and moves the selection down. Tab accepts it and moves right. These behaviors make it practical to fill a table across a row with Tab or down a list with Enter. If a range is selected before data entry, Enter can move within the selection rather than following the usual path.

Alt+Enter: Insert a line break inside a cell while editing it on Windows. The row may need to be tall enough, or Wrap Text may need to be enabled, for all lines to show.
Ctrl+;: Enter the current date as a fixed value on Windows. It does not continually update like a date produced by a formula.
Ctrl+Shift+;: Enter the current time as a fixed value on Windows.
Ctrl+D: Fill the selected cells downward using the contents and formatting of the top cell.
Ctrl+R: Fill the selected cells to the right using the leftmost cell.

Fill shortcuts are not the same as copying a formula to every possible cell: Excel fills the selected range. Select only the intended cells, and inspect relative references after filling formulas. When a formula is copied, references may adjust based on their relative or absolute reference markers.

Format numbers, cells, and tables

Formatting shortcuts can make a report easier to read, but they change presentation rather than the underlying value. Ctrl+1 opens Format Cells and is often more dependable than memorizing a separate shortcut for every number format. In the dialog, choose a category such as Number, Currency, Date, or Percentage and review options such as decimal places.

Some useful Windows combinations include Ctrl+Shift+% for Percentage format with no decimal places, Ctrl+Shift+$ for Currency format, and Ctrl+Shift+# for Date format. The exact displayed symbol and date appearance can depend on regional settings. Applying Percentage to a value changes its display: for example, 0.25 is shown as 25%, not 0.25%. It does not mean that Excel has recalculated the underlying number.

For a formatted data range, Ctrl+T opens the Create Table dialog on Windows. Tables can provide filter buttons, consistent formatting, and automatic expansion when rows are added. To toggle filter buttons for a range, use Ctrl+Shift+L. A table and an ordinary filtered range are related but not identical features; if the data is already an Excel table, its header filters are managed as part of that table.

For a quick total, Alt+= invokes AutoSum on Windows. Excel proposes a range of adjacent numbers, which you can accept with Enter or adjust before accepting. Always check the proposed range, especially when blank cells or text interrupt the figures. AutoSum is a convenience for building a total, not a guarantee that Excel has identified the right business logic.

Work with rows, columns, and worksheets

To insert a row or column, first select the row or column heading, then use the Windows insert shortcut Ctrl+Shift++ (the plus sign may require Shift with the equals key on some keyboards). Ctrl+- opens the delete action for selected cells, rows, or columns. The prompt and result depend on what you selected, so selecting the whole row or column heading before using the shortcut helps avoid shifting only part of a table.

To select a full row, use Shift+Space; to select a full column, use Ctrl+Space on Windows. Use these with care when working inside a table or a large worksheet: a selection can extend much farther than the visible data. If you want to remove content but retain the cells, Delete clears cell contents; it is different from deleting the cells themselves and shifting neighboring data.

Ctrl+Page Up and Ctrl+Page Down move between worksheet tabs without clicking them. For many worksheets, this can be faster than using the tab navigation arrows. To rename a sheet or change its color, use the worksheet tab context menu or the Home ribbon; shortcuts are best for moving between sheets, not for every tab-management task.

Choose shortcuts that fit the task

There is no need to memorize a long list at once. Choose a few combinations that match the work you do most, then add others when a repeated action becomes inconvenient. A person who reviews reports may benefit most from Find, Go To, print preview, and navigation. Someone cleaning imported data may use select, fill, filter, and formatting commands more often.

For frequent cell editing: Learn F2, Enter, Tab, Esc, and the copy, paste, and undo commands.
For large data sets: Learn Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+Home, Ctrl+End, and Ctrl+F.
For reporting: Learn Ctrl+1, Ctrl+T, Ctrl+Shift+L, Alt+=, and Ctrl+P.
For multi-sheet workbooks: Learn Ctrl+Page Up and Ctrl+Page Down, and save regularly with Ctrl+S.

Shortcuts are most valuable when they reduce repeated effort without hiding what Excel is doing. If you are still learning a feature, using the ribbon once can help you recognize its name and options. You can then adopt the shortcut if it is easier to remember. A combination that is awkward on your keyboard is not automatically faster than a menu command.

Why a shortcut may not work

A shortcut can fail or appear to do something unexpected for several ordinary reasons. First, confirm which application has focus: if a cell is in edit mode, the keystrokes may become part of the cell contents instead of triggering a command. Press Esc or Enter to leave edit mode, then try again. Also check whether a dialog, menu, or another application is currently active.

Second, distinguish Excel for Windows from Excel for Mac and Excel for the web. Many Mac shortcuts use Command rather than Ctrl, but not all do. In a browser, keyboard combinations can also be intercepted by the browser or operating system. Laptop keyboards may require Fn to access function keys such as F2, and international keyboard layouts can make punctuation-based combinations less intuitive.

Third, check the selection and workbook state. A command may be unavailable for a protected sheet, a selected object, or a particular range. Ctrl+End can appear wrong if Excel considers previously formatted cells part of the used area. Ctrl+Z can undo supported recent actions, but it does not reverse every operation; saving, running some commands, or using certain external connections can affect what can be undone. Save a copy before large structural changes.

Windows, Mac, and web differences

This guide focuses on Microsoft 365 Excel for Windows. On Mac, Command replaces Ctrl for many common editing commands, and navigation or formatting shortcuts can differ. Function keys may also require Fn depending on macOS keyboard settings. If a combination is unfamiliar, check Excel’s menus or the Microsoft support shortcut list for the specific operating system rather than relying on a Windows shortcut chart.

Excel for the web runs in a browser and supports many familiar shortcuts, but browser-reserved combinations and the web app’s available features can affect behavior. For example, a browser may use a key combination for its own navigation rather than passing it to Excel. When a shortcut conflicts, use the ribbon command or consult the shortcut help for the web version. The core ideas—select the intended cells, understand whether a command edits values or formatting, and verify the result—apply across versions.

Frequently Asked Questions

What is the most useful shortcut in Excel?
There is no single best shortcut for every task. Ctrl+Z is valuable for quickly reversing many recent actions, while Ctrl+S, Ctrl+F, and Ctrl+Arrow are frequent choices for saving, finding, and navigating on Windows.

What is the shortcut for saving an Excel file?
Press Ctrl+S in Excel for Windows or Command+S in Excel for Mac. If the workbook has not been saved before, Excel may ask you to choose a file name and location.

How do I select all data in Excel?
Ctrl+A selects the current data region or, in some contexts, the whole worksheet; pressing it again can expand the selection. To select a worksheet directly on Windows, use Ctrl+Shift+Space. Check the selection outline before applying a change.

How do I switch between sheets using the keyboard?
In Excel for Windows, use Ctrl+Page Up for the previous worksheet and Ctrl+Page Down for the next one. These shortcuts move through worksheet tabs in the workbook, not between separate open workbooks.

Do Excel shortcuts work the same on Mac?
No. Many standard commands use Command instead of Ctrl on a Mac, but some shortcuts have different keys or behavior. Check the Mac-specific command in Excel’s menus or official shortcut guidance when a Windows combination does not work.

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.