how do I paste links and keep formats

C

cole

when I copy using the paste links function I lose the format. How do I paste
links and keep the format?
 
R

RagDyeR

You've got to do it *twice*.

Paste Special - click "Links",
Right click again - Paste Special - click "Formats".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

when I copy using the paste links function I lose the format. How do I
paste
links and keep the format?
 
D

Dave Peterson

Just to add, if you change the "sending" cell's format, the "receiving" cell's
format won't change.
 
Top