Column headings

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

Resolved · Medium Priority · Version 2007

1 post

ReplyWed 3 Feb 2010, 16:15Delegate Josephine said...

Josephine has attended:
Excel Introduction course

Column headings

I would like to know how you create headings that follow the page. so when you scroll down to the bottom you can still see what the headings of the colmns are.

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	2		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

1 post

ReplyWed 3 Feb 2010, 16:59 Edited on Tue 9 Mar 2010, 16:21Trainer Lena said...

RE: column headings

Dear Josephine,

Thanks for your forum enquiry, Please find below the answer to your question, however if you need any further assistance please do not hesitate to contact us via the Forum.

This feature in Excel is called Freeze Panes
It can be applied to both rows or columns.

After launching Excel, select the row or the Column immediately after the row/Column(header) you wish to freeze , click on the Ribbon and select view tab
From the window group select Freeze pane
If you wish to remove the freeze pane click again on the Ribbon, select View tab and from the window group click on Freeze panes button and select from the drop down unfreeze Panes

Kind Regards

Lena

Wed 10 Feb 2010: Automatically marked as resolved.

· Using Excel In Any Condition
· Want To Use Excel To Calculate Your Mortgage Repayments?
· What's In A Name?
· So what's new in Excel 2007?
· Charting Another Dimension With Excel

Please browse our web site to find out more about
advanced excel seminar training and other Microsoft training courses.