Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to copy headers/footers between worksheets
Can I copy headers/footers between worksheets in a workbook without copying
the entire sheet? |
#2
|
|||
|
|||
Hi Bruce
Select all your sheets first (right click in a a sheet tab "select all sheets" Add your header and footer Ungroup the sheets(right click in a a sheet tab "ungroup sheets" -- Regards Ron de Bruin http://www.rondebruin.nl "BruceD" wrote in message ... Can I copy headers/footers between worksheets in a workbook without copying the entire sheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy headers/footers between worksheets
Thank you so much!!! I had over 60 worksheets that I needed to add the same
footer to and everyone was telling me it can't happen and that I'll need to do it on each individual one. Thank you so much for this quick and easy fix. "Ron de Bruin" wrote: Hi Bruce Select all your sheets first (right click in a a sheet tab "select all sheets" Add your header and footer Ungroup the sheets(right click in a a sheet tab "ungroup sheets" -- Regards Ron de Bruin http://www.rondebruin.nl "BruceD" wrote in message ... Can I copy headers/footers between worksheets in a workbook without copying the entire sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy headers/footers across worksheets | Excel Discussion (Misc queries) | |||
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) |