Share via

How do I create fixed header in excel

Anonymous
2012-03-31T20:06:51+00:00

I have created a large spreadsheet, but I get lost between columns sometimes. If I could leave the column headings always in view, and allow the remainder of the spreadsheet to scroll, it would help me no end.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2012-03-31T20:16:15+00:00

    Select the View tab, find the Windows panel and click the button labeled "Freeze Panes" in it... click the "Freeze Top Row" item in the list... that will freeze Row 1 (your headings) while you scroll the rest of the sheet.

    100+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-05-02T21:15:55+00:00

    I have three rows of header text (rows 1- 3).  When I select just those three rows and click on Freeze Panes on the View tab, it doesn't just freeze rows 1-3; it freezes rows 1-15.  Is there a way to just freeze rows 1-3?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-12-04T07:59:53+00:00

    Is there is a way to make an embedded excel spreadsheet on a website have a fixed header?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-03-31T21:52:17+00:00

    Thank you Rick, it's easy when you know how!

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2012-08-05T18:10:00+00:00

    I had the same question but didnt know what the function was called (freeze panes). I now also know that it is not available in Excel Starter, how gutted am I?.... :(

    0 comments