Forum Discussion
Onscreen display
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).
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.
- Onscreen display
Robert222325 in Excel on Jun 21 2024
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).
Thanks for replies, problem solved. View, Freeze Panes, Top Row. Finally able to expand frozen top pane to three rows, which is what I set up 10 years ago.
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?
