I have several columns with several dozens of hyperlinked entries in each
column. I'd like to unlink them all. I highlighted all entries in a column
and removed underlines, changed their color to black, but they still were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

Right-click and select hyperlink... and remove the link
Now using Format Painter copy this format to any other cell required.

Steve



On Wed, 23 Aug 2006 01:22:14 +0100, ilyaz wrote:

I have several columns with several dozens of hyperlinked entries in each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

Steve,

I followed your instructions. The format painter removed the underline but
when I clicked on the cell, the link was still there. Am I missing
something?

Epinn

"SteveW" wrote in message
news:op.tepvvlgbevjsnp@enigma03...
Right-click and select hyperlink... and remove the link
Now using Format Painter copy this format to any other cell required.

Steve

On Wed, 23 Aug 2006 01:22:14 +0100, ilyaz wrote:

I have several columns with several dozens of hyperlinked entries in each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

Sorry, I normally really check my posts in excel.
It removed the formatting, so *wrongly* I assumed it had removed the
hyperlink

Ta, for pointing it out.

Just select the range/column and right-click choose Hyperlink.. and then
*Remove Link..* from the dialogue

Steve

On Wed, 23 Aug 2006 04:47:15 +0100, Epinn
wrote:

Steve,

I followed your instructions. The format painter removed the underline
but
when I clicked on the cell, the link was still there. Am I missing
something?

Epinn

"SteveW" wrote in message
news:op.tepvvlgbevjsnp@enigma03...
Right-click and select hyperlink... and remove the link
Now using Format Painter copy this format to any other cell required.

Steve

On Wed, 23 Aug 2006 01:22:14 +0100, ilyaz wrote:

I have several columns with several dozens of hyperlinked entries in
each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still
were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

Select the range/column?? Have you tested this?

"Remove hyperlink" seems to work with one cell at a time only. What
dialogue? Clicking hyperlink = insert. Did I miss anything?

So far, only copy 1 and paste special (multiply) appears to remove
**multiple** hyperlinks.

Epinn

"SteveW" wrote in message
news:op.tep36tcoevjsnp@enigma03...
Sorry, I normally really check my posts in excel.
It removed the formatting, so *wrongly* I assumed it had removed the
hyperlink

Ta, for pointing it out.

Just select the range/column and right-click choose Hyperlink.. and then
*Remove Link..* from the dialogue

Steve

On Wed, 23 Aug 2006 04:47:15 +0100, Epinn
wrote:

Steve,

I followed your instructions. The format painter removed the underline
but
when I clicked on the cell, the link was still there. Am I missing
something?

Epinn

"SteveW" wrote in message
news:op.tepvvlgbevjsnp@enigma03...
Right-click and select hyperlink... and remove the link
Now using Format Painter copy this format to any other cell required.

Steve

On Wed, 23 Aug 2006 01:22:14 +0100, ilyaz wrote:

I have several columns with several dozens of hyperlinked entries in
each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still
were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

You don't get me twice - I double checked this time :)

Right-click on one gives a remove option
but right-click on a range gives ... a dialogue box
in the bottom left ..

HOLD IT - it's gone!

Actually it is there if all the selected links are the same which is what
I had in my test :)

Going back to bed - ta

Steve


On Wed, 23 Aug 2006 07:50:30 +0100, Epinn
wrote:

Select the range/column?? Have you tested this?

"Remove hyperlink" seems to work with one cell at a time only. What
dialogue? Clicking hyperlink = insert. Did I miss anything?

So far, only copy 1 and paste special (multiply) appears to remove
**multiple** hyperlinks.

Epinn

"SteveW" wrote in message
news:op.tep36tcoevjsnp@enigma03...
Sorry, I normally really check my posts in excel.
It removed the formatting, so *wrongly* I assumed it had removed the
hyperlink

Ta, for pointing it out.

Just select the range/column and right-click choose Hyperlink.. and then
*Remove Link..* from the dialogue

Steve

On Wed, 23 Aug 2006 04:47:15 +0100, Epinn
wrote:

Steve,

I followed your instructions. The format painter removed the underline
but
when I clicked on the cell, the link was still there. Am I missing
something?

Epinn

"SteveW" wrote in message
news:op.tepvvlgbevjsnp@enigma03...
Right-click and select hyperlink... and remove the link
Now using Format Painter copy this format to any other cell required.

Steve

On Wed, 23 Aug 2006 01:22:14 +0100, ilyaz wrote:

I have several columns with several dozens of hyperlinked entries in
each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still
were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

Hi,

I found the following instructions from "help." I did a test and it seemed
to work like a charm.

Deactivate several hyperlinks at once
1.. Type the number 1 in a blank cell, and right-click the cell.
2.. Click Copy on the shortcut menu.
3.. While pressing CTRL, select each hyperlink you want to deactivate.
How?

a.. 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.
4.. Click Paste Special on the Edit menu.
5.. Under Operation, click Multiply and then click OK.
Epinn

"ilyaz" wrote in message
...
I have several columns with several dozens of hyperlinked entries in each
column. I'd like to unlink them all. I highlighted all entries in a column
and removed underlines, changed their color to black, but they still were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

Steve and Epinn,
I'm glad I woke up late today and got to the end of your discussion ;)).
Sure, the last suggestion from Excel's help works. But still, it requires
clicking on EACH hyperlinked cell. I have too many of them...
Thanks, guys, for making my task a little bit easier. But still, if you will
find how to remove hyperlinks in a whole column or in several columns I'll
appreciate it.
Ilya

"Epinn" wrote in message
...
Hi,

I found the following instructions from "help." I did a test and it
seemed
to work like a charm.

Deactivate several hyperlinks at once
1.. Type the number 1 in a blank cell, and right-click the cell.
2.. Click Copy on the shortcut menu.
3.. While pressing CTRL, select each hyperlink you want to deactivate.
How?

a.. 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.
4.. Click Paste Special on the Edit menu.
5.. Under Operation, click Multiply and then click OK.
Epinn

"ilyaz" wrote in message
...
I have several columns with several dozens of hyperlinked entries in each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

Epinn's solution does work for a block
mine only does if *all* the hyperlinks are the same - not the usual case :)

Steve


On Wed, 23 Aug 2006 17:29:04 +0100, ilyaz wrote:

Steve and Epinn,
I'm glad I woke up late today and got to the end of your discussion ;)).
Sure, the last suggestion from Excel's help works. But still, it requires
clicking on EACH hyperlinked cell. I have too many of them...
Thanks, guys, for making my task a little bit easier. But still, if you
will
find how to remove hyperlinks in a whole column or in several columns
I'll
appreciate it.
Ilya

"Epinn" wrote in message
...
Hi,

I found the following instructions from "help." I did a test and it
seemed
to work like a charm.

Deactivate several hyperlinks at once
1.. Type the number 1 in a blank cell, and right-click the cell.
2.. Click Copy on the shortcut menu.
3.. While pressing CTRL, select each hyperlink you want to deactivate.
How?

a.. 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.
4.. Click Paste Special on the Edit menu.
5.. Under Operation, click Multiply and then click OK.
Epinn

"ilyaz" wrote in message
...
I have several columns with several dozens of hyperlinked entries in
each
column. I'd like to unlink them all. I highlighted all entries in a
column
and removed underlines, changed their color to black, but they still
were
linked. Sure, I can unlink each one, but it will take several hours to
finish my job. Is there a way to unlink all hyperlinks at once, or, at
least, in each column separately?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida