Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default row heading to show on all pages

I have the heading of my worksheet on row 1 and I want this same heading to
follow on every page. The rows on a page can change so I don't want to do a
page break and then copy and paste the row.

So, is there a way to have the heading row floating so it will be listed on
the top row of every page printed?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,549
Default row heading to show on all pages


See response in the programming.
Please post your question in only one group.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Smilen2day"

wrote in message
I have the heading of my worksheet on row 1 and I want this same heading to
follow on every page. The rows on a page can change so I don't want to do a
page break and then copy and paste the row.

So, is there a way to have the heading row floating so it will be listed on
the top row of every page printed?

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
Heading from first row to follow all pages Smilen2day Setting up and Configuration of Excel 1 June 3rd 08 08:57 PM
Print Cell Data in heading of pages Mike Polinske[_2_] Excel Discussion (Misc queries) 4 January 2nd 08 08:56 PM
how can I exclude a heading but show that heading in sheet. Hunter Excel Discussion (Misc queries) 4 January 8th 07 07:35 AM
How do I keep heading so it prints on multiple pages de2137 Excel Discussion (Misc queries) 5 October 17th 06 12:10 PM
heading on all pages Shanon Excel Discussion (Misc queries) 1 March 28th 06 05:24 PM


All times are GMT +1. The time now is 11:51 PM.

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

About Us

"It's about Microsoft Excel"