Workbook I created 10 years ago and use monthly--I have column headings displayed regardless of how far down I have gone--until today. How can I make them show up on the top of the screen I am working on (and why have they disappeared).
Activate the View tab of the ribbon.
In the Window group, click Freeze Panes.
If the first item is 'Unfreeze Panes', select that, then click Freeze Panes again.
Select 'Freeze Top Row'.
Does that solve your problem?
An alternative option is to use Excel Tables for data. Once the header row has scrolled off sheet the sheet headings will be replaced by column names. That requires Excel 2007 or later.
