Burden of live web cells

[kevs]

I have a cell with live web address. Now the cell to the right types with an
underline live link. Anyway to stop the contamination? And how to unlink the
first one? Thanks.
Kevs

OS 10.4.7
Office 2004

 

[Mr F]

I have a cell with live web address. Now the cell to the right types with an
underline live link. Anyway to stop the contamination? And how to unlink the
first one? Thanks.
Kevs

OS 10.4.7
Office 2004

I can't reproduce the problem with the cell to the right, but to get
into the cell without activating the link is just a matter of clicking
in a cell near by and using the cursor arrow to "get behind it". Then
Insert -> Hyperlink... will allow you to remove the link and leave
standard text.
Incidentally, putting the link back in is rather neat. When you return
to Insert -> Hyperlink the URL box will have a drop-down menu of recent
URLs for you to choose.

 

[kevs]

Thanks, that did not work. I want to have the url listed just not with the
underline without live link. And if anyone know why every single cell to the
right of this one creates underlined blue text, please let me know.

Kevs

I can't reproduce the problem with the cell to the right, but to get
into the cell without activating the link is just a matter of clicking
in a cell near by and using the cursor arrow to "get behind it". Then
Insert -> Hyperlink... will allow you to remove the link and leave
standard text.
Incidentally, putting the link back in is rather neat. When you return
to Insert -> Hyperlink the URL box will have a drop-down menu of recent
URLs for you to choose.

OS 10.4.7
Office 2004

 

[Bob Greenblatt]

Thanks, that did not work. I want to have the url listed just not with the
underline without live link. And if anyone know why every single cell to the
right of this one creates underlined blue text, please let me know.

Kevs

Kevs,

What did not work? Can you not remove the hyperlink? Are all cells (really
all the way to column IV) have underlined blue text. Do they link to
anything? Have you mistakenly selected a row instead of a single cell? Have
you changed the default cell style?

To enter text in a cell that Excel may "think" is a hyperlink, that you do
not want to be a hyperlink, precede the text with an apostrophe.

 

[CyberTaz]

Cmd+Click the cell containing the Hyperlink & choose Remove Hyperlink from
the contextual menu. The blue, the underlining & the active link will be
disabled, but the cell content will still read as
http://www.whatever.whatever - if you still want it to be blue, change the
font color.

If other cells are formatted as though they *were* hyperlinks, select them &
use Edit>Clear>Formats.

 

[CyberTaz]

Sorry - the last post was errant (and should have read Ctrl+Click, anyway) -
Remove Hyperlink isn't in the contextual menu on the Mac - just the PC
version. Instead, navigate to the cell by some way other than clicking it -
click the reference displayed in the Name Box (left end of the Formula Bar),
type the cell address containing the link, then press return.

Next, go to Insert>Hyperlink, then click the Remove Link button in the lower
left of the dialog.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Harvey Waxman]

Everyone probably knows this already but I find it useful.

When I enter an email address it automatically becomes clickable, which i
don't like.

If I 'undo' (cmd-z) immediately after entering the address, the cursor returns
to the cell, the link is removed and only the text remains. I thought this was
interesting and didn't know if it is documented anywhere.

Excel Office X

 

[kevs]

Harvey, great tip.


Hyperlinks continue on next two cells to right, and then stop.
Edit clear formats, also nice. thanks!

kev

Kevs,

What did not work? Can you not remove the hyperlink? Are all cells (really
all the way to column IV) have underlined blue text. Do they link to
anything? Have you mistakenly selected a row instead of a single cell? Have
you changed the default cell style?

To enter text in a cell that Excel may "think" is a hyperlink, that you do
not want to be a hyperlink, precede the text with an apostrophe.

OS 10.4.7
Office 2004