When I create forms and other standard documents for my company, the footer
is supposed to look as follows:

Center Aligned €“ Firm Address & Phone Number
Left Aligned €“ Page Number
Right Aligned €“ File Path

When I create forms in Word, it is easy to fit all three in the footer: I
simply put the Firm Address & Phone Number on the line above the Page Number
and the File Path. Unfortunately, Excel puts them all three on the same line,
and they overlap. Is there any way I can work around this?

Hit enter at the end of the address and phone number. It will add a blank
line to that section, effectively lifting the longer line above the page
number and file path.

"LTjapkes" wrote:

When I create forms and other standard documents for my company, the footer
is supposed to look as follows:

Center Aligned €“ Firm Address & Phone Number
Left Aligned €“ Page Number
Right Aligned €“ File Path

When I create forms in Word, it is easy to fit all three in the footer: I
simply put the Firm Address & Phone Number on the line above the Page Number
and the File Path. Unfortunately, Excel puts them all three on the same line,
and they overlap. Is there any way I can work around this?

I tried that, but it didn't work. When I print it, all of the footer sections
are still on the same line.

"BoniM" wrote:

Hit enter at the end of the address and phone number. It will add a blank
line to that section, effectively lifting the longer line above the page
number and file path.

"LTjapkes" wrote:

When I create forms and other standard documents for my company, the footer
is supposed to look as follows:

Center Aligned €“ Firm Address & Phone Number
Left Aligned €“ Page Number
Right Aligned €“ File Path

When I create forms in Word, it is easy to fit all three in the footer: I
simply put the Firm Address & Phone Number on the line above the Page Number
and the File Path. Unfortunately, Excel puts them all three on the same line,
and they overlap. Is there any way I can work around this?

It's hard to tell, since they all show up on the same line in the dialog box
- but click at the end of the other two sections and hit delete a few times
to make sure there aren't any hard returns at the end of those sections...

"LTjapkes" wrote:

I tried that, but it didn't work. When I print it, all of the footer sections
are still on the same line.

"BoniM" wrote:

Hit enter at the end of the address and phone number. It will add a blank
line to that section, effectively lifting the longer line above the page
number and file path.

"LTjapkes" wrote:

When I create forms and other standard documents for my company, the footer
is supposed to look as follows:

Center Aligned €“ Firm Address & Phone Number
Left Aligned €“ Page Number
Right Aligned €“ File Path

When I create forms in Word, it is easy to fit all three in the footer: I
simply put the Firm Address & Phone Number on the line above the Page Number
and the File Path. Unfortunately, Excel puts them all three on the same line,
and they overlap. Is there any way I can work around this?

In the Left footer, press the Enter key twice, and type on the third row
In the Center footer, press the Enter key once, type the text, then
press the Enter key
In the Right footer, type the text, then press the Enter key twice.

With the same number of lines in each section, they should print where
you want them.

LTjapkes wrote:
I tried that, but it didn't work. When I print it, all of the footer sections
are still on the same line.

"BoniM" wrote:


Hit enter at the end of the address and phone number. It will add a blank
line to that section, effectively lifting the longer line above the page
number and file path.

"LTjapkes" wrote:


When I create forms and other standard documents for my company, the footer
is supposed to look as follows:

Center Aligned €“ Firm Address & Phone Number
Left Aligned €“ Page Number
Right Aligned €“ File Path

When I create forms in Word, it is easy to fit all three in the footer: I
simply put the Firm Address & Phone Number on the line above the Page Number
and the File Path. Unfortunately, Excel puts them all three on the same line,
and they overlap. Is there any way I can work around this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html