When you’re working in a spreadsheet, it’s often useful to include URLs and online links. This helps you reference additional content inside your workbook. Fortunately, these are easy to add in Excel. Let’s learn how to add hyperlinks in Microsoft Excel.
How to Add Hyperlinks in Excel
Hyperlinks transform URLs into clickable links inside your spreadsheets. This helps you direct users to online content while leaving your Excel spreadsheet open in the background. It’s an excellent way to collaborate with others and incorporate outside resources to complete your work.
To add a hyperlink in Excel, you’ll first need to launch your favorite web browser. Find the URL that you want to add to Excel, and click into the URL box in the center of the browser’s menu. Select the text inside, then press Command + C (Control + C on Windows) to copy it to your clipboard.
Next, go back to Excel and click into a cell where you wish to place your hyperlink. Then, go to the Insert tab on Excel’s ribbon. Here, you’ll see an array of options. In this case, click on the Link button over on the right side.
Excel will launch the Insert Hyperlink menu. Since you already copied a URL to your clipboard, you’re ready to go. Click into the Address field, and paste your URL into it by pressing Command/Control + V. Optionally, you can change how the URL text displays in the Text to Display box at the top of the menu.
When you’re finished, click OK. Excel will insert a hyperlink in your selected cell. You can click on it, and the URL will open in your default web browser.
As you can see, Microsoft Excel makes it easy to add and edit hyperlinks. These let you easily send users of your spreadsheets to websites and other online links.