| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you set a default header and footer for ALL worksheets? | Setting up and Configuration of Excel | |||
| Can you put the same header/footer on the entire workbook? | Excel Worksheet Functions | |||
| Need help inserting picture into header/footer | New Users to Excel | |||
| Is it possible to link the header/footer on a number of worksheets | Excel Discussion (Misc queries) | |||
| Allow header/footer to copy to other worksheets in 1 spreadsheet. | Excel Worksheet Functions | |||
Hybrid Mode
