Why does my header keep disappearing in Excel?

In Excel 2010 check the option to view headings in the Page Layout tab. Also, from File > Options > Advanced > Display options for this worksheet make sure to check the box to show row and column headers. Save the changes made.

How do I show the top row in Excel when scrolling?

Select the cell in the upper-left corner of the range you want to remain scrollable.

To freeze the top row or first column:
  1. From the View tab, Windows Group, click the Freeze Panes drop down arrow.
  2. Select either Freeze Top Row or Freeze First Column.
  3. Excel inserts a thin line to show you where the frozen pane begins.

How do I keep the top part of visible in Excel?

1. Stay in the worksheet you need to make top row always stay visible, then click View > Freeze Panes > Freeze Top Row. See screenshot: Then the top row of current worksheet is frozen and will always stay visible until you unfreeze it.

How do you make a floating header in Excel?