Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to copy headers/footers across worksheets
Can I copy headers and footers from one worksheet to another in a workbook
without copying the entire sheet? |
#2
|
|||
|
|||
Bruce
Select the sheet with the header/footer you wnat. Right-click and "Select all sheets". FilePage SetupHeaders/Footers and OK your way out. All sheets will have that setup. DO NOT FORGET to ungroup the sheets after you're done. What is being done to one will be done to all. Could make for some interesting changes<g Gord Dibben Excel MVP On Tue, 11 Jan 2005 13:19:05 -0800, BruceD wrote: Can I copy headers and footers from one worksheet to another in a workbook without copying the entire sheet? |
#3
|
|||
|
|||
See your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl "BruceD" wrote in message ... Can I copy headers and footers from one worksheet to another in a workbook without copying the entire sheet? |
#4
|
|||
|
|||
How to copy headers/footers across worksheets
Gord
You've just saved me from throwing the PC out the window. I can't understand why this, clearly useful, feature can't be found in the Excel Help facility. maybe I should have guessed that 'grouping' was the key. Ah well 1,000 thanks. -- JohnG, UK "Gord Dibben" wrote: Bruce Select the sheet with the header/footer you wnat. Right-click and "Select all sheets". FilePage SetupHeaders/Footers and OK your way out. All sheets will have that setup. DO NOT FORGET to ungroup the sheets after you're done. What is being done to one will be done to all. Could make for some interesting changes<g Gord Dibben Excel MVP On Tue, 11 Jan 2005 13:19:05 -0800, BruceD wrote: Can I copy headers and footers from one worksheet to another in a workbook without copying the entire sheet? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy headers/footers across worksheets
Gord - THANK YOU so very much! That works slick as a whistle!
"Gord Dibben" wrote: Bruce Select the sheet with the header/footer you wnat. Right-click and "Select all sheets". FilePage SetupHeaders/Footers and OK your way out. All sheets will have that setup. DO NOT FORGET to ungroup the sheets after you're done. What is being done to one will be done to all. Could make for some interesting changes<g Gord Dibben Excel MVP On Tue, 11 Jan 2005 13:19:05 -0800, BruceD wrote: Can I copy headers and footers from one worksheet to another in a workbook without copying the entire sheet? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy headers/footers across worksheets
I tried following these steps but it didn't work! I selected the sheet with
the header/footer I wanted, then fI right-clicked "select all sheets", then I did the page setup, headers and footers. But when I went to the other sheets there was nothing there. Please help me! Laura "dinocm" wrote: Gord - THANK YOU so very much! That works slick as a whistle! "Gord Dibben" wrote: Bruce Select the sheet with the header/footer you wnat. Right-click and "Select all sheets". FilePage SetupHeaders/Footers and OK your way out. All sheets will have that setup. DO NOT FORGET to ungroup the sheets after you're done. What is being done to one will be done to all. Could make for some interesting changes<g Gord Dibben Excel MVP On Tue, 11 Jan 2005 13:19:05 -0800, BruceD wrote: Can I copy headers and footers from one worksheet to another in a workbook without copying the entire sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
How can I copy page setup settings to other worksheets? Thanks | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Copy Excel worksheets | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |