Thursday, February 28, 2013

How to Remove All Hyperlinks Except One in Excel 2003


1. Open on your computer the Microsoft Excel 2003 file that contains the hyperlinks you want to remove.
2. Click any blank cell in your worksheet and type '1' into the cell. Click your mouse outside the cell.
3. Right-click the cell with the '1' in it, and then select the 'Copy' option from the shortcut menu.
4. Hold down the 'CTRL' key on your keyboard while selecting each hyperlink you want to remove. Make sure to not click the one link you want to keep.
5. Select the 'Edit' menu option from the top toolbar, and then click the 'Paste Special' option. Select the 'Multiply' option and then click the 'OK' button. All the hyperlinks you selected will be removed.

Blogger news