• About the site - Computer News Deals.com
  • Computer News Deals.com is a web portal with very unique concept of news blended with other important aspects of computer and internet technology.
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
Related News
Moto G4 and Moto G4 Plus review: No longer the best budget smartphones available
Friendable Expands Infrastructure to Accommodate User Growth and Increased Time Spent in the App
GGMM E3 Wireless Smart Speaker review: This little speaker delivers big sound
How ARM set itself up for a $32 billion acquisition