Excel Fixing headings on each sheet

[Mike]

Hi all

Any idea how to fix heading on sheets

[Nemesis]

Can you explain a little more ??

[Mike]

Originally Posted by Nemesis

Can you explain a little more ??

Sorry was in a bit of a rush............I have an excel s/s with heading in each column.

The sheet is pages long and want to fix the heading so they appear on each sheeet....rather than type them on each.


Hope that is a bit clearer

[Nemesis]

Click in Column A2, i.e. the left hand column under the headings and use Window - Freeze Panes.

That should keep the headings viewable as you page down the rows.

HTH

[andygrif]

I'm not sure that will help Nem. This is only for on-screen use, not printing. This is what you need to do to print the titles on each page:



This is done in File> Page Set-Up

Go to the 'Sheet' tab, and there you'll see 'Print Titles' If you click in the field next to this, it will then let you go to your workbook again, and you can there hiughlight the columns you want repeated on each page. Once you've selected these, press OK in the setup box again - and you're done!

[Nemesis]

Well that should cover both just viewing and printing

[andygrif]

Originally Posted by Nemesis

Well that should cover both just viewing and printing

Exactly! Actually I made a little mistake...when I said highlight colums, I meant highlight rows, the row with the title in.

[Mike]

Originally Posted by andygrif

I'm not sure that will help Nem. This is only for on-screen use, not printing. This is what you need to do to print the titles on each page:



This is done in File> Page Set-Up

Go to the 'Sheet' tab, and there you'll see 'Print Titles' If you click in the field next to this, it will then let you go to your workbook again, and you can there hiughlight the columns you want repeated on each page. Once you've selected these, press OK in the setup box again - and you're done!

Andy

Thanks for the help..............cheers Mike

[andygrif]

You're welcome - happy to help