You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

How to freeze multiple rows and columns in Excel You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...

How to unhide rows and columns in Excel Unhiding a row requires a bit more work than hiding them, because you must select a cell in the rows adjacent to the hidden rows.