Written by Tijana Google Workplace / 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.
After finishing these steps, your entire cell will be underlined. To undo the underlining, press Ctrl / Cmd + Z, or repeat the steps mentioned above.
In instances when you don’t need to underline the cell, but just a part of it, follow these steps:
If you don’t want to underline the text or a part of the text, you can underline the entire cell.
Follow these steps:
You might also like: How to Remove Gridlines in Google Sheets.
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.