Freeze titles for added visibility in Excel

Freezing Titles (or panes)

Whenever you’re working with a lot of data, you can find that when you scroll down your spreadsheet, your headings disappear. By understanding how to freeze panes in your worksheet, you’ll be able to work quickly without the need to continually scroll up or to the left.

You may want to see certain rows or columns all the time in your worksheet, especially header cells. By freezing rows or columns in place, you’ll be able to scroll through your content while continuing to view the frozen cells.

To Freeze Rows

  1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.

  1. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

  1. The rows will be frozen in place, as indicated by the grey line. You can scroll down the worksheet while continuing to view the frozen rows at the top. In our example, we’ve scrolled down to row 18.

To freeze columns

  1. Select the column to the right of the column(s) you want to freeze. In our example, we want to freeze column A, so we’ll select column B.

  1. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

  1. The column will be frozen in place, as indicated by the grey line. You can scroll across the worksheet while continuing to view the frozen column on the left. In our example, we’ve scrolled across to column E.

Freezing Top Row or First Column

In my (humble?) opinion, this is quite poorly named (or at least not as clear as it could be!).

Most of the time, when working with Excel data, everything is based on the data block that you’re working with. So, for example, tell Excel to do a sort & it assumes that the first row are your headers, create a table & the same thing…

So you would expect that Freeze Top Row or Freeze First Column from the drop-down menu would relate to the first row or column of your data… but no, it’s not that straightforward… it refers to the first Visible row or column that you can see. Most tutorials refer to Column A or Row 1 & if you’re at the top of your spreadsheet, then it’s likely that these are the rows that will be frozen… however, if the first row that you can see is Row 7 & the first column Column C, then these are the ones that will be frozen

To unfreeze panes:

If you want to select a different view option, you may first need to reset the spreadsheet by unfreezing panes. To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.