Freeze Pane | Keyboard Shortcut | Microsoft Excel

HomeExcel Keyboard ShortcutsFreeze Pane | Keyboard Shortcut | Microsoft Excel

A freeze pane is a feature in Excel used to freeze or lock the panes while scrolling anywhere in the sheet to make that freeze data visible. When users work with huge data sets, they prefer to freeze the header or some specific rows and columns to make them visible all the time when they scroll to any part of the sheet.

With the Freeze Pane, Users can freeze the header only or the first column only, or the combination of specific rows and columns based on your requirements.

Keyboard Shortcut to Freeze Pane in the Excel

The keyboard shortcuts for all the freeze pane options are below:

shortcut-to-freeze-column

Alt →W → F → R    (To freeze the header only)

shortcut-to-freeze-header

Alt → W → F → C   (To freeze the first column only )

shortcut-to-freeze-both-rows-and-columns

Alt → W → F → F   ( To freeze the combination of rows and columns or unfreeze the already freeze pane)

Steps to Freeze Pane Using Keyboard Shortcut

  • To freeze only the header row (first row), just click anywhere in the sheet and press “Alt → W → F → R” in sequence, and your header row will get freeze and will be visible all the time even when you scroll anywhere in the sheet.
  •  If you want to scroll towards the right side and want to freeze the first column instead of the row, just click anywhere in the sheet and press “Alt → W → F → C” in sequence, and your first column will get freeze.
  • To freeze the combination of specific rows and columns, go to the cell to the left and above of which column and rows you want to freeze, and then press “Alt → W → F → F” and your combination of rows and columns will get freeze together.
  • To unfreeze the pane, just simply press “Alt → W → F → F”.
column-to-freeze-rows-and-columns

In the above image first, we have gone to cell C3 and then pressed “Alt → W → F → F” due to which the rows above that cell and columns to the left of that cell are got freeze and now if we scroll to the down, the top two rows will be visible all the time and if we scroll towards the right the first two columns will be visible all the time.

➜ Excel Shortcuts Cheat Sheet (PDF)