ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format header/footer info? (https://www.excelbanter.com/excel-discussion-misc-queries/247071-format-header-footer-info.html)

L.S.

Format header/footer info?
 
Excel 2k.

When in Header and Footer I'd like to have text moved to the center of the
right section. It auto places anything I type to the right side of the box.
Actually, I'd like to be able to move text to different locations within the
3 sections.


thanks,



Dave Peterson

Format header/footer info?
 
That's the way excel works.

You may be able to pad with spaces (and then a dot/period) to force things to
the other side.

I usually try using the period to see how things look, then if that's ok, I'll
replace that dot (too noticeable) with the alt-0160 (HTML-nonbreaking space)
character.



"L.S." wrote:

Excel 2k.

When in Header and Footer I'd like to have text moved to the center of the
right section. It auto places anything I type to the right side of the box.
Actually, I'd like to be able to move text to different locations within the
3 sections.

thanks,


--

Dave Peterson

L.S.

Format header/footer info?
 
That worked great. THANKS


"Dave Peterson" wrote in message
...
That's the way excel works.

You may be able to pad with spaces (and then a dot/period) to force things
to
the other side.

I usually try using the period to see how things look, then if that's ok,
I'll
replace that dot (too noticeable) with the alt-0160 (HTML-nonbreaking
space)
character.



"L.S." wrote:

Excel 2k.

When in Header and Footer I'd like to have text moved to the center of
the
right section. It auto places anything I type to the right side of the
box.
Actually, I'd like to be able to move text to different locations within
the
3 sections.

thanks,


--

Dave Peterson





All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com