A very Quick Excel question

  Paul-has-more-of-a-clue...:@) 19:20 01 Jan 2008
Locked

Hi
I have done a list in exel that is 33 pages long, but want to put the heading of each list at the top of every page. Can I do this without cutting and pasting (Hence all my pages going out of place anyhow?

Your help is always admired....

Paul....

PS and of course HAPPY NEW YEAR!!!!

  MAJ 19:23 01 Jan 2008

Go to the line below the headings and highlight the whole line, then go to Window > Freeze Panes.

  octal 19:31 01 Jan 2008

If you mean printing the top line of entries then yes you can do it, but I'm blessed if I can remember at the moment how to do it in XL. I can do it in Open Office, so I think you are looking for something like repeat rows in the Edit Print.

  octal 19:34 01 Jan 2008

Just to add in Open Office it's in Format>Print Ranges>Edit and I think it's something similar in XL.

  MRCPB 19:36 01 Jan 2008

To get it to print at the top of every page its File > Page Setup > Sheet (tab)

This then has "Rows to repeat at top". Put the rows you want to repeat, and this will print at the top of every page.

  Paul-has-more-of-a-clue...:@) 21:12 01 Jan 2008

that is exactly what I needed

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?