row heading to show on all pages

  • Thread starter Thread starter Smilen2day
  • Start date Start date
S

Smilen2day

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?
 
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"
<[email protected]>
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing a Different Row Heading Mid-way through a Spreadsheet 1
Row Heading to follow on all pages 2
Heading from first row to follow all pages 1
Print Column Heads WITHOUT Excel Column Lables 1
I don't want row 1 as the column headings 1
Atomatic subtotal in every pages. 1
Converting Rows to Columns 4
dynamic data copying between worksheets 0

Back
Top