Thursday, April 12, 2012

How to Remove Hyperlinks From Excel 2007


1. Double-click your Excel file to open the file in Microsoft Excel 2007.
2. Select a blank cell in your spreadsheet, then type the number '1' into the cell.
3. Right-click on the cell and select 'Copy.'
4. Hold down the 'Ctrl' key on your keyboard as you select each cell containing a hyperlink that you want to remove.
5. Click the 'Home' tab at the top of the Excel 2007 window.
6. Click the arrow below 'Paste' in the 'Clipboard' section, then click 'Paste Special.'
7. Click 'Multiply' in the 'Operation' section, then click 'OK.' This removes the actual hyperlink from the cell, but it leaves your data underlined.
8. Click 'Cell Styles' in the 'Styles' section at the top of the window.
9. Click 'Normal' under the 'Good, Bad and Neutral' section to remove the underlines.

Blogger news