I need to left justify the center and right sections of the print header in
excel. How can I do this without using spaces as padding. The header will
change number of characters for each use, so using spaces as padding poses
problems with running out of characters allowed in the header (255 character
limit).

As far as I know you don't have a choice.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"abohlin" <(E-Mail Removed)> wrote in message news:BB05F696-6958-466E-9247-(E-Mail Removed)...
> I need to left justify the center and right sections of the print header in
> excel. How can I do this without using spaces as padding. The header will
> change number of characters for each use, so using spaces as padding poses
> problems with running out of characters allowed in the header (255 character
> limit).

Then do you know if there is some kind of work around (VBA or otherwise to do
this?) This is a constant annoyance to me since I often need 3 columns at
the top of my printed pages showing all of my document data (all columns left
aligned). I have found the old fashioned "&L" switch but if you put that in
every header section they just write on top of each other. Can the
indentation possibly be adjusted with a similar switch?

Thanks,
abohlin

"David McRitchie" wrote:

> As far as I know you don't have a choice.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>
> "abohlin" <(E-Mail Removed)> wrote in message news:BB05F696-6958-466E-9247-(E-Mail Removed)...
> > I need to left justify the center and right sections of the print header in
> > excel. How can I do this without using spaces as padding. The header will
> > change number of characters for each use, so using spaces as padding poses
> > problems with running out of characters allowed in the header (255 character
> > limit).
>
>
>