| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customise the location of the header and footer of excel
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(<--------- ------------------------------------------------------------------------------------------------ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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(<--------- ------------------------------------------------------------------------------------------------ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customise the location of the header and footer of excel
No way except for padding with spaces as you are doing.
Gord Dibben MS Excel MVP On Thu, 1 Jun 2006 22:21:01 -0700, 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(<--------- ------------------------------------------------------------------------------------------------ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to put special character "&" in Excel Header / Footer ? | Excel Discussion (Misc queries) | |||
| Can I use a header or footer more than 255 characters in Excel? | Excel Discussion (Misc queries) | |||
| Can I use a header or footer more than 255 characters in Excel? | Excel Worksheet Functions | |||
| Header & Footer Excel 2003 | Excel Discussion (Misc queries) | |||
| How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Linear Mode
