Morning All,
I have an Excel 2010 work book with a number of worksheets in it. On one worksheet I've created a customer header and footer, which I'd
like to appear on all worksheets when they're printed. Ideally I'd like to be able to edit the one header and footer and have the same
thing appear across all worksheets.
Is there a way to do this and if so can anyone guide me through it please?
Thanks,
Nick
Thanks.
I may be missing something, but still can't make Excel apply the one header/footer to all worksheets when printed?
when you go to print, at the bottom there is page setup.
check the header and foot settings for 'different first page' - if checked, uncheck it.
EDIT
Apologies just re read and assume you mean you want to repeat it on sheets not pages - I dont think this is possible, however if you create the
header/title you want in the normal rows, you can use the 'sheet' tab in the page setup to repeat selected rows on every sheet.
EDIT 2
Nah cant get that to work now either = however once in normal rows you can use the '=Sheet1!' where sheet 1 is the name of the first sheet
and place the row/column references after the !
[Edited on 8-9-16 by loggyboy]
quote:
Originally posted by loggyboy
when you go to print, at the bottom there is page setup.
check the header and foot settings for 'different first page' - if checked, uncheck it.
EDIT
Apologies just re read and assume you mean you want to repeat it on sheets not pages - I dont think this is possible, however if you create the header/title you want in the normal rows, you can use the 'sheet' tab in the page setup to repeat selected rows on every sheet.
EDIT 2
Nah cant get that to work now either = however once in normal rows you can use the '=Sheet1!' where sheet 1 is the name of the first sheet and place the row/column references after the !
[Edited on 8-9-16 by loggyboy]
Have to say I'm stumped with this and somewhat pi55ed of with Excel TBH.
Surely what I want to do is a pretty basic task that most users would want to do. Unless I'm really missing something MS Excel simply can't
do it - beyond baffling it strikes me as a real shortcoming for MS
Ah ha...may have found a solution!
Copy and paste the first sheet with its header/footer and the header/footer appears (on screen and in print) on the newly created sheet. It seems to
work and be reliable, but I simply cannot believe it's necessary in 2016 in Excel to work like this.