The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Column headings

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Column headings

Resolved · Medium Priority · Version 2007

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

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.

For upcoming training course dates see: Pricing & availability

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.

Excel articles

· Why Should I Learn Visual Basic in Excel?
· What Are Sparklines In Excel 2010?
· Excel: Survival Of The Fittest
· Charting Your Success With Excel 2007
· What Makes A Good Spreadsheet?

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

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips

Tips On Indenting Tasks In Microsoft Project

Once you start creating your own project plans, you may need to create a structure of summary tasks and sub tasks by using Project's indenting and outdenting buttons. This article summarises how to do this and describes different situations in Project where you need to be careful how this feature is used.

» Article: Ms project training

I seem to remeber there was a way to do the following but I can't remember how....

I have a data list, one colum is a date (eg 03/10/2008). I woul like to add a new column that just gives the month (eg October).

The data list is over 1000 long and 1..