| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Carrying formatting automatically to new W/S
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"
<html When I copy a workbook I want to be able to maintain the formatting and layout. <pWhenever I have done this, the new worksheet always loses the formatting from the original. For example the original has some <bemboldened</b text, but on the copied sheet the emboldening has been lost. <pJonah</html |
|
#2
|
|||
|
|||
|
Right click on the sheet tab(s),
Select "Move or Copy", Click on "Create a Copy", Expand the "To Book" box and click on "New Book", Then <OK. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jonah" wrote in message ... When I copy a workbook I want to be able to maintain the formatting and layout. Whenever I have done this, the new worksheet always loses the formatting from the original. For example the original has some emboldened text, but on the copied sheet the emboldening has been lost. Jonah |
|
#3
|
|||
|
|||
|
Sorry about this, but it is not a new W/B but a new worksheet I needed. I also
tried what you said and I still get no formatting carried over. J Ragdyer wrote: Right click on the sheet tab(s), Select "Move or Copy", Click on "Create a Copy", Expand the "To Book" box and click on "New Book", Then <OK. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jonah" wrote in message ... When I copy a workbook I want to be able to maintain the formatting and layout. Whenever I have done this, the new worksheet always loses the formatting from the original. For example the original has some emboldened text, but on the copied sheet the emboldening has been lost. Jonah |
|
#4
|
|||
|
|||
|
Might there be some underlying code in the sheet?
This procedure copies a sheet *exactly*, whether the original is protected or not, whether it's saved or not ... it just works! Describe exactly what you did, and where you did it. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jonah" wrote in message ... Sorry about this, but it is not a new W/B but a new worksheet I needed. I also tried what you said and I still get no formatting carried over. J Ragdyer wrote: Right click on the sheet tab(s), Select "Move or Copy", Click on "Create a Copy", Expand the "To Book" box and click on "New Book", Then <OK. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Jonah" wrote in message ... When I copy a workbook I want to be able to maintain the formatting and layout. Whenever I have done this, the new worksheet always loses the formatting from the original. For example the original has some emboldened text, but on the copied sheet the emboldening has been lost. Jonah |
|
#5
|
|||
|
|||
|
Underlying code? Where do I look?
Jonah ------------- Ragdyer wrote: Might there be some underlying code in the sheet? This procedure copies a sheet *exactly*, whether the original is protected or not, whether it's saved or not ... it just works! Describe exactly what you did, and where you did it. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jonah" wrote in message ... Sorry about this, but it is not a new W/B but a new worksheet I needed. I also tried what you said and I still get no formatting carried over. J Ragdyer wrote: Right click on the sheet tab(s), Select "Move or Copy", Click on "Create a Copy", Expand the "To Book" box and click on "New Book", Then <OK. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Jonah" wrote in message ... When I copy a workbook I want to be able to maintain the formatting and layout. Whenever I have done this, the new worksheet always loses the formatting from the original. For example the original has some emboldened text, but on the copied sheet the emboldening has been lost. Jonah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically match destination formatting? | Excel Discussion (Misc queries) | |||
| Find and replace - problem with automatically changing formatting | Excel Discussion (Misc queries) | |||
| Excel automatically changes the formatting of the cell to "Time" | Excel Discussion (Misc queries) | |||
| Carrying over font formatting | Excel Discussion (Misc queries) | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
