How do i freeze both a column and row in excel?

This article describes how to freeze rows and columns in Excel so that they're always visible, no matter where you scroll. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007; Excel Online; and Excel for Mac 2016 and later.

Freeze the Top Row

Follow these three steps to get your worksheet's header to stay in place.

1. Select View on the ribbon.

2. Select Freeze Panes. If you're using Excel for Mac, skip this step.

3. Select Freeze Top Row.

   
   

4. A border appears just below Row 1 to indicate that the area above the line has been frozen. The data in row 1 remains visible as you scroll because the entire row is pinned to the top.

Freeze the First Column

To freeze the first column of a worksheet:

1. Select View.

2. Select Freeze Panes. If you're using Excel for Mac, skip this step.

3. Select Freeze First Column.

   
   

4. The entire column A area is frozen, indicated by the black border between columns A and B. Enter some data into column A and scroll to the right; you'll see the data move with you.

Freeze Both Columns and Rows

To keep specified rows and columns visible:

1. Select a cell below the row that you want to freeze and to the right of the column you want to freeze. These are the rows and columns that will stay visible when you scroll.

2. Select View.

3. Select Freeze Panes. If you're using Excel for Mac, skip this step.

4. Select Freeze Panes.

   
   

5. Two black lines appear on the sheet to show which panes are frozen. The rows above the horizontal line are kept visible while scrolling. The columns to the left of the vertical line are kept visible while scrolling.

Unfreeze Columns and Rows

When you no longer want certain rows and columns to stay in place when you scroll, unfreeze all the panes in Excel. The data in the frames will remain, but the rows and columns that were frozen will return to their original positions.

To unfreeze panes, select View > Freeze Panes > Unfreeze Panes. On Excel for Mac, select View > Unfreeze Panes instead.

FAQ

• Why would I freeze rows in Microsoft Excel?

  Freezing rows keeps them visible across the top of your screen, no matter how far down you scroll. This is useful when a spreadsheet's rows extend downward past the height of your computer's screen and has multiple columns.

• Why would I freeze columns in Microsoft Excel?

  Freezing columns keeps them visible on the left side of your screen, no matter how far to the right you scroll. This is useful when a spreadsheet's columns extend to the right past the width of your computer's screen and has multiple rows.

  This Excel tutorial explains how to freeze panes to keep the first row and first column visible when scrolling in Excel 2013 (with screenshots and step-by-step instructions).

  See solution in other versions of Excel:

  • Excel 2011 for Mac
  • Excel 2010
  • Excel 2007
  • Excel 2003

  Question: In Microsoft Excel 2013, I have a spreadsheet with column headings. I need to freeze the first row and also freeze the first column. That way, I can see the first row and first column at all times even when I scroll. How can I do this?

  Answer: If you need to see the first column (column A) and first row (row 1) even after scrolling, you could try freezing the pane in Excel.

  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. Then click on the Freeze Panes option in the popup menu.

  Can you freeze the first row and column in Excel at the same time?

  To freeze the top row and the first column at the same time, click cell B2. Then, on the View tab, click Freeze Panes.

  Why can't I freeze both rows and columns in Excel?

  To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. You will want your cursor to be below the row(s) you want to freeze and to the right of any column(s) you want to freeze.