![]() |
Title HELP!!!
Hi everyone,
I have this table running through from page 1 to 10. Title or the header for the table sits on top of the table. e.g. From A3 to I3 I have a title Name, Address, Gender etc etc and data associating with each title below it till page 10. I really don't know how I did it but when I actually print it, title from page1 is copied on top of the page 2 and so on. However if I have a title row which is more than 1 row, from second page till the last. it only shows the first part of the title row. How do I make title row continue when printed on every page? thank you for your help in advance Regards, James |
Title HELP!!!
On the menu -
File-Page setup... Go to the Sheet tab and enter the row numbers to repeat at the top. So, if you 'title' is in rows 1 and 2, enter "1:2" (without the quotes) "James8309" wrote: Hi everyone, I have this table running through from page 1 to 10. Title or the header for the table sits on top of the table. e.g. From A3 to I3 I have a title Name, Address, Gender etc etc and data associating with each title below it till page 10. I really don't know how I did it but when I actually print it, title from page1 is copied on top of the page 2 and so on. However if I have a title row which is more than 1 row, from second page till the last. it only shows the first part of the title row. How do I make title row continue when printed on every page? thank you for your help in advance Regards, James |
All times are GMT +1. The time now is 08:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com