How to Underline in Google Sheets

Simple formatting tricks can sometimes make your data much easier to read and understand.

While Google Sheets offers a variety of formatting options (such as coloring the cell or the text, bolding or italicizing the text, or altering the font style or size), underlining the text is one of the most popular.

Although Google Sheets is a fantastic tool for data analysis, it is also employed for various other purposes.

You may 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 format is a fantastic way to highlight important segments in your text.

There are several ways to include it in your Google Sheets text data.

You have the option of underlining the full cell or only a portion of the text.

This article will demonstrate all the options for adding or deleting underlined text in Google Sheets.

Related: How to Separate First and Last Name in Google Sheets.

How do I underline text in Google Sheets?

Underline the entire text in a cell

1. Select the one cell you need to underline the text in.
2. From the top menu, click on ‘Format’.
3. From the drop-down menu, click on the ‘Underline’ option.

After finishing these steps, your entire cell will be underlined. To undo the underlining, press Ctrl / Cmd + Z, or repeat the steps mentioned above.

Underline specific text in a cell

In instances when you don’t need to underline the cell, but just a part of it, follow these steps:

1. Select the cell you want to underline text from.
2. Double-click on the cell to open the ‘Editing’ option.
3. Select the text you wish to underline from the cell, click on ‘Format’ again, and click on ‘Underline’ from the drop-down menu.

Underline the cell (range of cells)

If you don’t want to underline the text or a part of the text, you can underline the entire cell.

Follow these steps:

1. Select the cell you want to underline (if you select a range of cells, only the bottom cells will be underlined).
2. Click on the ‘Borders’ icon from the toolbar, and click on the bottom border option.
3. To double-underline the cell, click on ‘Border Styling Options’ and click on the double border.
4. To double-underline multiple cells from a column, choose ‘Horizontal Border’.

You might also like: How to Remove Gridlines in Google Sheets.

Conclusion

To underline cells in Google Sheets, you can follow the steps above, either use a keyboard shortcut or add a border to a cell.

These options can be used on single cells and multiple cells from a column.

If you liked this article, check out: How to Color Every Other Row in Google Sheets and How to Add Subscript and Superscript in Google Sheets.