⚡Fórmulas
How to alternar entre referências absolutas e relativas in Google Sheets
Alterne entre referências absolutas ($A$1), mistas ($A1, A$1) e relativas (A1).
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 alternar entre referências absolutas e relativas.
🎯 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