Remove hyperlinks

  • Thread starter Thread starter John Conklin
  • Start date Start date
J

John Conklin

Good Morning All,

I have a spreadsheet with about 3800 words which are all hyperlinks. Is
there a way to remove the hyperlink from all of them at the same time
instead of individually right-clicking, hyperlink, remove?

Thanks,
~John
 
Have you tried the following from help?

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

Does that work?
- Dan
 
Back
Top