What is the keyboard shortcut for AutoSum in Excel?

Press Alt and the equals sign on Windows, or Command Shift T on macOS, to insert an AutoSum that totals the cells above or to the left of the active cell.

How do I jump to the edge of my data?

Hold Ctrl on Windows or Command on macOS and press an arrow key to jump to the last filled cell in that direction. Add Shift to select the range as you go.

How do I toggle absolute and relative cell references?

While editing a formula, press F4 on Windows or Command T on macOS to cycle a reference through absolute, mixed and relative forms such as A1, $A$1, A$1 and $A1.

What is the shortcut to fill down in Excel?

Select the cell with your value plus the cells below it, then press Ctrl D on Windows or Control D on macOS to copy the top value down. Ctrl R fills to the right.

Do these shortcuts match Excel on both Windows and Mac?

Yes. Each row lists the Windows and macOS keys side by side. A few combinations differ between platforms, which is why selecting your operating system matters.

Microsoft Excel Shortcuts

Email me this result

Get this tool's output sent to your inbox, plus one useful tool a week. No spam, unsubscribe any time.

Microsoft Excel keyboard shortcuts

This searchable reference gathers the Excel shortcuts that analysts and spreadsheet users rely on, with the correct keys for both Windows and macOS. It covers workbook commands, fast navigation, selection, editing, formatting, and the formula and data tools that make Excel quick to drive from the keyboard.

How it works

Excel combines Ctrl (Windows) or Command/Control (macOS) with Shift and Alt/Option for most commands, and uses function keys such as F2 to edit a cell and F4 to repeat or cycle references. Navigation shortcuts jump by data region, and number formatting uses Ctrl Shift plus a symbol key. Pick your operating system, search for an action, and each row shows the exact keys for that platform.

Example

A few of the most-used Excel shortcuts across both systems:

Action	Windows	macOS
AutoSum	Alt =	⌘ ⇧ T
Edit active cell	F2	⌃ U
Fill down	Ctrl D	⌃ D
Format cells dialog	Ctrl 1	⌘ 1
Insert today’s date	Ctrl ;	⌃ ;

Notes

Some shortcuts depend on the active selection — entering an array formula needs a selected range, and fill commands need a source cell highlighted. The whole reference and its search run in your browser; nothing you type is uploaded.