I’m hopeful that it can be improved without impairing the truly useful nature of this feature. So you can’t change it if you want to.Ĭlearly, there is room for improvement with this dialog. Also, if you want to edit this type of hyperlink, the text box is disabled when you open the “Edit Hyperlink” dialog (same as Insert Hyperlink).When you choose an entry from that list, it is placed in the text box above, but the text box is then disabled, so you can’t change it if you want to.

Here is a simple trick that lets you overcome this limitation, of course, the trick works in Excel 2019, 2016, and 2013 too. In Excel 2000-2007, there is no built-in function to delete multiple hyperlinks at a time, only one by one. So be ready to spend time scrolling through that list to find the ones you want. Disable automatic creation of hyperlinks in Excel Remove multiple hyperlinks in all Excel versions.

If you have lots of named ranges, they’re all in that list unsorted! In fact, they’re seemingly in some random order.

This would be convenient if you were doing numerous links to named ranges with short names.

If you want to use a named range, you cannot just type it in the cell reference text box.

It is useful to specify a range here too, because Excel will try to make as much of that range visible as possible when you use the link, given the available space. Then you’d click that same icon in the mini-menu when done. The little cell icon would give you a mini-menu while you’re moving around the worksheet, and

Must be typed, when it would be convenient to use the range picker used in other places, such as when choosing the rows to repeat at the top of pages when printed. When you want to add a hyperlink to a cell, and you use the “Link” button on the “Insert” ribbon menu or the “Link” entry in the cell context menu, you get the “Insert Hyperlink” dialog where you can choose “Place in This Document”.Although the hyperlink is very convenient to use, it isn’t quite as easy to get set up, depending on your circumstances. However, there are some usability issues with this feature that I hope are addressed by Microsoft in the next version of Office. Excel also supports hyperlinks to other locations in the same document, either on the same In Excel 2016 (and perhaps prior versions), you probably have seen cells in a worksheet that are hyperlinks to locations such as documents, other files, and websites.

Removing hyperlinks in excel 2016