ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Header horizontal position (https://www.excelbanter.com/excel-discussion-misc-queries/158687-header-horizontal-position.html)

Johan

Header horizontal position
 
If I change my page margin set-up settings by making the left margin larger,
the header position stays at a certain default offset. How do I change the
header left (and right for that matter) margins to be aligned with the page
margins?

Jim Rech

Header horizontal position
 
The option of aligning header margins with page margins was added in Excel
2007. It cannot be done in earlier versions as far as I know.

--
Jim
"Johan" wrote in message
...
| If I change my page margin set-up settings by making the left margin
larger,
| the header position stays at a certain default offset. How do I change
the
| header left (and right for that matter) margins to be aligned with the
page
| margins?



MartinW

Header horizontal position
 
Hi Johan,

I have problems with that too.
I go to Print Preview click on Setup and add spaces where required
to achieve the right look.

It works, but it's not pretty!

Also I use 2000 so maybe it is better in later versions.

HTH
Martin


"Johan" wrote in message
...
If I change my page margin set-up settings by making the left margin
larger,
the header position stays at a certain default offset. How do I change
the
header left (and right for that matter) margins to be aligned with the
page
margins?





All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com