Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 860
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Omit header from first page without embedding header in code ibvalentine Excel Worksheet Functions 6 August 28th 07 05:10 AM
Excel-Header-My Company Name won't work in Header (AT&T) & Time June K Excel Discussion (Misc queries) 2 April 10th 06 08:36 PM
change horizontal header position in excel pico Excel Discussion (Misc queries) 1 June 17th 05 03:26 AM
Excel - turn a page number in a header from horizontal to vertical pbrookstx Charts and Charting in Excel 1 June 4th 05 01:01 AM
how do I permanetly add custom header to excel header list? GARY Excel Discussion (Misc queries) 1 December 15th 04 08:52 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"