Special-Pasting a hyperlink in Excel

Is there a way to use the Paste Special command to paste a hyperlink from one cell in Excel 2010 to another cell?

I am asking specifically about the Paste Special command, not the Paste Link or Create Hyperlink commands.

2

2 Answers

Yes. First copy the cell then select another cell, use Paste Special and click OK.

No, I don't think there's a way directly. But there's a workaround. If I'm understanding correctly, you want to copy and paste hyperlinks from one column to another without overwriting the values in the destination column. You just want to bring over the hyperlinks. If that's the case, then continue reading. If not, you can stop here.

First, copy the values in the destination column and paste special values them to the cells with the hyperlinks. That should essentially create the column that you want. You just have to do a regular cut/copy and paste to where you need it. If you need to preserve the original hyperlink column, duplicate it before pasting anything into it.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy