Click cell B1 to freeze the first column.

Click on Freeze Top Row if header in First row or Freeze Panes if header in second or third row. Can you freeze multiple rows AND columns in Excel Click cell A2 to freeze the top row.

If Top row of your sheet is header, you need not to do anything, But if you have headers in second or third row, Select entire row below from header row by clicking in Row name.

If you are using Excel 2007, 20 the method is similar.

In this post, we will learn how to fix a Top row or more rows at same time. To overcome this problem, Microsoft Excel has built-in feature called Freeze Rows or Panes. Solution – How to fix header row in Excel? If I do not remember, we have to scroll back and view headers and then come back to last position. Select View > Freeze Panes > Freeze Panes. While I have to view other records, I have to scroll the page. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

Columns and rows: Select the rows and columns, then View > Freeze Panes. Scrolling Excel Data – Headers hidden by default Step 1: if you wanted the first two columns and the top 3 rows to remain visible, what you can do is select a cell below the last row we want frozen, and to the right of the last column we want frozen. First column: View > Freeze Panes (Windows only) > Freeze First Column.

Freeze first two rows in excel