Microsoft Excel – Freezing the top row

In this tutorial we will be freezing the top row of our Excel spreadsheet, this will allow us to keep the top row visible even when scrolling through the spreadsheet.

To do this carry out the following steps.

  1. With your spreadsheet open click on the ‘View’ tab along the top.
  2. Within the ribbon click on ‘Freeze Panes’.
  3. Within the dropdown click ‘Freeze Top Row’.

Leave a Reply