Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to start header on second page?
I want the header to start on the second page. Other programs prompt you
where to start. Excel doesn't seem to do this. Do I have to write a macro to accomplish this? If so, how do I find out how to do that? |
#2
|
|||
|
|||
How to start header on second page?
IF you mean that you want a constant row to appear on each PRINTED sheet
then filepage setupsheetrows to appear -- Don Guillett SalesAid Software "LLeips" wrote in message ... I want the header to start on the second page. Other programs prompt you where to start. Excel doesn't seem to do this. Do I have to write a macro to accomplish this? If so, how do I find out how to do that? |
#3
|
|||
|
|||
How to start header on second page?
Hi
You must use a macro to do this http://www.rondebruin.nl/print.htm#Header -- Regards Ron de Bruin http://www.rondebruin.nl "LLeips" wrote in message ... I want the header to start on the second page. Other programs prompt you where to start. Excel doesn't seem to do this. Do I have to write a macro to accomplish this? If so, how do I find out how to do that? |
#4
|
|||
|
|||
How to start header on second page?
Ron's macro examples are an excellent resource, no doubt about that! If you do not want to work with macro's , you could have the cover sheet on a seperate worksheet without the header. Select both worksheets by holding the <cntrl while clicking on the second sheet and click onto print button. -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=483234 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
header and footer on every page except the first page? | Excel Discussion (Misc queries) | |||
How do I keep the header on the first page but hide it on the sec. | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |