advanced excel ms training - 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