Help with Linking cells and formatting not copying across!

[salsarai]

I am linking cells together across different worksheets. I am having a problem with the formatting not coming across. Two examples:

1. In the source cell, I have bolding and regular font within the same cell. When it links across to the new cell, the whole cell comes across as bolded.

2. I have a product name with a ® behind it in the source cell. The ® is in a smaller font than the product name and as superscript. When I link that cell across, the formatting is gone and reverts to the formatting of the product name only.

I can usually figure things out but I am definitely stumped on this one. Any help would be so greatly appreciated!!!

-Sarai

 

[XLGibbs]

YOu may have to copy/paste formats to make sure the format for the whole cell holds. The linking of the cell usually brings in the value and not the format...

 

[RalphA]

Even worse! I tried it on the same sheet, and the format did not carry across to the Pasted cell. However...

Using Excel 2002, when I did a Ctrl+x (Cut), I got the option to click on an object in the Clipboad, with the additional option of using either the original cell's formatting of the new cell's formatting. Using the first, one can Paste as many times as desired, and the format carries across. Could this, perhaps, point to a method to do what you need?