The quickest way that I have found, and an approach you can use in many
other circumstances , is to use the Repeat Action function key, F4.

Select cell A1, right-click and remove the hyperlink.
Then use the down arrow key, and press F4,
Repeat ad nauseum.

You still have to select every cell, but only one right-click, and you can
do it in a co-ordinated manner, right hand down arrow, left F4, it gets
quite efficient.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dstess" <[email protected]> wrote in message
news:[email protected]...
> Thank you both Bob and Gord,
>
> I did figure out the right click and remove hyperlink; unfortunatly, I
could
> not figure out how to do all of the emails at one time, so I spent WAY too
> much time clicking each one and removing the hyperlink.
>
> Left click and hold could be helpful later for as new volunteers are added
> it is still changing their addresses to the hyperlink, of course I have
now
> gotten use to the "right click, remove" steps so that might take just as
much
> time.
>
> There should be a way to deactivate all hyperlinks in the spreedsheet
though.
>
> Sneak up on it... he he he... cute one.
>
> Thanks again for your help.
>
>
> "Gord Dibben" wrote:
>
> > If you left-click and hold for 2 seconds it won't do its hyperlink jump.
> >
> > The cell will remain selected for formatting/editing.
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Sat, 8 Jan 2005 11:10:29 -0000, "Bob Phillips"
> > <[email protected]> wrote:
> >
> > >Sneak up on it :-)
> > >
> > >Don't click the cell, click an adjacent cell, and then use the arrow
keys to
> > >navigate to the cell. Change it as you wish.
> > >
> > >Alternatively, get to the cell in the same way and remove the hyperlink
> > >(Insert>Hyperlink Remove Hyperlink)
> >
> >