My boss and I are compiling a huge Excel spreadsheet that summarizes everything our organization has ever done. It’s as big of a pain as it sounds. What makes it worse is having to scroll all the way back to the beginning to view the headers. The solution: make persistent headers in Excel.
The trick to making a persistent header that shows all the time, even after scrolling, hides in the View tab in Excel 2007.
Click View, then click Freeze Panes. There, you can choose from freezing whatever you have selected, the first row, or the first column.
And if for some reason you want to do the opposite and get rid of that header, click Freeze Panes, and one of the options will be to unfreeze whatever panes you previously selected.
Sometimes you may run into issues, like Excel not scrolling. The solution is to unfreeze the panes, then freeze again. The bigger the spreadsheet, the more often you have to do this.