View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom
 
Posts: n/a
Default Customise the location of the header and footer of excel

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

"Zancouth" wrote:

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

------------------------------------------------------------------------------------------------
inwards- )footer
footer2(<---------
------------------------------------------------------------------------------------------------