How To Add And Remove Underline In Google Sheets[Guide 2022]

Written by Abid Akon

Here's what we'll cover:

An underline is a line drawn under a word or phrase to emphasize and draw attention to the words. Underlines are used to show important details and facts in a written sentence. 

Here, we are going to discuss how to add and remove underlines in different ways and types in Google sheets.

How to Underline the Entire Text in a Cell in Google sheets.

If you want to underline an entire text in a cell, you would follow the steps below.

Step 1: Select the cell you want to underline.

1 How To Add And Remove Underline In Google Sheets

Step 2: Click on the Format icon on the toolbar.

2 How To Add And Remove Underline In Google Sheets

Step 3: Click on Text.

Step 4: Select the Underline option.

3 How To Add And Remove Underline In Google Sheets

Step 5: The text in the selected cell becomes automatically underlined as seen below.

4 How To Add And Remove Underline In Google Sheets

There is also an easy shortcut for those working on their laptops and computers.

●      Select the cell that has the text you want to underline.

●      Press the Ctrl key + U

●      The text in the cell becomes underlined automatically.

How to Underline a Specific Text in a Cell in google sheets.

In a case where you have multiple words in a cell, for example, Happy New Year and you want to underline only one word in the text, you would have to follow the steps taken below.

Step 1: Select the cell that has the group of words.

5 How To Add And Remove Underline In Google Sheets

Step 2: Double click on the cell or press the F2 key on your keyboard to edit the cell.

Step 3: Select the word you want to underline.

6 How To Add And Remove Underline In Google Sheets

Step 4: Click on the Format icon on the toolbar.

7 How To Add And Remove Underline In Google Sheets

Step 5: Click on Text.

Step 6: Select Underline.

08 How To Add And Remove Underline In Google Sheets

 The selected word becomes underlined as seen below.

09 How To Add And Remove Underline In Google Sheets

How to Underline All Cells in a Column or Range of Cells.

When there are multiple cells in a column and you want to underline them, you follow the steps listed below.

Step 1: Select the range of cells you want to underline.

010 How To Add And Remove Underline In Google Sheets

Step 2: Click on the Border icon in the toolbar.2

011 How To Add And Remove Underline In Google Sheets

Step 3: Select the Bottom Border icon.

012 How To Add And Remove Underline In Google Sheets

Step 4: The selected range of cells becomes underlined.

013 How To Add And Remove Underline In Google Sheets

How to Remove Underline in Cells in Google Sheets

There are two ways in which you can remove underline in cells.

●      Using the Format tool.

●      Using the shortcut keys on the keyboard.

Using the Format tool:

1. Select the underlined cell. 

014 How To Add And Remove Underline In Google Sheets

2. Click on the Format icon in the toolbar.

015 How To Add And Remove Underline In Google Sheets

3. Click on Text.

4. Select Underline.

016 How To Add And Remove Underline In Google Sheets

 5. The underline in the cell is removed. 

017 How To Add And Remove Underline In Google Sheets

Using the shortcut:

  1. Select the underlined cell.
  2. Press the Ctrl key + U on the keyboard.
  3. The underline in the cell is removed.

How to Double Underline in Google Sheets.

Double underlines are used to outline the total sum of data in a range of cells. There are two ways double underlines are created in Google sheets.

  1. Using the border method
  2. Changing the border style.

Method 1: Using the border method.

Step 1: Select an empty row on top of the total sum.

018 How To Add And Remove Underline In Google Sheets

Step 2: Click on the border icon here.

019 How To Add And Remove Underline In Google Sheets

Step 3: Select the bottom border icon.

020 How To Add And Remove Underline In Google Sheets

The selected cell becomes underlined at the bottom of the row here.

021 How To Add And Remove Underline In Google Sheets

Step 4: Select the cell above the empty cell, that is, B6.

022 How To Add And Remove Underline In Google Sheets

Step 5: Click on the border icon.

023 How To Add And Remove Underline In Google Sheets

Step 6: Click on the bottom border icon.

024 How To Add And Remove Underline In Google Sheets

Step 7: An underline is created in cell B6. It looks like a double underline but the lines are far apart.

025 How To Add And Remove Underline In Google Sheets

Step 8: Click on the line below the cell number.

26 How To Add And Remove Underline In Google Sheets

Step 9: Drag down to reduce the space in between the lines.

27 How To Add And Remove Underline In Google Sheets

Step 10: This produces a result as seen below.

28 How To Add And Remove Underline In Google Sheets

Although it has a disadvantage where additional data cannot be added to the reduced cell. It accomplishes its purpose as a double underline.

Method 2: Changing the Border style.

Step 1: Select the cell you want to underline.

29 How To Add And Remove Underline In Google Sheets

Step 2: Click on the border icon.

30 How To Add And Remove Underline In Google Sheets

Step 3: Click on the bottom border icon.

31 How To Add And Remove Underline In Google Sheets

Step 4: Click on the border style icon

32 How To Add And Remove Underline In Google Sheets

Step 5: Click on the double underline icon.

33 How To Add And Remove Underline In Google Sheets

The selected cell has a double underline in the text.

34 How To Add And Remove Underline In Google Sheets

Final Thoughts:

With the topics, steps and methods listed above, underlining in Google sheets is easier to understand and practice. I hope you found this tutorial helpful. Thank you.

Abid Akon

Abid Akon

I am a tech content writer. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I am writing articles to share my tech knowledge with you.

Related Articles

MD Abid Akon

Abid Akon

Hi, I am Abid. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I’ve created this website to share my technology keeping knowledge with you. Welcome to ”abidakon.com”

Abid Akon

My Personal Favorites
YouTube Channel