Entering and editing
"Toggle absolute and relative references" shortcut in Google Sheets
While typing a formula, adds or removes $ in the reference.
- Windows（Chrome）
- F4
- Mac（Chrome）
- fn+F4
What about Excel?
Excel (Windows) uses the same keys.
See the Excel shortcut guide →Practice these keys
Shortcuts in the same category
* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.