Fixing data subjects
How can I fix the headers on an excel spreadsheet so that when I scroll down the headers still remain with in view... ?
RE: Fixing data subjects
Hi Joanna
The feature you need to use to achieve this is 'Freeze Panes'.
This can be found under Window on the menu bar.
Before going to Windows-Freeze Panes, you need to make sure you have selected an appropriate cell in your spreadsheet. If your column headers are in say, row 3, for example, you need to select cell A4.
If you accidently freeze the wrong area of your screen, you can go to Window-Unfreeze Panes then try again.
Hope this helps - Amanda