View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default How do I keep sections of the footer from overlapping?

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