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 workin...
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.
