Automatic Hyperlinks in Excel

  • Thread starter Thread starter Mike Frith
  • Start date Start date
M

Mike Frith

Hi,

Does anyone know if it's possible to turn OFF the automatic hyperlinks in
Excel?

Basically, the cell is holding UNC paths (\\SERVERNAME\PATH1\PATH2 etc). We
don't want these to be links, just text entries.

It's easy within word (just a check box under auto-correct in the options)
but I can't seem to find the option within Excel.

Can anyone help?

Regards,

Mike
 
It was added in xl2002, but if I start my data entry with an apostrophe ('),
xl2002 won't convert it to a hyperlink, either.

But I think I'd just let xl make them. And wipe them out later with a macro.
Select your range and run this:

Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub

(Ctrl-A is one way of selecting all the cells on the worksheet).
 
If it is just a few cells, right click on the cell and
click remove hyperlink.
RJH

-----Original Message-----
Hi,

Does anyone know if it's possible to turn OFF the automatic hyperlinks in
Excel?

Basically, the cell is holding UNC paths
Click to expand...
(\\SERVERNAME\PATH1\PATH2 etc). We
 
Just do this on one cell and you can then use Format Painter to copy its
format to the others.

Andy.
 
Deactivate several hyperlinks at once:

Type the number 1 in a blank cell, and right-click the cell.

Click Copy on the shortcut menu.

While pressing CTRL, select each hyperlink you want to deactivate.

(To select a cell that has a hyperlink in it without jumping to the
hyperlink destination, click the cell and hold the mouse button until
the cursor becomes a cross , then release the mouse button.)

Click Paste Special on the Edit menu.

Under Operation, click Multiply and then click OK.



 
Hi Doug,
I knew there was a non macro way (though the macro is faster for me)
I was thinking it was the format painter but it definitely is not.

But you want to select your empty cell, copy (ctrl+c) then
paste special, add

Using a 1 and multiply puts a zero into the empty cells.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
David

My method is to copy a blank cell and use Paste/Special/Add.

Andy.

David McRitchie said:
Hi Doug,
I knew there was a non macro way (though the macro is faster for me)
I was thinking it was the format painter but it definitely is not.

But you want to select your empty cell, copy (ctrl+c) then
paste special, add

Using a 1 and multiply puts a zero into the empty cells.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Deactivate several hyperlinks at once:

Type the number 1 in a blank cell, and right-click the cell.

Click Copy on the shortcut menu.

While pressing CTRL, select each hyperlink you want to deactivate.

(To select a cell that has a hyperlink in it without jumping to the
hyperlink destination, click the cell and hold the mouse button until
the cursor becomes a cross , then release the mouse button.)

Click Paste Special on the Edit menu.

Under Operation, click Multiply and then click OK.
Click to expand...
Click to expand...
 
Back
Top