Freeze Panes
Windows
Alt→W→F→F
Or via the menu: View → Freeze Panes → Freeze Panes
Locks rows above and columns left of the selected cell.
Locks rows above and columns left of the selected cell. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Or via the menu: View → Freeze Panes → Freeze Panes
Locks rows above and columns left of the selected cell.
Press Alt → W → F → F. You can also use View → Freeze Panes → Freeze Panes.
There's no direct shortcut. Use View → Freeze Panes.
There's no direct shortcut. Use View → Freeze → Up to current row.
On Windows, press Alt → W → F → F.
There's no direct key we've confirmed. Use View → Freeze Panes.
Use View → Freeze → Up to current row.
Not yet verified · Last reviewed: not yet reviewed · Microsoft's official shortcut list