ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Get header only on first page of multi page excel file (https://www.excelbanter.com/excel-discussion-misc-queries/80254-get-header-only-first-page-multi-page-excel-file.html)

betwms

Get header only on first page of multi page excel file
 
I have a 16 page excel file and I want the header only on the first page. Is
there any way that this can be done?

kosciosco

Get header only on first page of multi page excel file
 

If you make the header part of the body of the page rather than a header
in the page setup, then it will only appear on the first page.

Hope that helps

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=527609


betwms

Get header only on first page of multi page excel file
 
I thought of doing that but I am constantly adding and sorting the data but
it looks like that what I may have to do. Thanks for much for your help.
betwms

"kosciosco" wrote:


If you make the header part of the body of the page rather than a header
in the page setup, then it will only appear on the first page.

Hope that helps

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=527609



Ron de Bruin

Get header only on first page of multi page excel file
 
If you print with a macro you can do it
http://www.rondebruin.nl/print.htm#Header

--
Regards Ron de Bruin
http://www.rondebruin.nl


"betwms" wrote in message ...
I have a 16 page excel file and I want the header only on the first page. Is
there any way that this can be done?





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

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