B Brachy Sep 1, 2009 #1 Is it possible to copy Header and Footer data across all sheets in a multi-page Workbook. If not, why not?
Is it possible to copy Header and Footer data across all sheets in a multi-page Workbook. If not, why not?
J Jacob Skaria Sep 1, 2009 #2 You can. Right click the sheet tab>Select all sheets> and then set header and footer which will be applied for all sheets If this post helps click Yes
You can. Right click the sheet tab>Select all sheets> and then set header and footer which will be applied for all sheets If this post helps click Yes
G Gord Dibben Sep 1, 2009 #3 Be careful with this. It will also change most print settings on all sheets to that of the activesheet. Gord Dibben MS Excel MVP
Be careful with this. It will also change most print settings on all sheets to that of the activesheet. Gord Dibben MS Excel MVP
