Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not sure what to title this???? | Excel Worksheet Functions | |||
where's my title bar? | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Show full path title in title bar? | New Users to Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |