Header and Footer margins

L

Lenny

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Changing margins on 2nd page of letterhead template 4
How to save a PDF with header that extends to edge of page? 3
Loop through pages and insert header image 0
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Header and Footer 3
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
Set as Default Template not working 0

Top