Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I Left justify the center section of the print header?
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I Left justify the center section of the print header?
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" wrote in message ... 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). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I Left justify the center section of the print header?
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" wrote in message ... 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right/Left Justify within a cell | Excel Discussion (Misc queries) | |||
How do I left justify center section header | Excel Discussion (Misc queries) | |||
Change justification in right Excel header box to left justify. | Excel Discussion (Misc queries) | |||
left justify a legend | Charts and Charting in Excel | |||
Left Justify Cell | Excel Programming |