How to Freeze More than One Column in Excel

Written by Darlene Antonelli, MA

Last Updated: January 20, 2020

This wikiHow will show you how to freeze panes to lock columns in Excel. When you freeze a column, it will stay visible when you're scrolling through that worksheet.

Steps

Download Article

1
Open your project in Excel. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.
- 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}
2
Select a cell to the right of the column you want to freeze. The frozen columns will remain visible when you scroll through the worksheet.
- You can press Ctrl or Cmd as you click a cell to select more than one, or you can freeze each column individually.
Advertisement
You'll see this either in the editing ribbon above the document space or at the top of your screen.
A menu will drop-down. You have options to freeze specific panes or freeze the first column and row.
This will freeze the panes in the columns next to what you have selected.^{[2]
X
Research source}