How to☝️ Remove Underline in Google Sheets

To remove an underline in Google Sheets, select the text with the underline and press the Ctrl + U keys combination on Windows (or Cmd + U on Mac) simultaneously. 

This will eliminate the underline from the text. Let’s take a deeper look at the process together.

In this article, you will learn various methods to remove an underline in Google Sheets in just a few seconds. 

How to Remove the Underline from All or Part of the Text within a Cell

Underlining is an important part of the writing process since it allows the reader to easily identify the main details in the text. Sometimes, however, you may need to remove the underline from a text.

Take a look at the steps below to learn how it can be done quickly and easily.

Step 1: Firstly, double-click on the cell with underlined text. This will insert the cursor into the text itself.

Step 2: Secondly, select all the text within the cell or select the particular part of the text that you need to change (the part that is underlined).

Step 3: Finally, press the Ctrl + U keys combination on Windows (or Cmd + U on Mac) simultaneously to remove the underline.

How to Remove the Underline from All or Part of the Text within a Cell

Here is the result:

Text within a Cell

How to Remove the Underline from an Entire Cell, Multiple Cells, Rows, or Columns

It is possible to remove the underline from an entire cell, multiple cells, rows, or columns using the method described above, or alternatively, by following the steps below:

Step 1: Select the cell or cells with the text you need to format.

Step 2: Click on the Format menu.

Step 3: Select the Text option.

Step 4: Choose Underline to remove the underline from the text.

How to Remove the Underline from an Entire Cell, Multiple Cells, Rows, or Columns

Check out the result below:

Text in a Cell

How to Remove the Underline from an Entire Spreadsheet

When you have text spread throughout your worksheet and you need to format it all at once, use the process provided below to save time and avoid having to format each cell individually.

Step 1: Click on the dark gray bar in the upper left corner of the sheet to select the entire sheet. 

Step 2: Press the Ctrl + U keys on Windows on your keyboard (or Cmd + U on Mac).

How to Remove the Underline from a

Just like that, any underlines in the text on your worksheet will be removed. Your result will look something like this:

Removed the Underline from a Spreadsheet

How to Remove the Underline from a Hyperlink or Email Address

When you have text that contains hyperlinks or email addresses, Google Sheets will automatically include an underline to indicate that the text has been linked. You can easily remove the underline without removing the link itself from the text. 

You can use either of the two methods described above (using the shortcuts Ctrl + U for Windows or Cmd + U for Mac or the Format menu) to take care of this task easily. Just pick the method you like the most.

How to Remove the Underline on a Mobile Device

Here’s what to do if you are working with spreadsheets from a mobile device and you want to remove an underline:

Step 1: Click on the cell with the underlined text to select it. 

Selected Cell

Step 2: Press the Underline icon to open the settings.

How to Remove the Underline on a Mobile Device

Step 3: Select Underline to remove it from the selected text.

Underline on a Mobile Device

Here is the result:

Text in a Cell in Google Sheets

Removing the Underline in Google Sheets: FAQs

This section will answer some questions that you may have regarding underlining text in Google Sheets, so please read on if you want to know more!

Is there a shortcut to remove the underline in Google Sheets?

Yes, you can use the Ctrl + U (on Windows) or Cmd + U (on Mac) shortcuts as described in the above article. This provides you with a quick and easy method to remove underlines from your text. 

The Ctrl + Z key combination for Windows or Cmd + Z for Mac will undo the previous action, and this can be useful, too.

What should I do if Google Sheets won’t let me undo an underline?

There are times when you cannot remove the underline from the text. There may be a problem with the worksheet being protected or a particular cell being locked. If this is the case, you will need to gain access to edit the sheet or unlock the cell.

If this is not the case, make sure you have a good Internet connection and try reloading the Google Sheets page. At that point, you should be able to remove the underline as normal.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X