Add hyperlinks, bookmarks and email links in Excel

Ever wondered how to add hyperlinks, bookmarks or email links in Excel? The answers are here.

The following steps apply to Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel Online.

Contents
  1. What are hyperlinks, bookmarks and mail links?
  2. Open the Insert Hyperlink dialog
  3. Open the Insert Hyperlink dialog box using the ribbon
  4. Add hyperlink in Excel
  5. Add a hyperlink to a web page
  6. Add hyperlink to Excel file
  7. Bookmark the same Excel sheet
  8. Bookmark the same sheet?
  9. Bookmark another sheet
  10. Paste Mailto link into Excel file
  11. Remove hyperlink without removing anchor text

What are hyperlinks, bookmarks and mail links?

First, let’s clarify what we mean by each term.

hyperlink allows you to open a web page by selecting a cell in a worksheet. It is also used in Excel to provide quick and easy access to other Excel workbooks.

bookmark links to a specific area in the current sheet or to another sheet in the same Excel file using cell references.

Clutch mail to is a link to an email address. Selecting the mailto link opens a new message window in your default email program and inserts the email address into the “To” line of the message.

In Excel, hyperlinks and bookmarks are designed to make it easier to navigate between areas of related data. Email links make it easy to send email messages to a person or organization. In all cases:

  • Whatever type of link is created, it is created by entering the required information in the Insert Hyperlink dialog box.

  • As with links on web pages, links in Excel are attached to the anchor text in the worksheet cell.

  • Adding this anchor text before opening the dialog makes it easier to create the link, but it can also be entered after the dialog opens.

Open the Insert Hyperlink dialog

Hotkey to open a dialog box Insert hyperlink ctrl k on pc or order k on Mac.

  1. On an Excel sheet, select the cell that will contain the hyperlink.

  2. Enter a word that will act as anchor text, such as “Spreadsheets” or “June_Sales.xlsx” and click Enter

  3. Select the cell containing the anchor text a second time.

  4. Press and hold a key ctrl (in Windows) or key Assignment (on Mac).

  5. Press and release the button k to open the Insert Hyperlink dialog box.

Open the Insert Hyperlink dialog box using the ribbon

  1. On an Excel sheet, select the cell that will contain the hyperlink.

  2. Enter a word that will act as anchor text, such as “Spreadsheets” or “June_Sales.xlsx” and click Enter

  3. Select the cell containing the anchor text a second time.

  4. Select Insert † (In Excel 2011 for Mac, go to Insert menu

  5. Select hyperlink or Clutch insert link in the link group. The Insert Hyperlink dialog box opens.

Add hyperlink in Excel

Here’s how to set up a hyperlink to go to a web page or Excel file.

Add a hyperlink to a web page

  1. Open the dialog box Insert hyperlink using one of the methods described above.

  2. Open a tab An existing file or web page

  3. In line The address enter the full URL.

  4. Select Okay to end the hyperlink and close the dialog box.

Anchor text in a worksheet cell is blue and underlined to indicate that it contains a hyperlink. Each time it is selected, the assigned website will open in the default browser.

Add hyperlink to Excel file

Remark. This option is not available in Excel Online.

  1. Open the dialog box Insert hyperlink

  2. Open a tab An existing file or web page

  3. Select Find file to open the File Link dialog box.

  4. Search to find the name of the Excel file, select the file and choose Okay † The file name is added to the address line in the Insert Hyperlink dialog box.

  5. Select Okay to end the hyperlink and close the dialog box.

The anchor text in the worksheet cell turns blue and is underlined to indicate that it contains a hyperlink. When selected, the assigned Excel workbook opens.

Bookmark the same Excel sheet

A bookmark in Excel is similar to a hyperlink, except it is used to link to a specific area on the current sheet or to another sheet in the same Excel file.

While hyperlinks use file names to create links to other Excel files, bookmarks use cell references and table names to create links.

Bookmark the same sheet?

The following example creates a bookmark in a different location on the same Excel worksheet.

  1. Enter a name in the cell to be used as the anchor text for the bookmark and click Enter

  2. Select this cell to make it active.

  3. Open the dialog box Insert hyperlink

  4. Open a tab Place in this document (or click the button Place in this document in Excel Online).

  5. In a text field Enter cell reference enter a reference to a cell elsewhere on the same sheet, such as “Z100”.

  6. Select Okay to complete the bookmark and close the dialog box.

Anchor text in a worksheet cell is now blue and underlined to indicate it contains a bookmark.

Select a bookmark and the active cell cursor moves to the cell reference entered for the bookmark.

Bookmark another sheet

Creating bookmarks on different sheets in the same Excel file or workbook has an extra step. You also define the destination sheet for the bookmark. Renaming worksheets makes it easier to bookmark files with many worksheets.

  1. Open a multilayer Excel workbook or add additional sheets to a single sheet file.

  2. On one of the sheets, enter a name in the cell to use as the anchor text for the bookmark.

  3. Select this cell to make it active.

  4. Open the dialog box Insert hyperlink

  5. Select tab Place in this document (or click the button Place in this document in Excel Online).

  6. Enter a cell reference in the field Enter cell reference

  7. in field Or choose a place in this document , select the destination sheet name. The unnamed sheets are identified as Sheet1, Sheet2, Sheet3, and so on.

  8. Select Okay to complete the bookmark and close the dialog box.

Anchor text in a worksheet cell is now blue and underlined to indicate it contains a bookmark.

Select a bookmark and the active cell cursor moves to the cell reference on the sheet entered for the bookmark.

Paste Mailto link into Excel file

By adding contact details to an Excel sheet, you can easily send an email from a document.

  1. Enter a name in the cell to serve as the anchor text for the mailto link and click Enter

  2. Select this cell to make it active.

  3. Open the dialog box Insert hyperlink

  4. Select tab E-mail address (or click the button E-mail address in Excel Online).

  5. in field E-mail address enter the email address of the person who will receive the email. This address is entered in the To line. a new email message when the link is selected.

  6. under the line Subject enter the subject of the message. This text is entered in the subject line of a new message. This option is not available in Excel Online.

  7. Select Okay to complete the email link and close the dialog box.

Anchor text in a worksheet cell is now blue and underlined to indicate that it contains a hyperlink.

Select the mailto link and the default e-mail program will open a new message with the address and subject text you entered.

Remove hyperlink without removing anchor text

If you no longer need a hyperlink, you can remove the link information without removing the text that served as the anchor.

  1. Move your mouse over the hyperlink you want to remove. The pointer arrow should change to a hand symbol.

  2. Right-click on the hyperlink anchor text to open the context menu.

  3. Select Remove hyperlink

The blue color and underline should be removed from the anchor text to indicate that the hyperlink has been removed.

Leave a Reply

Your email address will not be published. Required fields are marked *