How to remove so many hyperlink in a single click?

  • Thread starter Thread starter Harshad
  • Start date Start date
H

Harshad

I have so may cells in a sheet, which cointains hyperlink. i want to remove
hyperlink off all the cells of sheet in a single clik.

Extraordinary ideas wanted.

Thanks
 
Hi Harshad,

Try the following if its MS 2007.

- Select the cells for those you want to remove hyperlink.
- On the Home tab, in the Styles group, click Cell Styles
- Under Good, Bad, and Neutral, select Normal.

Hope it helps.
 
you can try this also:


- Select the cells for those you want to remove hyperlink.
1. In a blank cell, type the number 1.
2. Right-click the cell, and then click Copy on the shortcut menu.
3. Hold down CTRL and select the cells for those you want to remove hyperlink.
- On the Home tab, in the Clipboard group, click the arrow below Paste, and
then click Paste Special.
- Under Operation, click Multiply, and then click OK.
- On the Home tab, in the Styles group, click Cell Styles.
- Select Normal.
 
Back
Top