advanced excel ms training - Fixing data subjects

Resolved · Low Priority · Version Standard

Tue 14 Nov 2006, 13:10 Joanna Arnold (guest) said...

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

Tue 14 Nov 2006, 13:16 Trainer Amanda said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips