Sometimes, simple formatting techniques can make your data a lot more easy to read and consume.
While there are many types of formatting options available (such as coloring the cell or the text, making the text bold or italics, changing the font style or size), one that is often used is underlining the text in Google Sheets.
You can underline the entire cell or can choose to underline a part of the text in a cell.
In this tutorial, I will show you some simple methods to underline in Google Sheets.
So let’s get started!
Underline the entire text in a cell
If you want to underline the entire text in a cell, you can do that using the below steps:
- Select the cell that you want to underline (or a range of cells)
- Click the Format option in the menu
- Click on the ‘Underline’ option
The above steps would automatically underline the entire text in the cell (or the range of cells) that you have selected.
If you want to undo this change, either repeat the same steps or use the keyboard shortcut Control + Z
Underline Specific Text in a Cell
If you don’t want to underline the whole cell but only a part of the text, you can do that as well.
Suppose you have the text “Hello World” in a cell and you only want to underline the word “Hello”
Below are the steps to do this:
- Select the cell that has the text that you want to underline
- Double-click on the cell (or press F2) to get into the edit mode
- Select the text that you want to underline in the cell
- Click the Format option and then click on Underline (or use the keyboard shortcut Control + U)
The above steps would underline the selected text in the cell.
Underline the Cell (or range of cells)
In some cases, you may not want to underline the text but the entire cell.
This is often the case when presenting the sum of a column (or any other such calculation) and show some difference between the data and the cell that has the calculation.
Below are the steps to underline a single cell
- Select the cell that you want to underline (in case you select a range of cells, only the bottom ones would be underlined)
- Click the borders icon in the toolbar
- Click on the bottom border option
This would give a bottom border to the cell, which looks as if you have underlined the cell.
In case you want a double-underline, you can click on the ‘Border style’ option and then click on the double border option.
If you want to select a range of cells in a column and give all the cells a bottom-border, choose the ‘Horizontal border’ option in the Border options in the toolbar.
So these are some ways you can use to underline text in a cell or the cell itself.
I hope you found this tutorial useful!
Other Google Sheets tutorials you may find useful: