A very Quick Excel question

  Paul-has-more-of-a-clue...:@) 19:20 01 Jan 08
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 08

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

  octal 19:31 01 Jan 08

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 08

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 08

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.

that is exactly what I needed

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 7 simple tips to get more out of…