how do I paste links and keep formats

[cole]

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

[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!
=====================================================

"cole" <cole@discussions.microsoft.com> wrote in message
news:BCCA73D3-C39F-4E58-B36D-A0E9F5871AD1@microsoft.com...
when I copy using the paste links function I lose the format. How do I
paste
links and keep the format?

[Dave Peterson]

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

RagDyeR wrote:
>
> 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!
> =====================================================
>
> "cole" <cole@discussions.microsoft.com> wrote in message
> news:BCCA73D3-C39F-4E58-B36D-A0E9F5871AD1@microsoft.com...
> when I copy using the paste links function I lose the format. How do I
> paste
> links and keep the format?

--

Dave Peterson