| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Header/Footer to Retain Formatting
How can I copy and then paste headers and footers from one sheet to another
and retain the formatting from the source sheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Header/Footer to Retain Formatting
Right click on the tab at the bottom of the sheet. Choose Move or Copy, put
a checkmark in create a copy, if you want the copy to be the last sheet, highlight (move to end) and click OK - you now have a copy, header, footer, formulas, formatting of the sheet. "Jill E. Lingle" wrote: How can I copy and then paste headers and footers from one sheet to another and retain the formatting from the source sheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Header/Footer to Retain Formatting
Thanks so much! You don't know how many people I've asked about this and how
many times I've searched "HELP". I knew there had to be a simple, logical way to accomplish this. You have saved me SO MUCH time! Thanks again! "MrReeLady" wrote: Right click on the tab at the bottom of the sheet. Choose Move or Copy, put a checkmark in create a copy, if you want the copy to be the last sheet, highlight (move to end) and click OK - you now have a copy, header, footer, formulas, formatting of the sheet. "Jill E. Lingle" wrote: How can I copy and then paste headers and footers from one sheet to another and retain the formatting from the source sheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Header/Footer to Retain Formatting
I actually asked this question about two weeks ago on this board. Someone
else bailed me out of the same situation (so much work to recreate!) I, just like you, knew there had to be a simple way to fix it.... nice to return the favour and help someone else out! "Jill E. Lingle" wrote: Thanks so much! You don't know how many people I've asked about this and how many times I've searched "HELP". I knew there had to be a simple, logical way to accomplish this. You have saved me SO MUCH time! Thanks again! "MrReeLady" wrote: Right click on the tab at the bottom of the sheet. Choose Move or Copy, put a checkmark in create a copy, if you want the copy to be the last sheet, highlight (move to end) and click OK - you now have a copy, header, footer, formulas, formatting of the sheet. "Jill E. Lingle" wrote: How can I copy and then paste headers and footers from one sheet to another and retain the formatting from the source sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a header and footer to multiple worksheets? | Setting up and Configuration of Excel | |||
| Allow header/footer to copy to other worksheets in 1 spreadsheet. | Excel Worksheet Functions | |||
| Is it possible to copy a header/footer from one worksheet to anoth | Excel Discussion (Misc queries) | |||
| Formatting Date in Header & Footer | Excel Discussion (Misc queries) | |||
| How do I copy and paste Excel charts and retain formatting? Mine . | Charts and Charting in Excel | |||
Linear Mode
