⚡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. 1.Open Google Sheets in your browser.
  2. 2.Select the cell(s) you want to work with.
  3. 3.Press F4 to toggle absolute and relative references.

🎯 Shortcut Keys by Platform

PlatformShortcut
💻 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 111 keyboard shortcuts to boost your productivity

View All Shortcuts ➜