Freeze column and row headers in Excel

Contents
  1. Stop bars to keep track of where you are in the spreadsheet
  2. Freeze the top row of the sheet
  3. Freeze the first column of the worksheet
  4. Freeze both columns and rows of a sheet
  5. Unblock Columns and Rows in Excel

Stop bars to keep track of where you are in the spreadsheet

When working with large Excel spreadsheets, the column and row headings at the top and bottom of the left side of the sheet disappear if you scroll too far to the right or too far down. To avoid this problem, freeze rows and columns. Freezing locks certain columns or rows in place so that they are always visible at the top or side of the sheet, wherever you scroll.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010, 2007; Excel Online and Excel for Mac.

Freeze the top row of the sheet

Freezing the top row of a worksheet is a great way to keep your Excel headers visible at all times. Follow these three easy steps to keep this head in place.

To freeze the top row of a leaf:

  1. Select Vision on the adhesive tape

  2. Select To freeze † Skip this step if you’re using Excel for Mac.

  3. Select Freeze top row

  4. A border appears just below line 1 to indicate that the area above the line is frozen. The data in row 1 remains visible when you scroll down because the entire row is pinned to the top of Excel.

Freeze the first column of the worksheet

In addition to freezing the first row of a worksheet, you can just as easily freeze the first column.

To freeze the first column of a worksheet:

  1. Select Vision

  2. Select To freeze † Skip this step if you’re using Excel for Mac.

  3. Select Freeze first column

  4. The entire area of ​​column A is frozen, marked with a black border between column A and B. Enter some data in column A, scroll to the right and you will see the data move with you.

Freeze both columns and rows of a sheet

You can also freeze all rows above the active cell and all columns to the left of the active cell. These columns and rows always remain on the screen, no matter how far you scroll.

To keep specified rows and columns visible:

  1. Select the cell below the row you want to freeze and to the right of the column you want to freeze. These are the rows and columns that remain visible while scrolling.

  2. Select Vision

  3. Select To freeze † Skip this step if you’re using Excel for Mac.

  4. Select Stop panels.

  5. Two black lines appear on the sheet to indicate which panels are frozen. Lines above the horizontal line remain visible while scrolling. The columns to the left of the vertical line remain visible while scrolling.

Unblock Columns and Rows in Excel

If you no longer want certain rows and columns to stay in place when you scroll, unblock all windows in Excel. The data in the frames is preserved, but the frozen rows and columns return to their original position.

To unblock panels, select Vision “Freeze Panels” “Unlock panels” † Except for Excel for Mac where you choose Show Defrost panels

Leave a Reply

Your email address will not be published.