Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formatting (headers, margins, etc) to another sheet?
Is it possible to copy formatting (headers, margins, etc) from one sheet to
another? I need to add sheets to a workbook that are set up just like an existing sheet. I can copy my "model sheet" and get the fonts, formats, formulas, etc, but then have been individually modifying the page setup for each new sheet. Is there a way to save the page setup info and apply it to the new sheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formatting (headers, margins, etc) to another sheet?
Are you right clicking on the worksheet tab and copying that way?
"MQS" wrote: Is it possible to copy formatting (headers, margins, etc) from one sheet to another? I need to add sheets to a workbook that are set up just like an existing sheet. I can copy my "model sheet" and get the fonts, formats, formulas, etc, but then have been individually modifying the page setup for each new sheet. Is there a way to save the page setup info and apply it to the new sheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formatting (headers, margins, etc) to another sheet?
No, I didn't know that trick! Thanks, that's exactly what I was looking for!
I knew there had to be some way to do it, but couldn't find that tidbit in the help file. "Barb Reinhardt" wrote: Are you right clicking on the worksheet tab and copying that way? "MQS" wrote: Is it possible to copy formatting (headers, margins, etc) from one sheet to another? I need to add sheets to a workbook that are set up just like an existing sheet. I can copy my "model sheet" and get the fonts, formats, formulas, etc, but then have been individually modifying the page setup for each new sheet. Is there a way to save the page setup info and apply it to the new sheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formatting (headers, margins, etc) to another sheet?
Right clicking on the tab works great if you want to copy the worksheet as
well as the page setup, but I only want to copy the page setup. There are errors on the page itself so I don't want to copy that. Is there a way to copy just the page setup? Thanks........... "Barb Reinhardt" wrote: Are you right clicking on the worksheet tab and copying that way? "MQS" wrote: Is it possible to copy formatting (headers, margins, etc) from one sheet to another? I need to add sheets to a workbook that are set up just like an existing sheet. I can copy my "model sheet" and get the fonts, formats, formulas, etc, but then have been individually modifying the page setup for each new sheet. Is there a way to save the page setup info and apply it to the new sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set margins for headers in excel | Excel Discussion (Misc queries) | |||
Headers and margins | Excel Discussion (Misc queries) | |||
How can I set margins for headers on charts. The margin option ap. | Charts and Charting in Excel | |||
How do I copy an excel sheet with headers? | Excel Worksheet Functions | |||
How do I copy an excel sheet with headers? | Excel Worksheet Functions |