How to Remove Hyperlinks in Microsoft Excel 2007

Excel 2007 Cell Styles

There are advantages to using hyperlinks in Excel worksheets; however, there are times when you may prefer that the links not not display or not function at all. With Microsoft Excel 2007, removing hyperlinks from view is super easy.

Step 1

Open the Microsoft Excel 2007 workbook that has hyperlinks you want to remove.

  • Step 2

    Remove Single Link

    To remove a single link, right click the cell that the link is in, and from the pop-up menu, click on Remove Hyperlink.

  • Step 3

    If you need to remove multiple hyperlinks, select them. If the links are scattered through the worksheet, you can select the cells by holding down on the CTRL key as you click each cell to highlight it.

  • Step 4

    Styles – Normal

    On the Home tab, in the Styles group, click on Cell Styles. From the drop down menu, click on Normal. The hyperlinks no longer displays, so it is REMOVED FROM VIEW. However, hovering your mouse over the text, you will see that the link is still functional. See Step 5 to learn how to completely delete hyperlinks from cells.

  • Step 5

    To completely DELETE multiple hyperlinks, in any empty cell, type in the number 1 (it can be deleted later).

  • Step 6

    Copy Cell

    Right click the cell where you typed the number 1 and then click on Copy.

  • Step 7

    Perform Step 3, i.e., select the cells with hyperlinks that you want to delete.

  • Step 8

    Paste Special

    On the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special.

  • Step 9

    Multiple

    Under Operation, click on Multiply, and then click OK.

  • Step 10

    Lastly, perform Step 4 to apply the Normal Cell Style. The hyperlinks are deleted. You can now delete the number 1 used to perform this task.

  • Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: