ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I paste links and keep formats (https://www.excelbanter.com/excel-discussion-misc-queries/64482-how-do-i-paste-links-keep-formats.html)

cole

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

RagDyeR

how do I paste links and keep formats
 
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" wrote in message
...
when I copy using the paste links function I lose the format. How do I
paste
links and keep the format?



Dave Peterson

how do I paste links and keep formats
 
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" wrote in message
...
when I copy using the paste links function I lose the format. How do I
paste
links and keep the format?


--

Dave Peterson


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com