Skip to content

↑↓ moveEnter openEsc close

Toggle absolute reference: the shortcut in both apps

2 apps · Mac, Windows and Linux

On Windows it is usually F4 (2 of 2 apps). The table shows where each app agrees and where it differs.

AppMacWindowsLinux
Google SheetsToggle absolute and relative referencesF4F4F4
ExcelCycle through absolute and relative references in a formula · Editing a cell referenceCmdTorF4F4—

Small screen: your system's keys only. Open an app's row for every system.

A dash means the app has no default binding, or does not run, on that system. Open a row for notes and the full key details.

How the apps compare

  • Mac: F4 in Google Sheets; Cmd+T in Excel.
  • Windows: every app here uses F4.
  • Linux: F4 in Google Sheets.

Where and when it works

  • Excel (Editing a cell reference).

Learn it by pressing it: Google Sheets shortcuts practice or Excel shortcuts practice.