How to Freeze (Lock) Column Headings in Microsoft Excel

Techwalla may earn compensation through affiliate links in this story.

When you have a long Microsoft Excel spreadsheet that contains a lot of data, you might end up scrolling down far enough that the cells you have designated as column headers move out of view, making it harder to distinguish what the data in each column represents. Excel offers an option to freeze these cells and keep them permanently in view.

Advertisement

Step 1

Launch Excel and open your spreadsheet.

Video of the Day

Step 2

Select the "View" tab at the top of the Excel window.

Step 3

Click the "Freeze Panes" button. This will open a drop-down menu.

Step 4

Click "Freeze Top Row."

Tip

If you want to freeze more than one row, or you want to freeze both rows and columns, select the cell that is immediately below and to the right of the rows and columns you want to freeze and then click the "Freeze Panes" option in the "Freeze Panes" menu.

Advertisement

references