2. In the menu, click "View." 3. In the ribbon, click "Freeze Panes" and then click "Freeze Top Row." Now, when you scroll through the spreadsheet, the top row that was visible will remain fixed ...