View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter Karlström Peter Karlström is offline
external usenet poster
 
Posts: 13
Default Controling alignment in header

Hi Bill

Yes, I want them left aligned respectivelyunder each part.
B but if I use the Left align code (&L) in any of the Center or
Right-headers, it all ends upp on row 1 in the left most corner
of the header, over the logotype.

Sorry about the Print Tile suggestion, but I have to leave the contents
of the spreadsheet out of this. (Customers orders....)

I'll look around on the MVP-site, to see if they have any hints.

Regards

--
Peter Karlström
Midrange AB
Sweden


"Bill Renaud" wrote:

So you want "Author: Peter" centered under "Subject: Subjectdata" and
"Time: 10:45:12" centered under "Date: 2007-11-20 Page 1/2"?
Or should they be left-aligned under each part?

I'll have to experiment with Excel some (unfortunately I still use Excel
2000, so may not be able to correctly answer this question). Maybe an MVP
has something on their web site somewhere.

As a work-around, you might have to set all of the Headers to nothing, set
the Top Margin to the Header Margin (say 0.75"), then enter this
information on rows 1 and 2 of your worksheet, start your worksheet data on
row 4 (leave row 3 blank), then declare rows 1 through 4 as Print Titles.

--
Regards,
Bill Renaud