β‘Formulas
How to toggle absolute and relative references in Google Sheets
Cycle through absolute ($A$1), mixed ($A1, A$1), and relative (A1) cell references.
F4
π Step-by-Step Guide
- 1.Open Google Sheets in your browser.
- 2.Select the cell(s) you want to work with.
- 3.Press F4 to toggle absolute and relative references.
π― Shortcut Keys by Platform
| Platform | Shortcut |
|---|---|
| π» PC / Windows | F4 |
| π Mac | Fn + F4 |
| π» Chrome OS | F4 |
π‘ Pro Tips
- You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
- If you forget this shortcut, press Ctrl + / (or β + / on Mac) to see all available keyboard shortcuts in Google Sheets.
βFrequently Asked Questions
π
Explore All Google Sheets Shortcuts
Discover all 111 keyboard shortcuts to speed up your workflow and boost your productivity.
View All Shortcuts ββ‘ Accelerator Keys
Accelerator Keys shows you browser shortcuts the moment you need them - no cheat sheets, no memorizing.
Add to browser - it's free