Deactivate several hyperlinks at once:
Type the number 1 in a blank cell, and right-click the cell.
Click Copy on the shortcut menu.
While pressing CTRL, select each hyperlink you want to deactivate.
(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.)
Click Paste Special on the Edit menu.
Under Operation, click Multiply and then click OK.
