How do i keep the header visible when scrolling in excel
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:
…
To freeze the top row or first column:
- From the View tab, Windows Group, click the Freeze Panes drop down arrow.
- Select either Freeze Top Row or Freeze First Column.
- 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.