• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Add and Remove Hyperlinks in Excel

0 Comments

Hyperlinks in Excel are useful for quickly accessing files, documents, web pages, or email addresses. They are easy to recognize in Excel as they are underlined blue or purple-colored highlighted text. In this article, we will discuss how to add and remove hyperlinks in Excel.

I. Adding Hyperlinks in Excel

There are several ways to add hyperlinks in Excel, including:

Adding a hyperlink to an existing workbook:

  • Go to the “Insert” tab, click on the “Link” icon under the “Link” group.Add and Remove Hyperlinks in Excel 1
  • Or, right-click on the cell and select “Link” from the pop-up menu.Add and Remove Hyperlinks in Excel 2
  • Or, press CTRL + K shortcut from the keyboard.
  • Select the “Existing File or Web Page” option, choose the location, and select the file or document.
  • Enter the text to display as a hyperlinked name and click OK.Add and Remove Hyperlinks in Excel 3

Adding a hyperlink to a specific sheet of an existing workbook:

  • Select the “Existing File or Web Page” option and choose the file or document.
  • Click on the “Bookmark” button.Add and Remove Hyperlinks in Excel 4
  • Select the specific sheet and targeted cell and click OK.Add and Remove Hyperlinks in Excel 5

Adding a hyperlink to a specific sheet of the current workbook:

  • Select the “Place in This Document” option and choose the specific sheet and targeted cell.

Add and Remove Hyperlinks in Excel 6

Adding a hyperlink to a web address:

  • Copy the web address from the browser and paste it into the “Address” column in the “Insert Hyperlink” window.
  • Enter the text to display as a hyperlinked name and click OK.Add and Remove Hyperlinks in Excel 7

Adding a hyperlink to open a new workbook:

  • Select the “Create New Document” option and enter the name of the new workbook.
  • Enter the text to display as a hyperlinked name.
  • Click on the change button to change the saving location of the new workbook and click OK.Add and Remove Hyperlinks in Excel 8

Adding a hyperlink to an email address:

  • Select the “E-mail Address” option and enter the email id and subject.
  • Enter the text to display as a hyperlinked name and click OK.Add and Remove Hyperlinks in Excel 9

II. Removing Hyperlinks in Excel

To remove hyperlinks in Excel, follow these steps:

To remove a hyperlink from a cell:

  • Right-click on the cell and select “Remove Hyperlink” from the pop-up menu.Add and Remove Hyperlinks in Excel 10

To remove hyperlinks from multiple cells:

  • Select the cells together and right-click and select “Remove Hyperlinks” from the pop-up menu.Add and Remove Hyperlinks in Excel 11

To remove hyperlinks from the current worksheet:

  • Select the whole worksheet by pressing CTRL+A.
  • Go to the “Home” tab and click on the “Clear” icon drop-down arrow.
  • Select “Remove Hyperlinks”.Add and Remove Hyperlinks in Excel 12

In conclusion, hyperlinks in Excel are a great way to access files, documents, web pages, or email addresses quickly. Adding or removing hyperlinks in Excel is a straightforward process that can save a lot of time and effort.

Rate this post
22
262 Views
Creating a Running Total in Excel: A Step-by-Step GuidePrevCreating a Running Total in Excel: A Step-by-Step GuideApril 25, 2023
Effortlessly Calculate Group Sums with These Simple FormulasApril 25, 2023Effortlessly Calculate Group Sums with These Simple FormulasNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
Products
  • Project Professional 2013 Microsoft Project Professional 2013 - 1 PC $9.00
  • Microsoft Visio 2019 Professional Key Global Microsoft Visio 2019 Professional Key Global - 5 PC
    Rated 4.93 out of 5
    $19.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Office 2024 Home And Business For Mac/Pc Bind Office 2024 Home And Business For Mac/Pc Bind $99.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Kaspersky Plus - 1 Device 1 Year - GLOBAL Kaspersky Plus - 1 Device 1 Year - GLOBAL $23.00
  • Microsoft Visio Professional 2016 Key 1PC Microsoft Visio Professional 2016 Key 1PC $9.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.