Hi Tamsin,

To delete a selection of hyperlinks, select the required area of cells and
then do the following:
- Press Alt + F11 to open the Visual Basic Editor.
- Press Ctrl + G to view the 'Immediate Window'.
- Type selection.hyperlinks.delete into the immediate window and press return.
- Close the immediate window and VB editor - you should see that your links
have been removed.
- You could create a VBA sub (macro) to do this and put it in a tool bar or
menu if you wanted.

To prevent Excel from automatically converting text into hyperlinks, do the
following:
- From the menu, select Tools, Options, then the Spelling tab.
- Click the 'Autocorrect Options...' button, then the 'Autoformat As You
Type' tab.
- Un-tick the box entitled 'Internet and Network Paths with Hyperlinks'.

You should beware that this is a global setting so hyperlinks will not be
automatically created on any workbooks until you turn them back on.

Hope this helps,

Mark


"Tamsin" wrote:

i am currently having problems with hyperlinks. Is there a way to
permanently remove from a spreadsheet without having to go into each cell
individually (I have text in the cells)? I have been deleting them and they
keep reappearing - the hyperlinks are even appearing in new spreadsheets and
now seem to be embedded in other spreadsheets.

Any help would be much appreciated.
--
Tamsin