How to remove hyperlink in Google sheets?

Removing Hyperlinks in Google Sheets: A Step-by-Step Guide

Are you tired of seeing hyperlinks in your Google Sheets? Whether it’s for formatting or for tracking links, hyperlinks can be a real pain to deal with. In this article, we’ll show you how to remove hyperlinks in Google Sheets and make your spreadsheets more organized and efficient.

Step 1: Understand the Problem

Before we dive into the solution, let’s take a closer look at what hyperlinks are and why they’re problematic. Hyperlinks are clickable links that can be used to share content, drive traffic, or send messages. In Google Sheets, hyperlinks are often created using the Insert menu or by typing a URL directly into the cell. However, some users may not want to see these links in their spreadsheets, and that’s where the issue comes in.

Step 2: Identify the Type of Hyperlink

There are several types of hyperlinks in Google Sheets, including:

• New window: A new window opens when you click on a hyperlink.
• Background image: A background image is displayed when you click on a hyperlink.
• URL: A website is opened in your default web browser when you click on a hyperlink.
• External link: A hyperlink to an external website is opened in your default web browser.

To remove hyperlinks, we’ll focus on removing the URL type of hyperlink.

Step 3: Remove Hyperlinks

To remove hyperlinks from a Google Sheet, you can use a combination of formatting and conditional formatting techniques. Here’s how:

Step 3.1: Format the Cell

• Select the cell that contains the hyperlink.
• Right-click on the cell and select Format Cells.
• In the Format Cells dialog box, click on the Editing format tab.
• In the Selection section, click on the dropdown menu next to Cell reference and select $R1C1 (or any other format you prefer).
• Google Sheets automatically removes hyperlinks when you format a cell.

Step 3.2: Conditional Formatting

To remove hyperlinks when the format of a cell changes, you can use conditional formatting:

• Select the cell that contains the hyperlink.
• Go to the Conditional formatting tab.
• In the Format cells if section, select Format only if.
• In the Format cells dropdown menu, select the format you prefer.
• In the Format section, select Hanging (or any other format you prefer).
• Google Sheets automatically removes hyperlinks when the format of a cell changes.

Step 4: Remove Hyperlinks from Multiple Cells

If you have a large number of cells with hyperlinks, you can remove them all at once using the following steps:

Step 4.1: Select Multiple Cells

• Select the cells that contain hyperlinks.
• Go to the Editor tab.
• In the Environment section, click on the dropdown menu next to Subtasks and select Remove hyperlinks.

Step 4.2: Remove Hyperlinks from All Cells

Alternatively, you can use the following method:

• Select the first cell that contains a hyperlink.
• Go to the Format cells tab.
• In the Editing format section, click on the dropdown menu next to Hanging and select Remove.
• Repeat this process for each cell that contains a hyperlink.

Additional Tips and Variations

• Web Page URL: If you want to remove hyperlinks from specific web pages, you can use the following code: =URL("https://www.example.com"). Replace https://www.example.com with the URL of the website you want to remove hyperlinks from.
• External Links: If you want to remove external links, you can use the following code: =IF(Request("https://www.example.com")="text"). Replace https://www.example.com with the URL of the website you want to remove external links from.
• Defer Execution: If you want to remove hyperlinks when you perform a specific action, such as formatting a cell, you can use the following code: =IF(FORMATTING("#(tab="$(e1)&"r11")", "red")>0,FORMATTING("#(tab="$(e1)&"r11")", "red")#, "red") Replace $(e1)&"r11" with the cell number and column letter that contains the hyperlink.

Conclusion

Removing hyperlinks from Google Sheets is a straightforward process that can be completed using a combination of formatting and conditional formatting techniques. By following the steps outlined in this article, you can eliminate hyperlinks from your spreadsheets and make them more organized and efficient. Remember to use the Conditional formatting method to remove hyperlinks when the format of a cell changes, and consider using the Web Page URL code to remove hyperlinks from specific web pages. With these tips and variations, you’ll be able to master the art of removing hyperlinks in Google Sheets!