Positioning Headers and Footers

by Allen Wyatt
(last updated October 11, 2014)

8

Besides allowing you to control what appears in a header or footer, Excel allows you to also control the distance at which they appear relative to the top or bottom of the paper on which you print your spreadsheet. To position the header or footer, follow these steps:

  1. Select Page Setup from the File menu. This displays the Page Setup dialog box.
  2. Make sure the Margins tab is selected. (See Figure 1.)
  3. Figure 1. The Margins tab of the Page Setup dialog box.

  4. Use the Header and Footer controls to specify the distance from the edge of the paper at which the header or footer should appear.
  5. Click on OK.

Make sure that when you specify a position for the header or footer that the value is smaller than what you have set for top or bottom margins. If the Header or Footer values are larger than the margins, your header or footer could overlap with data printed on the page.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2636) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Capitalizing the Word "I"

The first-person, singular pronoun "I" should always be capitalized, unless you are exercising poetic license. Word may not ...

Discover More

Problem Printing Quotation Marks

If you go to print a document and find out that your quotation marks aren't printing properly, there could be a number of ...

Discover More

Turning Off Automatic Captioning

Word can be configured so that it automatically adds captions to some of your design elements (tables, figures, etc.). Once ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Creating a Header

When preparing your worksheet for printing, you may want to add a header that appears at the top of each page that you print. ...

Discover More

Creating Long Page Footers

Ever wish that you could create nice, long footers that appear at the bottom of each page when you print your worksheet? ...

Discover More

Putting a Different Date in a Header

Today's date is easy to add to a header, but what if you want to add a date that is adjusted in some manner? Adding ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 + 8?

2016-11-18 05:19:33

Col Delane

@ Jim
As I tried to explain in my previous post, the only alignment available is relative to the page via the three sections - there is [currently] no built-in way to do what you are seeking within each section as the functionality does not exist.


2016-11-17 08:51:04

Jim

Please publish the way to change the justification within the three header sections. I want to be able to enter text at a point other than the left margin in the left section, the center in the center section and the right margin in the right section.


2016-11-16 05:51:37

Col Delane

@ Jim
The alignment is of the header/footer sections relative to the page rather than of the contents within each header/footer sections, so without such fancy formatting things as Tab stops, lots of spaces is about all you can use :-(.


2016-11-15 09:15:26

Jim

How can I cause text in EACH OF THE 3 header sections to be left-aligned, centered or right-aligned independently? I don't necessarily want it left-aligned in the left section, centered in the middle section or right-aligned in the right section.


2016-05-09 08:02:23

Rick Powell

Thank you Col Delane.
Actually I went with a 2 line footer, putting the Tab name and Date on the topmost line and the File and Page n of n on the second line. The File name is just way too long, in my case.

I did find some other useful header/footer formatting codes here, which I pass along for those stumbling across this thread:

https://msdn.microsoft.com/en-us/library/office/ff822794.aspx?f=255&MSPPError=-2147217396

Thanks again to everyone. I am sure I will be visiting Allen Wyatt's site more often in the future.
Rick


2016-05-09 00:06:23

Col Delane

@Rick
The best way to overcome your problem is to append the tab name to the filename within the left footer, viz;
&[Path]&[File] - &[Tab]

(Remove &[Path] if you only want filename & tab name)

I think the reason that &[Tab] followed by a Carriage Return causes the sheet name to appear 1 line above the rest of the footer info is that the footer margin determines where a last/bottom line of footer will print, so any additional lines in the footer must (by definition) push further into the print area. It's a little counter-intuitive: so if a long left footer (e.g. path-filename-tab) overlaps the centre footer (e.g. Page n of n), you need a carriage return AFTER the field codes of the chosen footer to push that footer above the other.


2016-04-20 11:01:34

Rick Powell

I am using Excel 2010.
Is there a way to control horizontal alignment of each of the 3 sections (left, center, right) when you use the Header/Footer tab of the Page Setup dialog box - after clicking the Custom Footer... button?

For instance, I want to heve the Left section contain &[File] (which is by default left-aligned), and the Right section to contain &[Page] (which is by default right-aligned), and the Center section always appears to be center-aligned. I would like to have &[Tab] in the Center section, but right-align it.

The real problem I am trying to solve is with a LONG Filename that extends very far into the Center section of the footer. The best solution I have come up with so far is to define the Center section to contain: &[Tab] followed by a Carriage Return, which causes the actual sheet name to appear 1 line above the rest of the footer info.

Many thanks for all the awesome stuff you have on your website!
Rick


2015-04-28 04:27:48

JurgenG

Hi,

so I understand it correctly that it's impossible to have a full-page watermark on the page?

Currently, the best I can achieve is to have it span top to bottom (header and footer margins to 0), but can't get it to align to the left page border.


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share