#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 105
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not sure what to title this???? Buttercup Excel Worksheet Functions 8 December 15th 07 06:19 PM
where's my title bar? sf Excel Discussion (Misc queries) 1 October 7th 06 02:17 PM
Named range=Column title,comumn title in cellB6 use B6in equation Graham Excel Discussion (Misc queries) 2 July 21st 06 10:03 AM
Show full path title in title bar? Nor New Users to Excel 4 November 4th 05 06:00 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"