Excel: 3 Power Tips to Moderate Hyperlinks

0

Hyperlinks use memory, and lots of hyperlinks in your spreadsheet, document, or email can slow down your system, crash an open file, or even refuse to open the file. Use these handy tricks to keep them under control.

excel_2013-3e7309ea2dbd8944be164009d840feae

1. Delete multiple hyperlinks simultaneously

For example, no one has the time or desire to remove dozens of hyperlinks in a single spreadsheet, one at a time. While it’s a two-step process in Word and Outlook (Ctrl+A to select the entire document, then Ctrl+Shift+F9 to make them all disappear on every single page), Excel requires four steps.

First, choose a spreadsheet with multiple hyperlinks, or enter some email addresses and URLs in cells A2 through A12.

  1. Highlight the column of hyperlinks.
  2. Hold down the Ctrl key, then click any cell in the highlighted section. A green line frames the selected cell (note that the highlighted section is still selected).
  3. Right-click on the framed cell.
  4. ChooseRemove Hyperlinksfrom the dropdown list.

2. Remove scattered hyperlinks

If the hyperlinks are all over the place in multiple columns and rows, try this:

  1. PressCtrl+Atwice: Once highlights the current range, twice selects the entire spreadsheet.
  2. Hold down theCtrlkey and click any cell in the spreadsheet.
  3. When the green line frames the selected cell, right-click once on that cell.
  4. ChooseRemove Hyperlinksfrom the dropdown list. Piece of cake.

3. Deactivate auto-hyperlinks

Every time we enter URLs, email addresses, or any linking data, Excel automatically converts these to active hyperlinks. This is also true for copying or importing links from other files. If you find this feature irritating, you can disable it.

Disable auto-hyperlinks

  1. Go to FileOptions.
  2. In the Excel Optionsdialog, click Auto Correct Options.
  3. In the Auto Correctdialog, select the AutoFormat As You Typetab.
  4. In this window, under Replace As You Type:uncheck the Internet and Network Paths with Hyperlinkscheck box. Hyperlinks are now disabled before and after you type, copy, or import them.
SHARE