How to freeze a row in Excel Step 1: Pick out the row or rows you want to freeze. These will be the rows that will stay with you as you scroll through the spreadsheet.

Force header columns and rows in Numbers to stay still and visible while you scroll across the rest of the spreadsheet.