To freeze a specific row, first, select the row immediately below the one you want to freeze. For example, if your headers occupy rows 1 and 2, select row 3 to keep the top two rows visible. 2.

Use table instead of freeze top row. Using Microsoft Excel Repair Tool. 1] Change the Page Layout view. If the spreadsheet is in Page Layout view, ...