Excel for Mac shortcuts

Edit active cell

F2

Depending on the function key setting, also press Fn.

Insert line break in cell

Control+Option+Enter

While editing the cell.

Open Format Cells

Command+1

Fill down

Command+D

Select the target range including the source cell.

Fill right

Command+R

Select the target range including the source cell.

Insert AutoSum

Command+Shift+T

Toggle absolute or relative cell reference

Command+T

While editing a cell reference in a formula.

Create table

Command+T

In the cell grid; not while editing a formula.

Toggle filter

Command+Shift+F

Open Paste Special

Command+Control+V

Select next worksheet

Option+→

Select previous worksheet

Option+←

Insert today's date

Control+;

Insert current time

Command+;

Show formulas instead of values

Control+`

Jump to bottom of data range

Command+↓

Jump to right edge of data range

Command+→

Select entire row

Shift+Space

Select entire column

Control+Space

May conflict with the macOS shortcut for input sources.

Open Go To

Control+G

Open Find and Replace

Control+H

Insert hyperlink

Command+K

Edit cell note

Shift+F2

Depending on the function key setting, also press Fn.

Create new workbook

Command+N

Open Save As

Command+Shift+S