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

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?

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

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"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ADP-Acctg" wrote in message ...
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?

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

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

"ADP-Acctg" wrote in message
...
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?

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

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" wrote:

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?

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

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

"Ron de Bruin" wrote:

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"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ADP-Acctg" wrote in message ...
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?

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

Thank you so much! Exactly what I needed.

"Tom Hutchins" wrote:

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" wrote:

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?

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

Thanks! This is great!

"PCLIVE" wrote:

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

"ADP-Acctg" wrote in message
...
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?

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

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

"ADP-Acctg" wrote:

Thanks! This is great!

"PCLIVE" wrote:

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

"ADP-Acctg" wrote in message
...
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?