How to Underline and Double Underline in Google Sheets

Underline and Double Underline is a superlative option for highlighting a text or a cell for multiple users or for yourself when working on Google Sheet.

Highlighting the data that you find important in your work can easily be used underlined to help you in later tasks.

There are several ways you can access your Google Sheet Cells via underlining, for example, you can underline a whole cell or a specific text in a cell.

In this article, I will talk about how to add underline and double underline, remove underline and double underline your text in Google sheets using easy ways.

Let’s start!

How to add underline the entire text in a cell

You can apply to underline the entire text in a cell using following this step.

1. You must first select the cell of Google Sheet that you want to underline.

select the cell

2. You have to select the option in the “Format” of Google Sheet’s menu bar.

Click on Format

3. You will see many options within the format, select the “Text” option and select the “Underline” option within the ‘Text” option.

How to Underline and Double Underline in Google Sheets

4. Then you can see the underlining on the whole cell.

underlining is done

If you want to get back to the previous state, you can use the keyboard shortcut way “Ctrl +Z”.

Note: Shortcut way, Select the cell and press keyboard for underline in your Google sheets
Ctrl+U

How to add underline the entire text in multiple cells

  1. If you want to underline more than one cell, select that cell first and you can underline it in the same process above.
add underline the entire text in multiple cells

2. End results.

underline the entire text in multiple cells is done

Note: Shortcut way, Select part of the text on the cell and press keyboard for underline Ctrl+U

How to add underline specific text in a cell

  1. Select the text you want to underline the part of the text that you double-click.
  2. Press the keyboard for the part of the text in a cell underline (Ctrl +U).
add underline the part of the text in a cell

How to remove underline the entire text in a cell

Many times when the work is done you will need to remove the underline, then you can also follow the steps below.

  1. Select the cell that you have underlined, click on the “Format” option in the top menu bar.
  2. Hover over the “Text”, you will see the underline option.
  3. Click on the underline, the underline of the cell will be removed.
remove underline the entire text in a cell

End results.

remove underline the entire text in a cell is done

Note: Shortcut way, Select underline  the cell or part of the text  press keyboard for remove underline (Ctrl +U)

How to add Double Underline the entire text in a cell

Double underline is a great composition, newly added these features in Google sheets. Sometimes you have a need to add a double underline in your cell how to these features add to your Google sheet.

So you can follow the step.

  • Select the cell.
select the cell

Click on the “Borders” option at the top of your Google Sheets, select Double Borders and click on ” Bottom Borders”.

How to add Double Underline the entire text in a cell
  • And end results.
Double Underline the entire text in a cell is done

There are many options on the border, you can choose an option for your cell. Such as Right border, Left border, Top border, Horizontal border, Vertical border, etc.

How to remove Double Underline the entire text in a cell

If you want to remove the double underline in the cell, move the cursor to the “Border” option and click “Clear border” to clear the border.

remove Double Underline the entire text in a cell

Conclusion

In Google sheet’s underline and double underline, the formatting technique is very useful for finding your data easily. When working with a large set of data, you can easily use underline or double underline in your Google Sheets to find any data. The text draws the reader’s attention to highlight the text underlined.

Other Google Sheets tutorials articles you may find useful:

Was this article helpful?
YesNo


Related More Articles

Leave a Comment