How do I freeze a header row in Excel?

Freeze columns and rows in Excel
  1. Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).
  2. On the View tab, click Freeze Panes > Freeze Panes.

How do I freeze header rows in Excel 2016?

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.
  2. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
  3. The rows will be frozen in place, as indicated by the gray line.

How do I freeze a header in Excel 2010?

To freeze the top row, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Top Row option in the popup menu. Now when you scroll down, you should still continue to see the column headings.

How do I keep the top column in Excel when scrolling?

Steps to Lock Rows/Columns in Excel
  1. Go to the View tab and click the Freeze Panes button.
  2. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. I will select Freeze Top Row to lock the first row in place.
  3. That’s it!

Why can’t I freeze panes in Excel?

Causes of Excel Freeze Panes Not Working:

The causes of this issue are when your Excel worksheet is in the page layout view, when Windows protection is turned on and also when the Excel sheet is protected by the earlier versions of Excel. Because of all this issues, Excel Freeze Panes Not Work properly.

Can you freeze a row and a column in Excel?

Besides locking columns and rows separately, Microsoft Excel lets you freeze both rows and columns at the same time. Here’s how: Select a cell below the last row and to the right of the last column you’d like to freeze. On the View tab, click Freeze Panes > Freeze Panes.

How do I freeze both top row and first column?

To freeze the top row or first column:
  1. From the View tab, Windows Group, click the Freeze Panes drop down arrow.
  2. Select either Freeze Top Row or Freeze First Column.
  3. Excel inserts a thin line to show you where the frozen pane begins.

How do you lock the top row in Excel so that it will always be visible when you scroll?

How to freeze the top row in Excel
  1. Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters.
  2. In the menu, click “View.”
  3. In the ribbon, click “Freeze Panes” and then click “Freeze Top Row.”

What is the shortcut key to freeze a column in Excel?

Here are the shortcuts for freezing rows/columns:
  1. To freeze the top row: ALT + W + F + R. Note that the top row gets fixed.
  2. To freeze the first column: ALT + W + F + C. Note that the left-most column gets fixed.

How do you freeze columns A and B and rows 1 and 2?

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. …
  2. Click the View tab on the Ribbon.
  3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. …
  4. The rows will be frozen in place, as indicated by the gray line.

How do I freeze the top row and multiple columns in Excel?

Freeze columns and rows
  1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
  2. Select View > Freeze Panes > Freeze Panes.

Why won’t Excel let me freeze top row and first column?

NOTE: Freezing panes only works when you are in Normal View. To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the VIEW tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group.

How do I freeze two columns in Excel?

Under view, browse to find freeze panes. Click on freeze panes to reveal the list of options, select the first option which is freeze panes. This option will freeze or rather lock the two columns in a way that they will always remain visible even after scrolling down.