Lock Cell Reference
Windows
F4
Toggles $ signs to make a reference absolute.
Excel Lock Cell Reference Shortcut for Windows, Mac & Web
Toggles $ signs to make a reference absolute. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Quick Answer
- Windows
- F4
- Mac
- Cmd+T
- Web
- Not confirmed yet
How to lock cell reference in Excel with the keyboard
- Open Excel and go to where you want to lock cell reference.
- Press F4 on Windows or Cmd + T on Mac.
Excel Lock Cell Reference Shortcut for Windows
Press F4.
Excel Lock Cell Reference Shortcut for Mac
Press Cmd + T.
Excel Lock Cell Reference Shortcut for Excel Web
We haven't confirmed a Excel Web shortcut for this yet.
Related Shortcuts
Frequently asked questions
What is the Excel lock cell reference shortcut?
On Windows, press F4. On a Mac, press Cmd + T.
Is there a Mac shortcut to lock cell reference in Excel?
Yes: Cmd + T.
Does it work in Excel for the web?
We haven't confirmed a web version shortcut for this yet.
Verified 2026-10-07 · Last reviewed: 2026-10-07 · Microsoft's official shortcut list