ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I keep the header on the first page but hide it on the sec. (https://www.excelbanter.com/excel-discussion-misc-queries/11207-how-do-i-keep-header-first-page-but-hide-sec.html)

victoria

How do I keep the header on the first page but hide it on the sec.
 
I am preparing a worksheet with a custom header for the first page. Under
the header I have column titles that I would like to appear on the second
page of my worksheet. How do I keep the column titles but delete the custom
header from the second page.

Dave Peterson

Ron deBruin has some code to get you started:
http://www.rondebruin.nl/print.htm#Header

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

victoria wrote:

I am preparing a worksheet with a custom header for the first page. Under
the header I have column titles that I would like to appear on the second
page of my worksheet. How do I keep the column titles but delete the custom
header from the second page.


--

Dave Peterson


All times are GMT +1. The time now is 07:28 AM.

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