Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 772
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,549
Default 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?
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
Rows to repeat at top of each page Jane Excel Worksheet Functions 4 October 31st 07 03:44 PM
Need rows to repeat Except for last page carrera Excel Discussion (Misc queries) 1 August 3rd 07 07:22 PM
ROWS TO REPEAT ON EACH PAGE jpreman Excel Worksheet Functions 4 August 16th 06 05:15 PM
How can you get different rows to repeat on each page InLikeFlynnCA Excel Discussion (Misc queries) 1 June 9th 06 01:46 AM
How can I repeat the rows at the down of the page ? Hakan71 Excel Discussion (Misc queries) 0 February 9th 06 11:52 AM


All times are GMT +1. The time now is 05:28 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"