by Allen Wyatt
(last updated June 13, 2020)
Excel makes it rather easy to insert a hyperlink into a cell. You may, however, want to actually add a hyperlink to a comment instead of to a cell. This can also be done; the trick is to make sure that the only thing contained in the comment is the hyperlink itself.
Note that Microsoft changed the way comments work in Excel in Office 365. Comments are now threaded allowing users to have discussions with each other regarding the data. Notes work like comments in earlier versions of Excel. The following steps apply both to earlier versions of Excel using comments and to Excel for Office 365 using notes:
Now you can click on the comment/note that contains the URL and Excel helpfully opens the browser and displays whatever is at that URL. You needed to perform steps 7 and 8 because you need to hover the mouse pointer over the comment/note containing the URL (in order to click it) and you can't hover over a comment/note that isn't displayed.
If you still cannot get the hyperlink to activate successfully, there are two probable culprits. First, you need to make sure that the hyperlink itself is initially the only thing in the comment/note. (More on that in a moment.) That is why you need to perform steps 3 and 5 in the above sequence of steps. The other possible culprit is that you didn't put in a URL that Excel could recognize as a URL.
Now, more on the URL being the only thing in the comment/note. Interestingly enough, once you get the URL to work properly you are free to change the text that the comment/note contains. So, for instance, when I created a comment/note that contained the URL "www.tips.net" (without the quote marks) and nothing else, I could then click on the comment/note and the webpage was displayed. I could then go back, right-click the comment/note to edit it and change the text to something else (such as "Let's go to Tips.net"). Even though the URL was no longer visible, the link was still active in the comment/note and clicking on the comment/note displayed the Tips.net webpage.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9086) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Excel allows you to copy information from the web and paste it into a worksheet. Problem is, the pasting could take some ...Discover More
Hyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a ...Discover More
If you open workbooks in two instances of Excel, you can use drag-and-drop techniques to create hyperlinks from one ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.