How to Remove Underline in Google Sheets

Written by Tijana Google Workplace / Sheets

- 3 min read

How to Remove Underline in Google Sheets

While Google Sheets is a fantastic tool for data analysis, it is also employed for various other things due to its numerous features.

You can even use it as a text editor because it contains all the standard text formatting features.

By placing a line exactly beneath your text, the underlining text format option is a fantastic way to assist in highlighting your text. There are several ways to include it in your Google Sheets text data.

In a written sentence, key details and facts are highlighted by underlining.

There are many features available on Google Sheets, and each of those can be implemented to make any job or task easier.

When it comes to highlighting important sections of a document, underlining might be on top of the list. However, when a wrong cell was highlighted in your document, removing the underline formatting is the way to go.

Since removing the underline formatting is not as obviously placed in Google Sheets as it is in Google Docs, per se, it’s not uncommon for users to get confused.

In this article, we'll go over various types of underlining in Google Sheets, including how to create and remove them. Check out the steps below!

You might also like: How to Color Every Other Row in Google Sheets.

How to Remove Underline in Cells in Google Sheets

Removing underlines in Google Sheets cells can be done in two ways:

  • Using the Format tool
  • Using shortcut keys on your keyboard.

Check out the steps:

Remove underline with the Format tool

  1. Open the Sheet document, and select the cell with the underlined text.
  2. From the top menu, click on ‘Format’.
  3. From the drop-down menu, select ‘Text’.
  4. Another drop-down menu will open; click on ‘Underline’.

After finishing these steps, the underlined text in the cells will be removed.

Remove underline with keyboard shortcuts

  1. Open the Sheet document, and click on the underlined cell.
  2. Press Ctrl + U if you’re a Windows user, or Cmd + U if you’re a Mac user.

After finishing these steps, the underlined text in Google Sheets will be removed.

Remove gridlines in Google Sheets

If you want to go the extra mile and remove the gridlines altogether, you can do that too. Check out these steps:

  1. Open your Google Sheet, and click on ‘View’ from the top menu.
  2. From the drop-down, click on ‘Show’.
  3. A new drop-down will show up, find ‘Gridlines’, and uncheck the feature.

The selected range of cells will no longer have any lines.

Related: How to Add Subscript and Superscript in Google Sheets.

Conclusion

In Google Sheets, there are several ways to add and remove the underline format from your text.

With the Sheets app, you can even add underlining while using a mobile device, or even use cell borders to achieve the same appearance.

In this article, we covered removing underlines using the format tool, keyboard shortcuts, and removing gridlines altogether in Google Sheets.

If you liked this article, check out: How to Separate First and Last Name in Google Sheets and How to Double Underline in Google Docs (Two Methods).

Additional questions

How do I get rid of underlining?

To remove underlining in your Google Sheets document, select the underlined text, and press Ctrl + U for Windows, and Cmd + U for Mac.


The other way is to use the ‘Format’ feature - Format > Text > Underline.

Can you remove lines in Google Sheets?

Open your Google Sheet, and click on ‘View’ from the top menu. From the drop-down, click on ‘Gridlines’, and uncheck the box. The selected range of cells will no longer have any lines.

Where is the underline in Google Sheets?

Even though ‘Bold’ and ‘Italic’ formatting is visibly placed on Google Sheets, the ‘Underline’ feature is a bit hidden.


Click on ‘Format’ > ‘Text’ > ‘Underline’ to underline the text in your cell.