How to insert a hyperlink with text in Excel? First choose the cell in which you want to insert the hyperlink. Right click on the cell and select the Hyperlink option.

To add hyperlinks to Excel, you can type the corresponding URL, add hyperlinks using the Link feature or use the HYPERLINK Function.

A: Excel 2010, 2007, and 2003 provide a hyperlink function that converts text to a clickable hyperlink. In the example below, I entered =HYPERLINK (L2) in cell M2, which converts the text-based data ...

Click OK. The result is a hyperlink that selects cell B1 on the Products sheet. Notice that the hyperlink uses the text in the named cell. There’s another way that you might find a bit easier.

Excel does its best to handle hyperlinks, even though they're ungainly in spreadsheets. Here are tricks you'll need to keep them under control.

Two updates stand out as more advanced features that push the Online version closer to paid Excel: in-document hyperlinks, and better PivotTable summaries.