Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing header rows..
Hi all
Here's hoping you're all having good holidays! My situation: I have a worksheet 3 pages long. I need the first 2 pages to print the same header rows, but the 3rd sheet not to show those headers, as it has it's own. Is there any solution other than printing the 3rd page separately?? If I do that, I believe the page numbering will be messed up?? Thanks -- smither fan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing header rows..
hi
guess. do have "row to print at top" set in page setup? 2003 on the meun barfilepage setupsheet tabrow to print at top Regards FSt1 "Ross" wrote: Hi all Here's hoping you're all having good holidays! My situation: I have a worksheet 3 pages long. I need the first 2 pages to print the same header rows, but the 3rd sheet not to show those headers, as it has it's own. Is there any solution other than printing the 3rd page separately?? If I do that, I believe the page numbering will be messed up?? Thanks -- smither fan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing header rows..
hi
not to my knowledge. you can format the cell to font marlett then use the A key to put a check in the cell. del key to remove. Regards FSt1 "Ross" wrote: Hi all Here's hoping you're all having good holidays! My situation: I have a worksheet 3 pages long. I need the first 2 pages to print the same header rows, but the 3rd sheet not to show those headers, as it has it's own. Is there any solution other than printing the 3rd page separately?? If I do that, I believe the page numbering will be messed up?? Thanks -- smither fan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing header rows..
hi
posted in wrong place. ignore. sorry. regards FSt1 "FSt1" wrote: hi not to my knowledge. you can format the cell to font marlett then use the A key to put a check in the cell. del key to remove. Regards FSt1 "Ross" wrote: Hi all Here's hoping you're all having good holidays! My situation: I have a worksheet 3 pages long. I need the first 2 pages to print the same header rows, but the 3rd sheet not to show those headers, as it has it's own. Is there any solution other than printing the 3rd page separately?? If I do that, I believe the page numbering will be messed up?? Thanks -- smither fan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing header rows..
You mean "rows to repeat at top" to print on two pages only but not the
third or successive pages? This macro will give you two print jobs with continuous page numbering in a header or footer. Revised some code found at Ron de Bruin's Print Tips site. http://www.rondebruin.nl/print.htm Sub Test() Dim TotPages As Long TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") With ActiveSheet.PageSetup .PrintTitleRows = "$1:$2" 'adjust range to suit ActiveSheet.PrintOut From:=1, To:=2 .PrintTitleRows = "" ActiveSheet.PrintOut From:=3, To:=TotPages End With End Sub Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 14:56:00 -0800, Ross wrote: Hi all Here's hoping you're all having good holidays! My situation: I have a worksheet 3 pages long. I need the first 2 pages to print the same header rows, but the 3rd sheet not to show those headers, as it has it's own. Is there any solution other than printing the 3rd page separately?? If I do that, I believe the page numbering will be messed up?? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing header rows..
Hi Gord
Thanks for the response. I need the first two pages to have the same header rows, and the third to have its own. I was hoping 2003 could do that without having to write code, but apparently not. Seemed like it should be a simple thing especially since Word's been able to do that for years!?! Maybe they would do that if enough people suggest it. Anyway, thanks again... -- smither fan "Gord Dibben" wrote: You mean "rows to repeat at top" to print on two pages only but not the third or successive pages? This macro will give you two print jobs with continuous page numbering in a header or footer. Revised some code found at Ron de Bruin's Print Tips site. http://www.rondebruin.nl/print.htm Sub Test() Dim TotPages As Long TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") With ActiveSheet.PageSetup .PrintTitleRows = "$1:$2" 'adjust range to suit ActiveSheet.PrintOut From:=1, To:=2 .PrintTitleRows = "" ActiveSheet.PrintOut From:=3, To:=TotPages End With End Sub Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 14:56:00 -0800, Ross wrote: Hi all Here's hoping you're all having good holidays! My situation: I have a worksheet 3 pages long. I need the first 2 pages to print the same header rows, but the 3rd sheet not to show those headers, as it has it's own. Is there any solution other than printing the 3rd page separately?? If I do that, I believe the page numbering will be messed up?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing 'title' from properties in header | Excel Discussion (Misc queries) | |||
Printing header in EXCEL2007 | New Users to Excel | |||
Printing header row on each page | Excel Discussion (Misc queries) | |||
Printing Custom Header | Excel Discussion (Misc queries) | |||
Printing the page properties as header | Excel Discussion (Misc queries) |