Freeze the Top Row in Excel

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”


To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!

One thought on “Freeze the Top Row in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *