Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've created an Excel spreadsheet with a header. The spreadsheet prints on 5
pages. I want the header to print on pg 1 but not pgs 2-5. Is this possible? Currently the header is a custom header and prints on every page. I'd prefer fot he header to print on pg 1 only..... |
#2
![]() |
|||
|
|||
![]() You'll probably need to remove the header info from the header, and insert one (or however many you need) rows above the top of your "page 1 content", and put the header info there. Decrease the top margin of the page accordingly. This should do it for you. I know of no "simple" way to print something in the header fields only on the first page in Excel. Later, -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=398643 |
#3
![]() |
|||
|
|||
![]()
Hi Mike
You can do this only with a macro, see http://www.rondebruin.nl/print.htm#Header -- Regards Ron de Bruin http://www.rondebruin.nl "mikesam7" wrote in message ... I've created an Excel spreadsheet with a header. The spreadsheet prints on 5 pages. I want the header to print on pg 1 but not pgs 2-5. Is this possible? Currently the header is a custom header and prints on every page. I'd prefer fot he header to print on pg 1 only..... |
#4
![]() |
|||
|
|||
![]() Very nice, Ron de Bruin! -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=398643 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Slow after print setup?? | Excel Discussion (Misc queries) | |||
How do I change the Header area's width in Excel? | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Add images or logos to the Header in Ms- Excel Sheets | Excel Worksheet Functions |