ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel how to get header on only 1st page (https://www.excelbanter.com/excel-discussion-misc-queries/83163-excel-how-get-header-only-1st-page.html)

bobrink23

excel how to get header on only 1st page
 
I have used the header/footer option and want my graphical header to only
show up on the first page of my excel file when it prints. Currently it
applies to all print pages. Is there a way to enter a header using the
header/footer option and apply it only to page one without creating seperate
files, tabs, etc.?

Dave Peterson

excel how to get header on only 1st page
 
Maybe you can provide a dedicated macro that prints the worksheet.

The first thing the macro does is add the picture. Then prints page 1. Then it
removes the picture and prints pages 2-xxx.

You could even record a macro when you do it manually to get the code.

bobrink23 wrote:

I have used the header/footer option and want my graphical header to only
show up on the first page of my excel file when it prints. Currently it
applies to all print pages. Is there a way to enter a header using the
header/footer option and apply it only to page one without creating seperate
files, tabs, etc.?


--

Dave Peterson


All times are GMT +1. The time now is 11:07 PM.

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