Toggle absolute reference: the shortcut in both apps
On Windows it is usually F4 (2 of 2 apps). The table shows where each app agrees and where it differs.
| App | Mac | Windows | Linux |
|---|---|---|---|
| Google SheetsToggle absolute and relative references | F4 | F4 | F4 |
| ExcelCycle through absolute and relative references in a formula · Editing a cell reference | CmdTorF4 | F4 | — |
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.