98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Fixing data subjects
advanced excel ms training - Fixing data subjects
Resolved · Low Priority · Version Standard
Tue 14 Nov 2006, 13:10Joanna 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:16Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting List SubtotalsIf 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. |
