How can I stop headings from moving when scrolling in Excel?

Jonathan Mould March 6, 2011

In some spreadsheets I have used the headings don’t move when I scroll, but the rest of the data does. How can I do this?

  1. Tina
    March 6, 2011 at 6:50 pm


    you can freeze column or row headers easily via the toolbar. Just mark the first row from the top or column from the left that should scroll, then go to > Window in the toolbar and select > Freeze Pane.

    You will find a video how it's done here: Economics Network

    • Jonathan Mould
      March 7, 2011 at 9:14 pm

      thanks Tina, i suspected there would be a simple answer :)

      • Tina
        March 7, 2011 at 9:19 pm

        Simple solutions are always the most fun. :) Glad I could help!