ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to start header on second page? (https://www.excelbanter.com/excel-discussion-misc-queries/54347-how-start-header-second-page.html)

LLeips

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?

Don Guillett

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?




Ron de Bruin

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?




bill k

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



All times are GMT +1. The time now is 11:12 AM.

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