Toggle Cell Lock Reference
Switch the cell reference in a formula between absolute mixed and relative.
Keyboard shortcut by app
| App | Windows | Mac |
|---|---|---|
| Microsoft 365 | ||
| Excel |
F4 |
Fn+F4 |
| Word | Not available | Not available |
| PowerPoint | Not available | Not available |
| Outlook | Not available | Not available |
| Teams | Not available | Not available |
| Google Workspace | ||
| Google Sheets |
F4 |
Fn+F4F4 |
| Google Docs | Not available | Not available |
| Google Slides | Not available | Not available |
Popular Functions
Hand-picked function guides that work in both Excel and Google Sheets.