Putting internet link in Excel

  • Thread starter Thread starter Ken_B
  • Start date Start date
K

Ken_B

I can copy/paste a link from IE6 into Excel, it turns blue and sure looks
like a link, but I don't get the little hand when I run the cursor over it,
and nothing happens when I double-click.

When I click on Insert Hyperlink, I get a box that won't let me paste the
link, it will only let me type it in. I hate typing long links. Is there a
better way of putting a link in an Excel file?
 
Ken

Use a helper cell and enter....

=HYPERLINK(cellref) where cellref is the cell with the pasted link.

Gord Dibben Excel MVP
 
Back
Top