How do I move a link from 1 cell to another …
Without having to copy link address -
copy limk address from cell #1
create new hyperlink in cell #2,
copy link address into new link,
then typing in the text?
The link I have is correct, just in the wrong cell!
TNX, ⌡im
Tried copy and paste — not working
Do you paste inside Formula bar, or inside a cell in edit mode, or without entering the edit mode? The result would be different.
Copy and paste does not move. Cut and paste does.
Only the TEXT of the hyperlink is moved not the link ?
I have absolutely no idea what the content of your cell is because you don’t tell us. I thought of a reference such as =A1 which becomes =A5 when copied down 4 rows but remains =A1 when you move it. Now I read “hyperlink”. If the hyperlink is generated by the HYPERLINK function with relative references, the same rule holds. If the hyperlink is a grey hyperlink field, it makes no difference if you move or copy.
Did you try moving the cell? No? Why not?
The attached file contains a hyperlink from cell A1 to cell C1. When you copy cell A1, the hyperlink is preserved.
CellLink.ods (9.3 KB)
Link is to an outside URL, TEXT is “Ctr-Click”.
I did this by clicking on the Globe icon on the tool bar.
Tried CUT, but again only the TEXT of the link is copied to the new cell.
Working on a copy to send …
⌡im
You can either:
In your example, you can copy cell B2 to C2 in the usual way (select B2, Ctrl+Ins, select C2, Shift+Ins).
Maybe we’re missing something?
That is what I was missing …
TNX, ⌡im