Inserting the same header/footer on all worksheets in a workbook

[ADP-Acctg]

I have a workbook with multiple worksheets that I would like to have the same
header/footer. Is there a way to insert the same one on each sheet without
have to go into page set up for each sheet individually?

 

[Ron de Bruin]

Hi ADP-Acctg

You can right click on a sheet tab and choose "Select all sheets"
Then change the header/footer

Right click again and choose "Ungroup sheets"

 

[PCLIVE]

Group the worksheets together. Click your first worksheet. Then while
holding Shift, click the last worksheet. The should all highlight in white
or other color that indicates the sheet is selected. Additionally, it will
show "Group" at the top next to the file name.
Then go to your header/footer settings.

HTH,
Paul

 

[Tom Hutchins]

Select all of the sheets at once. Click the first sheet tab, the hold down
the Shift button and click the last sheet tab. Then select File >> Page
setup. Add the desired heading & footing, and it will be applied to all the
selected sheets.

Hope this helps,

Hutch

 

[ADP-Acctg]

THANK YOU! I knew there had to be a way!

Hi ADP-Acctg

You can right click on a sheet tab and choose "Select all sheets"
Then change the header/footer

Right click again and choose "Ungroup sheets"

 

[ADP-Acctg]

Thank you so much! Exactly what I needed.

Select all of the sheets at once. Click the first sheet tab, the hold down
the Shift button and click the last sheet tab. Then select File >> Page
setup. Add the desired heading & footing, and it will be applied to all the
selected sheets.

Hope this helps,

Hutch

 

[ADP-Acctg]

Thanks! This is great!

Group the worksheets together. Click your first worksheet. Then while
holding Shift, click the last worksheet. The should all highlight in white
or other color that indicates the sheet is selected. Additionally, it will
show "Group" at the top next to the file name.
Then go to your header/footer settings.

HTH,
Paul

 

[Julien]

NICE WORK that just saved me a couple of days over the course of my lifetime.