Hyperlinks not active

  • Thread starter Thread starter Mr Crowley
  • Start date Start date
M

Mr Crowley

I have a 2007 worksheet where I have a column of about 250 hyperlinks. Non
of them show up as hyperlinks. When I move my mouse over them they dont do
anything. Is there a way I can make these cells which are valid web
addresses, a working hyperlink??


Thanks

CARD
 
With your "dead" hyperlinks in column A, in B1 enter:

=HYPERLINK(A1) and copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to create a link to a link in Excel (2007) 3
How to prevent email addresses from becoming hyperlinks, and removinghyperlink 1
Problem with successive Hyperlinking in Excel 2010 5
Excel Macro to hyperlink an archived worksheet to an index page 0
Hyperlink shortcut not appearing 1
Hyperlink target after sort? 3
Embed Hyperlinks 4
Sort cells and "Place in this document"-hyperlinks 1

Back
Top