#1   Report Post  
Posted to microsoft.public.excel.misc
mato nanjin
 
Posts: n/a
Default Border around header

How can I put a border around the header when it prints? Any help would be
appreciated.


  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary
 
Posts: n/a
Default Border around header

Not sure how to do it to a header, but as an alternative, you could place
your header information in the first few rows and format it as you need it.

Then, from the sheet tab on File-Page Setup, choose those rows in the 'Rows
to repeat at top' box.

hth

Gary

"mato nanjin" wrote:

How can I put a border around the header when it prints? Any help would be
appreciated.


  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Border around header

If you're using xl2002 or higher, you could create a picture (nothing but
borders) and insert that picture in the header.

mato nanjin wrote:

How can I put a border around the header when it prints? Any help would be
appreciated.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you put a border in a header Rebecca Excel Discussion (Misc queries) 0 December 1st 05 03:59 PM
How do I setup a header in Excel that prints only on first page? mikesam7 Excel Discussion (Misc queries) 3 August 24th 05 08:16 PM
Changing Border Thickness Throughout Document Doug Excel Discussion (Misc queries) 4 August 1st 05 07:22 PM
Border misaligned Carole Drake New Users to Excel 0 April 23rd 05 01:29 AM
Default header in Excel under page set-up Melanie Excel Discussion (Misc queries) 2 December 15th 04 01:37 AM


All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"