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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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"
 
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
 
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
 
THANK YOU! I knew there had to be a way!

Ron de Bruin said:
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"
Click to expand...
 
Thank you so much! Exactly what I needed.

Tom Hutchins said:
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
Click to expand...
 
Thanks! This is great!

PCLIVE said:
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
Click to expand...
 
Back
Top