Excel Fixing headings on each sheet
 

Hi all

Any idea how to fix heading on sheets

Re: Excel Fixing headings on each sheet
 

Can you explain a little more ??

Re: Excel Fixing headings on each sheet
 

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

Re: Excel Fixing headings on each sheet
 

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 :D

Re: Excel Fixing headings on each sheet
 

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!

Re: Excel Fixing headings on each sheet
 

Well that should cover both just viewing and printing :D

Re: Excel Fixing headings on each sheet
 

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

Re: Excel Fixing headings on each sheet
 

Andy

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

Re: Excel Fixing headings on each sheet
 

You're welcome - happy to help