Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header and Footer margins
Can the header/footer margins be set separately from the body of the worksheet?
Under page setup, the setting blocks for header and footer are for height or distance from the top and bottom of the sheet only, not width. Whenever I type something into the left block of the custom header it appears INDENTED out from the left margin set in page setup. I cannot get it to line up with the left margin. Do you have to 'fudge it' by offsetting the worksheet to the right by adding a blank column to the left of the first column in the worksheet? Regards - Lenny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header and Footer margins
Header/footer margins are fixed at left and right.
I find the easiest way around alignment is to pad headers/footers with spaces on left and right. Gord Dibben MS Excel MVP On Fri, 7 Aug 2009 14:55:01 -0700, Lenny wrote: Can the header/footer margins be set separately from the body of the worksheet? Under page setup, the setting blocks for header and footer are for height or distance from the top and bottom of the sheet only, not width. Whenever I type something into the left block of the custom header it appears INDENTED out from the left margin set in page setup. I cannot get it to line up with the left margin. Do you have to 'fudge it' by offsetting the worksheet to the right by adding a blank column to the left of the first column in the worksheet? Regards - Lenny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Margins - Footer/header | Excel Discussion (Misc queries) | |||
Header, Footer, Column Width, Margins | Excel Discussion (Misc queries) | |||
Header/Footer side margins | Excel Discussion (Misc queries) | |||
how to move header and footer within print margins excel | Excel Discussion (Misc queries) | |||
Left/Right Margins in Header/Footer | Excel Discussion (Misc queries) |