Essential Excel Keyboard Shortcuts for Windows and Mac

Excel keyboard shortcuts are most useful when they remove a repeated interruption: reaching for the mouse to edit a cell, jumping through a long table, opening a familiar dialog, or copying a formula. You do not need to memorize an enormous list. A small set tied to tasks you perform every day delivers most of the benefit.

This guide groups practical shortcuts by job, explains the places where context changes their behavior, and gives the corresponding Mac commands where they differ. The Windows keys are shown first because many Excel shortcut references use that convention.

These shortcuts assume a US keyboard layout. On other layouts, symbol keys and some key combinations can differ. In a shortcut such as Ctrl+Shift+Arrow, press the keys together.

The essential shortcuts to learn first

Start with commands that work across many parts of Excel. The Mac column uses Command where Excel follows the standard macOS convention.

F2 is especially valuable because it changes the selected cell from navigation mode to edit mode without double-clicking. Once you are editing, use the arrow keys to move through the cell contents rather than to another cell.

Move through a large worksheet without scrolling

The fastest navigation shortcuts respond to the structure of the sheet. They are more useful than holding an arrow key because they can cross a populated block in one step.

Press Ctrl + Down Arrow from a cell inside a data range to jump to the last filled cell in that column.

On a MacBook without dedicated Home, End, or Page keys, you may need the Fn key. For example, use Control+Fn+Left Arrow for the beginning of the sheet and Control+Fn+Right Arrow for the last used cell.

Blank cells matter. For example, Ctrl+Down Arrow moves to the edge of the current block, so a gap can make it stop earlier than expected or jump to another populated area. When you know the address, F5 is more predictable: type a reference such as M250, then press Enter.

If Ctrl+End travels far beyond your visible data, formatting or previously entered content may have expanded Excel’s used range. That does not mean every cell on the way contains data.

Select rows, columns, and data blocks precisely

Selection shortcuts turn navigation into an editing tool. Add Shift when you want movement to extend the selection.

Press Ctrl + Shift + Down Arrow to extend the selection from the active cell to the last filled cell in the current data region.

The active cell and the surrounding data determine what Ctrl+A selects. Within a populated region, the first press normally selects that region; another press can expand the selection to the worksheet. Check the highlighted area before deleting, formatting, or replacing data.

Enter and reuse data with fewer keystrokes

Excel has separate shortcuts for entering one value, copying an existing value, and filling a selected range. Choosing the right one avoids unnecessary copy-and-paste steps.

• Complete an entry and move down: press Enter. Use Shift+Enter to move up.
• Fill the selection with one entry: select the target cells, type the value or formula, then press Ctrl+Enter on Windows or Command+Return on Mac.
After selecting a range, type a value and press Ctrl + Enter to place the same entry in every selected cell.

• Copy from the cell above: select the destination or range and press Ctrl+D on Windows or Command+D on Mac.
• Copy from the cell to the left: press Ctrl+R on Windows or Command+R on Mac.
• Insert today’s date: press Ctrl+;. This enters a fixed date value, not a formula that updates tomorrow.
• Insert the current time: press Ctrl+Shift+: on Windows or Command+; on Mac.

Ctrl+D and Ctrl+R overwrite the destination cells. Confirm the selection before filling, especially when hidden rows or filtered data are involved.

Build and inspect formulas faster

Formula shortcuts are useful at different stages: starting a calculation, changing references, reviewing the sheet, and recalculating results.

Select the total cell and press Alt + = to insert a SUM formula for the values above.

To use the reference shortcut, edit a formula, place the cursor in or beside a reference such as B3, and press the key repeatedly. Excel cycles through B3, $B$3, B$3, and $B3. The exact starting point determines the order you see.

F4 is context-sensitive in Excel for Windows. While editing a formula reference, it changes the reference type. Outside that context, it can repeat the last command when that command supports repetition.

Apply common formats and data tools

Formatting shortcuts are quickest when the cells are already selected. They change presentation; they do not repair text that should have been stored as a number or date.

Press Ctrl + T to convert a data range into an Excel Table with built-in formatting and filter controls.

Use Ctrl + Shift + $ to apply Currency format to the selected cells in Excel.

Because symbols such as $, %, #, and @ occupy different physical keys on different layouts, use the character named in the shortcut rather than assuming the same key position.

Manage workbooks, worksheets, and the Ribbon

File and worksheet shortcuts keep you in the grid while moving between documents and sheets.

• New workbook: Ctrl+N on Windows or Command+N on Mac.
• Open a workbook: Ctrl+O on Windows or Command+O on Mac.
• Save: Ctrl+S on Windows or Command+S on Mac.
• Close the workbook window: Ctrl+W on Windows or Command+W on Mac.
• Insert a worksheet: Shift+F11.

In Excel for Windows, press Alt to reveal Ribbon KeyTips. Then press the displayed letters to choose a tab or command. Common tab keys include Alt+H for Home, Alt+N for Insert, Alt+P for Page Layout, Alt+M for Formulas, Alt+A for Data, Alt+R for Review, and Alt+W for View. Press Ctrl+F1 to show or hide the Ribbon.

KeyTips are sequences rather than keys held together. For example, release Alt after the KeyTips appear, then follow the letters shown on screen. This makes the Ribbon discoverable even when you do not know a dedicated shortcut.

Understand function keys and laptop keyboards

Several high-value Excel commands use the function row:

• F2 edits the active cell.
• F4 changes a formula reference while editing or repeats a supported action in another context.
• F5 opens Go To.
• F7 starts a spelling check.
• F9 recalculates open workbooks.
• Shift+F11 inserts a worksheet.
• F12 opens Save As in desktop Excel.

On many laptops, the top row controls brightness, volume, or media by default. Hold Fn with the function key if Excel does not receive the command. macOS can also reserve some combinations for system features. Microsoft’s Microsoft 365 keyboard settings guidance explains how operating-system settings can affect these keys.

Handle Excel for the web and shortcut conflicts

Excel for the web runs inside a browser, so the browser can claim a shortcut before Excel receives it. A familiar combination may open a browser feature, switch tabs, or do nothing in the worksheet.

1. Open Excel for the web and choose Help > Keyboard Shortcuts.
2. Review the shortcuts available in the web app.
3. Enable Override browser shortcuts if you want Excel to handle supported conflicting combinations.
4. Test the shortcut in a noncritical cell before relying on it in a long workflow.

The desktop, Mac, and web versions do not have perfectly identical shortcut sets. Microsoft maintains a current Excel keyboard shortcut reference with separate Windows, macOS, iOS, Android, and web sections.

Fix a shortcut that does not work as expected

A practical way to learn shortcuts

Memorizing a chart is less effective than replacing a real mouse action. Build a small working set around your own routine:

1. Notice one command you use repeatedly during normal work.
2. Learn its shortcut and use it for the rest of the week.
3. Add one navigation shortcut and one editing or formatting shortcut.
4. Keep only the commands that save time in your actual worksheets.
5. Use Windows Ribbon KeyTips or Excel’s shortcut reference when you need a less common command.

A useful starter set is Ctrl+S, Ctrl+Z, F2, Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+1, Ctrl+Enter, and Alt+=. Once those become automatic, add shortcuts for the formulas, filters, or workbook tasks that dominate your own work.

Frequently asked questions

Work faster by learning shortcuts in context

Keyboard speed comes from familiarity, not from knowing every possible combination. Learn a compact set for saving, editing, moving, selecting, and formatting; then expand it around the work you repeat. When a key behaves unexpectedly, check the application version, active context, keyboard layout, and operating-system settings before assuming the shortcut is unavailable.