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](https://abidakon.com/wp-content/uploads/2022/04/1-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 2: Click on the Format icon on the toolbar.
![2 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/2-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 3: Click on Text.
Step 4: Select the Underline option.
![3 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/3-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 5: The text in the selected cell becomes automatically underlined as seen below.
![4 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/4-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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](https://abidakon.com/wp-content/uploads/2022/04/5-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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](https://abidakon.com/wp-content/uploads/2022/04/6-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 4: Click on the Format icon on the toolbar.
![7 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/7-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 5: Click on Text.
Step 6: Select Underline.
![08 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/08-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
The selected word becomes underlined as seen below.
![09 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/09-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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](https://abidakon.com/wp-content/uploads/2022/04/010-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 2: Click on the Border icon in the toolbar.2
![011 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/011-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 3: Select the Bottom Border icon.
![012 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/012-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 4: The selected range of cells becomes underlined.
![013 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/013-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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](https://abidakon.com/wp-content/uploads/2022/04/014-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
2. Click on the Format icon in the toolbar.
![015 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/015-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
3. Click on Text.
4. Select Underline.
![016 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/016-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
5. The underline in the cell is removed.
![017 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/017-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Using the shortcut:
- Select the underlined cell.
- Press the Ctrl key + U on the keyboard.
- 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.
- Using the border method
- 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](https://abidakon.com/wp-content/uploads/2022/04/018-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 2: Click on the border icon here.
![019 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/019-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 3: Select the bottom border icon.
![020 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/020-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
The selected cell becomes underlined at the bottom of the row here.
![021 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/021-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 4: Select the cell above the empty cell, that is, B6.
![022 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/022-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 5: Click on the border icon.
![023 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/023-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 6: Click on the bottom border icon.
![024 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/024-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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](https://abidakon.com/wp-content/uploads/2022/04/025-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 8: Click on the line below the cell number.
![26 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/26-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 9: Drag down to reduce the space in between the lines.
![27 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/27-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 10: This produces a result as seen below.
![28 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/28-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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](https://abidakon.com/wp-content/uploads/2022/04/29-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 2: Click on the border icon.
![30 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/30-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 3: Click on the bottom border icon.
![31 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/31-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 4: Click on the border style icon
![32 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/32-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
Step 5: Click on the double underline icon.
![33 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/33-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
The selected cell has a double underline in the text.
![34 How To Add And Remove Underline In Google Sheets](https://abidakon.com/wp-content/uploads/2022/04/34-How-To-Add-And-Remove-Underline-In-Google-Sheets.jpg)
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.