ExamFinch.com My Study

Study guide

Insert and Remove Hyperlinks

Practice this exam

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

Insert and Remove Hyperlinks

Key Takeaways Explain This Topic AI

Insert links with Insert → Link (Hyperlink), right-click → Link, or Ctrl+K

Link types include Existing File or Web Page (URL), Place in This Document (cell, sheet, or defined name), and E-mail Address

ScreenTip adds hover text; Display text controls what the cell shows versus the underlying target

Edit a link via right-click → Edit Hyperlink; remove with right-click → Remove Hyperlink (cell text remains)

  • MO-210 often uses Place in This Document links to connect a menu sheet to related worksheets
  • Last updated: August 2026

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.

Select Existing File or Web Page .

In Address (or URL), enter the full address, such as https://www.microsoft.com/excel .

Set Text to display to the friendly label (for example, Excel help ) if the cell should not show the raw URL.

Optionally click ScreenTip… and enter hover text.

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.

Select Place in This Document .

Under Cell Reference , pick a sheet and type a cell such as A1 , or select a Defined Name if the destination is named.

Confirm Text to display (for example, Go to Sales ).

Add a ScreenTip if the task asks for one ( "Display a ScreenTip that says Jump to the Sales sheet" ).

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:

Activate Menu → select B5.

Ctrl+K → Place in This Document → select Inventory → cell reference A1 .

Text to display: Click for Inventory .

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

Select E-mail Address .

Enter the address (Excel may add mailto: automatically).

Optionally fill Subject when the task specifies an email subject line.

Set display text such as Contact registrar .

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:

  • Field What it controls
  • Text to display Visible cell content users read
  • Address / place / email Where the link goes when followed
  • ScreenTip Tooltip on hover; does not change the cell value

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

Correct cell contains the link.

Correct link category (web / place in document / email).

Correct target sheet, cell, name, URL, or address.

Exact display text from the instructions (spelling and capitalization).

ScreenTip present when requested.

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.