Customise the location of the header and footer of excel

G

Guest

Hi all,

i was wondering if it was possible to customise the location of the header
and footer in excel file.

What i would like to do is to shift the left and right footer location
inwards towards the middle of the page. I have tried the manual way of
spacing the words but there is a limit of 255 chars for the footer and
header.

Does anyone have a solution to this ?

Below is a rough illustration of what i am saying
 
G

Guest

You can set where you'd like the Header/Footer to appear by:
FILE > PAGE SETUP > HEADER/FOOTER then select either CUSTOM HEADER or CUSTOM
FOOTER. There are text boxes in there for where you'd like the Header/Footer
to appear - left, center, right.

Tom
 
G

Gord Dibben

No way except for padding with spaces as you are doing.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header and Footer 3
Copy of Header-Footer in Excel 3
Customise Header and Footer 1
Header and Footer margins 1
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
Protecting header and footer? 1
Footer limitation 3
Format header/footer info? 2

Top