Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 31st 07, 11:16 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 202
Default Rows to repeat at top of each page

I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I also
do not want the last page to be a separate sheet. Is this possible?

  #2   Report Post  
Old October 31st 07, 11:45 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default Rows to repeat at top of each page

No. Someone could possibly write a VBA subroutine to print the first few
pages, fix the headers and then print the last page.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I
also
do not want the last page to be a separate sheet. Is this possible?



  #3   Report Post  
Old October 31st 07, 02:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2,836
Default Rows to repeat at top of each page

Have you tried fiddling with this?
File Page Setup Sheet Rows to repeat at top

Hope that helps,
Ryan---

--
RyGuy


"Bernard Liengme" wrote:

No. Someone could possibly write a VBA subroutine to print the first few
pages, fix the headers and then print the last page.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I
also
do not want the last page to be a separate sheet. Is this possible?




  #4   Report Post  
Old October 31st 07, 03:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 345
Default Rows to repeat at top of each page

A possible solution:
Assuming all data is on one worksheet, create all your pages, for printing,
below each other down the worksheet except for the last page (the one you do
not want the headers on. Leave a column blank and create the last page (that
doesn't require headers) alongside page one (i.e. start in Row 1)
Highlight only the pages with data for printing as the 'setprint area'.
Look at your worksheet using Page Break Preview. Check pagebreaks are correct.
Then print: the only draw back, you need to specify the print page range
(e.g. page 1 to page ?) else you'll get a blank sheet of paper for every
printed page.
Hope this works for you.
Regards
Ron

"Jane" wrote:

I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I also
do not want the last page to be a separate sheet. Is this possible?

  #5   Report Post  
Old October 31st 07, 03:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Rows to repeat at top of each page

Sub Test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
ActiveSheet.PrintOut From:=1, To:=TotPages - 1
.PrintTitleRows = ""
ActiveSheet.PrintOut From:=TotPages, To:=TotPages
End With
End Sub

Credit an assist to Ron de Bruin

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 04:16:02 -0700, Jane wrote:

I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I also
do not want the last page to be a separate sheet. 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
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
Rows to repeat on each page jpreman Excel Worksheet Functions 6 August 16th 06 03:36 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 10:00 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017