In this article we will show you how to underline in Google Sheets. We cover how to underline and double underline text. Simply follow the steps below:
For the purpose of these demonstrations an example data set has been created, access and follow along by clicking this link.
In this example we are going to demonstrate how to underline text in Google Sheets.
Double click on the cell containing text that you want to underline the value of. Use the cursor to highlight some or all of the text to underline . This will also work with numerical values.
In our example we will underline the text value “Third” located in row 7. For this we will highlight the entire text value (third).
Go to the menu bar and click Format, then from the dropdown click Text and Underline.
The previously selected text has now been underlined.
In our example we can see the text “Third” in cell A7 is underlined.
The menu method will only highlight the entirety of the cell value
To highlight partial text or numerical values you must first select, drag and highlight how much of the value you want to highlight then use keyboard shortcuts:
In this example we are going to demonstrate how to underline an entire cell in Google Sheets.
Select the cell you want to underline. For multiple cells click and hold down the left mouse button and drag the cursor to highlight as many cells as you need.
For this example we will underline the cell A5. We begin by clicking to highlight it.
Click the Borders option in the toolbar and then in the dropdown options select the Bottom border icon.
The bottom border is applied and the cell is underlined.
In the example we can see that the cell A5 now displays an underline.
In this example we are going to demonstrate how to double underline in Google Sheets.
Click on the cell you want to double underline.
In the example we will apply double underline to cell C4 containing the text “double underline”.
From the toolbar click the Borders icon and from the drop down options click the Bottom border icon.
Click on border styles, the last option in the dropdown will be double underline. Click this to apply the format.
The double underline has now been applied to the cell.
In our example we can see that the cell C4 has had the double underline applied.
-How to Strikethrough in Google Sheets
-How to Remove Gridlines in Google Sheets
-Make a Button in Google Sheets
-How to Hyperlink in Google Sheets
-How to Add Bullet Points in Google Sheets
-How to Indent in Google Sheets
-Add Line Break in Google Sheets
-Color Every Other Row in Google Sheets
We hope this article has helped you and given you a better understanding of how to underline in Google Sheets. You might also like our articles on how to indent in Google Sheets and how to strikethrough on Google Sheets.
To optimize your workflow, we recommend reading our guide on how to use the address book template in Google Sheets and trying our software for tracking due date reminders.