Easily Remove Hyperlinks in Excel


What could be easier than using Paste Special to remove your hyperlinks?

Here’s how:

  1. In a blank cell in your worksheet, key in the number 1.
  2. Select the cell and click CTRL + C to copy the cell contents to your Clipboard.
  3. Depress your CTRL key as you click each hyperlink you would like to remove.
  4. Display the Home tab of your Ribbon.
  5. In the Clipboard group, click the down arrow under the Paste tool.
  6. Select Paste Special to display the dialog box.

Paste Special

  1. Select the Multiply button.
  2. Click OK.

All of your hyperlinks have been removed but the text remains.

Delete the cell you created in step one above.

 

Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

There are no comments

Your email address will not be published. Required fields are marked *