How to freeze columns or rows in a list

In this lesson we’ll look at how to do that.

Let’s take a look.

Here we have a large data table with a header row at the top.

Notice that as we scroll down through the data, the headers scroll off the screen.

And, if we scroll to the right, the company name is no longer visible.

These options are visible on the view tab in the Freeze Panes menu.

To unfreeze the top row, choose Unfreeze Panes from the same menu.

To freeze only the first visible column, select Freeze First Column from the menu.

To unfreeze the first column, choose Unfreeze Panes from the menu.

you might also freeze both columns and rows at the same time.

Then choose Freeze Panes from the menu.

Choose Unfreeze Panes to reset.

Note that freezing panes has no effect on printing.

It only affects your view of the worksheet on screen.