Hi there,

when you do a "normal" copy - paste (Strg+C then Strg+V) you copy
everything: content, formula, format.

Good luck
Udo

prakash schrieb:

Hi,
When we do "paste special" -"Paste link",only the content gets copied and
the format of the source cell is not copied. Is there a way to automatically
copy the format along with the contents.
I want to do "paste link" and also "paste format" in one shot.

I do not want to use paste special -format option each time as there are
close to 40 to 50 links which I have to copy. Also the format in the source
files keeps on changing.

Thanks in advance

Prakash