Automatic Hyperlinks in Excel

Mike Frith

unread,

Sep 9, 2003, 9:01:46 AM9/9/03

to

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

Dave Peterson

unread,

Sep 9, 2003, 7:21:16 PM9/9/03

to

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).

--

Dave Peterson
ec3...@msn.com

J.E. McGimpsey

unread,

Sep 9, 2003, 7:29:14 PM9/9/03

to

I've posted a way using an event handler to eliminate hyperlinks in
real-time at

http://www.mcgimpsey.com/excel/nohyperlinks2.html

It refers to MacXL, but should translate fine to windows.

In article <3F5E606C...@msn.com>,

Mike Frith

unread,

Sep 10, 2003, 7:41:19 AM9/10/03

to

Thanks for the help guys, I'll try them both out.

"Mike Frith" <frit...@leicester.gov.uk> wrote in message
news:e9upIKtd...@TK2MSFTNGP10.phx.gbl...

RJH

unread,

Sep 10, 2003, 2:41:17 PM9/10/03

to

If it is just a few cells, right click on the cell and
click remove hyperlink.
RJH

>.
>

Andy B

unread,

Sep 12, 2003, 12:27:00 PM9/12/03

to

Just do this on one cell and you can then use Format Painter to copy its
format to the others.

Andy.

"RJH" <rjha...@csu.org> wrote in message
news:0d1d01c377cb$1ea25f50$a601...@phx.gbl...

Doug

unread,

Sep 15, 2003, 9:13:52 PM9/15/03

to

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.

David McRitchie

unread,

Sep 17, 2003, 7:08:21 PM9/17/03

to

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

"Doug" <sdh...@hotmail.com> wrote in message news:a0992f50.03091...@posting.google.com...

Andy B

unread,

Sep 18, 2003, 10:09:11 AM9/18/03

to

David

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

Andy.

"David McRitchie" <dmcri...@msn.com> wrote in message
news:u3KqKDXf...@TK2MSFTNGP09.phx.gbl...