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
|