Formulas and Functions

Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to Cells

These shortcuts can help advanced Excel users and even beginners build formulas and use functions quickly to create spreadsheet magic like a pro.

To do this

Windows keys

Mac keys

Toggle relative and absolute references

F4

⌘ T

Open Insert Function dialog

Shift F3

Fn Shift F3

Autosum all selected cells

Alt =

⌘ Shift T

Toggle cell formulas

Ctrl '

Control '

Insert the function arguments into your current formula

Ctrl Shift A

Control Shift A

Enter an array formula

Ctrl Shift Enter

Control Shift Enter

Calculate all worksheets

F9

Fn F9

Calculate only active worksheet

Shift F9

Fn Shift F9

Evaluate formula

F9

Fn F9

Hide or Show the formula bar

Ctrl Shift U

Control Shift U

Open name manager (Windows)/Define name (Mac) dialog

Ctrl F3

Fn C P

Open name manager for columns/rows

Ctrl Shift F3

Fn Control Shift F3

Paste name into formula

F3

N/A

Accept autocomplete function

Tab

Shift Tab

Worksheets and Workbooks

View

Row and Column Selection

Ribbon Control

Pivot Tables

Operating within a Cell

Navigating and Selecting Cells

Help and Menus

Group Selection

General Excel

General Cell Control