advanced excel ms training - Fixing data subjects

The UK's most regular instructor-led training courses.
Training information: advanced excel ms training · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Fixing data subjects

by - Joanna Arnold [guest] (2006 Nov 14 Tue, 13:10) Reply

How can I fix the headers on an excel spreadsheet so that when I scroll down the headers still remain with in view... ?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Fixing data subjects

by - trainer Amanda platinum contributer [968 posts] (2006 Nov 14 Tue, 13:16) Reply

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

· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Training: Essential for Today's Employees
· Basic Excel Training
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips