View Single Post
Old 27-04-2004, 14:34   #5
andygrif
Inactive
 
Join Date: Jul 2003
Posts: 2,820
andygrif has a bronze arrayandygrif has a bronze arrayandygrif has a bronze array
andygrif has a bronze arrayandygrif has a bronze arrayandygrif has a bronze arrayandygrif has a bronze arrayandygrif has a bronze arrayandygrif has a bronze arrayandygrif has a bronze array
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!
andygrif is offline   Reply With Quote