Browse » Home
Monday, July 25, 2011
How to Remove Mass Links in Excel 2007
1. Open the Microsoft Excel 2007 file on your computer that contains the links you want to remove.
2. Enter '1' into a blank cell within your worksheet. Right-click on the cell with your mouse and then click on the 'Copy' option.
3. Hold down the 'CTRL' key on your keyboard and select each link in your worksheet that you want to remove.
4. Click the 'Home' tab. Click the arrow below the 'Paste' field in the 'Clipboard' group. Click the 'Paste Special' option.
5. Click the 'Multiply' option and then click the 'OK' button. Click the 'Home' tab again and then click the 'Cell Styles' option from the 'Styles' group.
6. Select the 'Normal' option below the 'Good, Bad, and Neutral' field and all of the links you selected will be removed.