Buzz
Freezing multiple rows in Excel. In an Excel spreadsheet with a large amount of data, containing numerous rows and columns, as you scroll down, the header row disappears. In lengthy tables, users need to freeze the header row to keep it visible even when scrolling down.
Fixing a Single Row in Excel
If you only need to fix the first row in Excel, on the View tab, select Freeze Panes => choose Freeze Top Row.
First row of the spreadsheet is now fixed. You can scroll down and still see the first row.
Note:
The Freeze Top Row tool fixes the first visible row in the spreadsheet, excluding hidden rows. So, if you hide row 1, Freeze Top Row will consider row 2 as the first row of the spreadsheet. Consider the following example: Row 1 of Excel has been hidden.
By fixing a row using the Freeze Top Row tool, Excel understands that row 2 will be the first row in the spreadsheet, and row 2 will be fixed.
Fixing multiple rows in Excel
To fix multiple rows, follow these steps:
Place the cursor at the first cell of the row below the rows you want to fix. For example, if you want to fix rows 1 and 2, place the cursor at cell A3 (1). On the View (2) tab, select Freeze Panes (3) => choose Freeze Panes (4).
The result is that rows 1 and 2 are fixed.
How to remove row freeze
To remove row freeze, on the View (1) tab, select Freeze Panes (2) => choose Unfreeze Panes (3).
Here, Software Tricks has guided you on how to fix one or more rows in Excel spreadsheet. Wish you success!
