| Home : July 20 2016 Computer News : Excel power tips: 3 handy ways to tame hyperlinks |
|
Excel power tips: 3 handy ways to tame hyperlinks |
July 20, 2016
Excel does its best to handle hyperlinks such as email addresses and URLs, even though they're incredibly awkward to shoehorn into spreadsheets. If you have only a few links in your spreadsheet, no problem. But hyperlinks use memory, and lots of hyperlinks in a spreadsheet, document, or email can slow your system to a crawl, crash the open file, or refuse to open the file (usually with a ‘not enough memory’ error message).
Here are tricks you'll need to keep them under control.1. Remove 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.To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/3094992/software/excel-power-tips-3-handy-ways-to-tame-hyperlinks.html#tk.rss_howto
|
|
|
|
|