Insert and Remove Hyperlinks

Hyperlinks on MO-210

Associate projects frequently include a menu, index, or instructions sheet that should jump to another worksheet, a specific cell, a named range, a web help page, or a mailto address. The skill is insert and remove hyperlinks—not the HYPERLINK worksheet function (useful in real life, but the dialog-based Insert Link control is what the objective domain emphasizes).

How to open the Insert Hyperlink dialog

Select the cell that should contain the link, then use any of these:

• Insert tab → Link (labeled Hyperlink in some builds)
• Right-click the cell → Link / Hyperlink
• Keyboard: Ctrl+K

The dialog’s left pane (or equivalent Link to options) chooses the target category. The fields on the right change based on that choice.

Link type 1: Existing File or Web Page (URL)

Use this when the task provides a website or file path.

1. Select Existing File or Web Page.
2. In Address (or URL), enter the full address, such as https://www.microsoft.com/excel.
3. Set Text to display to the friendly label (for example, Excel help) if the cell should not show the raw URL.
4. Optionally click ScreenTip… and enter hover text.
5. Click OK.

Cells with links usually appear underlined in the hyperlink theme color. Ctrl+Click (or a single click, depending on Excel options) follows the link—practice following vs selecting the cell for editing.

Link type 2: Place in This Document

This is the most common MOS workbook scenario: connect related sheets.

1. Select Place in This Document.
2. Under Cell Reference, pick a sheet and type a cell such as A1, or select a Defined Name if the destination is named.
3. Confirm Text to display (for example, Go to Sales).
4. Add a ScreenTip if the task asks for one ("Display a ScreenTip that says Jump to the Sales sheet").
5. OK.

Exam scenario: menu sheet

Descriptor: "On the Menu sheet, in cell B5, create a hyperlink that displays Click for Inventory and goes to cell A1 on the Inventory worksheet. Add a ScreenTip: Open inventory list."

Steps:

1. Activate Menu → select B5.
2. Ctrl+K → Place in This Document → select Inventory → cell reference A1.
3. Text to display: Click for Inventory.
4. ScreenTip: Open inventory list → OK.

If Inventory!A1 is also named InventoryTop, linking to the defined name is often more resilient when rows are inserted later—but only use the name if it exists or the task tells you to link to that name.

Link type 3: E-mail Address

1. Select E-mail Address.
2. Enter the address (Excel may add mailto: automatically).
3. Optionally fill Subject when the task specifies an email subject line.
4. Set display text such as Contact registrar.
5. OK.

Following the link opens the default mail client with the address filled in. On exam VMs, you typically only need to create the link correctly—not send mail.

Display text vs ScreenTip vs target

Keep these three distinct:

Tasks often grade all three. A correct target with wrong display text can still fail the step.

Edit and remove hyperlinks

Edit: Right-click the linked cell → Edit Hyperlink. Change the target, display text, or ScreenTip without recreating from scratch.

Remove: Right-click → Remove Hyperlink. The display text remains as ordinary text; only the link is cleared. To remove many links, select the range, right-click, and remove, or use Home → Clear carefully without wiping needed values.

Change the cell without launching the link: Click and hold, or use the arrow keys to enter the cell; avoid accidental Ctrl+Click while editing.

If you need to delete both text and link, clear contents (Delete) after removing the link, or clear the cell entirely if the task says to remove the entry.

Hyperlinks vs named-range navigation

• Name Box / Go To — You navigate while editing; nothing appears as clickable text for end users.
• Hyperlink — Creates a user-facing control on the sheet, which is what "insert a hyperlink" tasks require.

Do not substitute a Name Box jump when the project explicitly asks for a hyperlink in a cell.

Quality checklist for link tasks

1. Correct cell contains the link.
2. Correct link category (web / place in document / email).
3. Correct target sheet, cell, name, URL, or address.
4. Exact display text from the instructions (spelling and capitalization).
5. ScreenTip present when requested.
6. Remove or edit when the task says the old link is wrong—do not stack a second link in an adjacent cell unless told to.

Common traps

• Linking to the wrong sheet with a similar name (Sale vs Sales).
• Leaving Text to display as the raw URL when the task specified friendly text.
• Forgetting ScreenTip when it was called out as its own bullet in the instructions.
• Using Insert → Illustration icons or shapes without assigning a link when the task wanted a cell hyperlink (shape links exist, but follow the descriptor).
• Removing hyperlinks by deleting the entire menu layout instead of Remove Hyperlink.

Master Ctrl+K, Place in This Document, ScreenTip, and Remove Hyperlink, and you will clear this objective quickly inside larger Domain 1 projects.