3 Simple Ways To Freeze And Unfreeze Panes In Excel

This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. [1] X Research source

You can press Ctrl or Cmd as you click a cell to select more than one, or you can freeze each column individually.

You’ll notice when you freeze panes if you scroll away and a column or row stays on the screen.

This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. [3] X Research source

You can release the key when you are done making your selections.

You’ll notice when you freeze panes if you scroll away and a column or row stays on the screen.