expanding the side margins in excel does not expand header

J

John Staerck

When I move the left and right margins in an Excel document the header and
footer width does not change. If I try the same thing in Word the header &
footer widths match the page left & right margins. Any advice is greatly
appreciated.

I am using Office 2002 SP3 under Windows XP.
 
J

JE McGimpsey

You could paste/paste link the XL sheet into Word, where you can set the
headers, or you can use spaces to pad the header/footer. Otherwise you
can't adjust the header/footer width independently of the worksheet.
 
Top