ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I repeat rows at the top, except the last page? (https://www.excelbanter.com/excel-worksheet-functions/188590-can-i-repeat-rows-top-except-last-page.html)

Wendigone

Can I repeat rows at the top, except the last page?
 
When printing, I want to repeat rows at the top of each page, except the last
page. Is this possible?

John Bundy

Can I repeat rows at the top, except the last page?
 
No way to turn it off on the last page that i know of. Go to File-Page
Setup-select the Sheet tab and select the rows to repeat at top. This gets
it down to printing all but the last, then the last seperately.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Wendigone" wrote:

When printing, I want to repeat rows at the top of each page, except the last
page. Is this possible?


Jim Cone[_2_]

Can I repeat rows at the top, except the last page?
 

Print the last page separately after removing the rows to repeat at top setting.--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - try Rows to Repeat at Bottom)



"Wendigone"

wrote in message
When printing, I want to repeat rows at the top of each page, except the last
page. Is this possible?

Wendigone

Can I repeat rows at the top, except the last page?
 
Thanks for the quick response. Much appreciated.

---Wendigone

"John Bundy" wrote:

No way to turn it off on the last page that i know of. Go to File-Page
Setup-select the Sheet tab and select the rows to repeat at top. This gets
it down to printing all but the last, then the last seperately.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Wendigone" wrote:

When printing, I want to repeat rows at the top of each page, except the last
page. Is this possible?



All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com