In this article:

How to Underline in Google Sheets [Easiest Way in 2024]

November 3, 2024

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.

How to Underline Text in Google Sheets

In this example we are going to demonstrate how to underline text in Google Sheets.

1. Double Click on the cell. Use the cursor to highlight the text

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).

Google Sheets underline text

2. In the Menu Bar, Click Format then Text and Underline 

Go to the menu bar and click Format, then from the dropdown click Text and Underline.

Where is underline in Google Sheets

3. The text is now underlined

The previously selected text has now been underlined.

In our example we can see the text “Third” in cell A7 is underlined.

How do I underline in Google Sheets

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: 

  • Windows press and hold Ctrl then press the U key

  • Mac press and hold Cmd ⌘ and then the U key 

How to Underline a Cell in Google Sheets

In this example we are going to demonstrate how to underline an entire cell in Google Sheets.

1. Click on the cell you want to underline 

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.

How to underline in Google Sheets

2. In the Toolbar click the Borders option then bottom borders

Click the Borders option in the toolbar and then in the dropdown options select the Bottom border icon.

Google Sheets underline text

3. The cell is now underlined 

The bottom border is applied and the cell is underlined.

In the example we can see that the cell A5 now displays an underline.

Google Sheets underline

How to Double Underline in Google Sheets

In this example we are going to demonstrate how to double underline in Google Sheets.

1. Select the Cell to Double Underline 

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”.

how to double underline in Google Sheets

2. Click the “Borders” option in the toolbar followed by the “Bottom border” icon.

From the toolbar click the Borders icon and from the drop down options click the Bottom border icon. 

How to double underline in Google Sheets

3. Click Border Styles and then Double Underline


Click on border styles, the last option in the dropdown will be double underline. Click this to apply the format. 

how to double underline in Google Sheets

4. The cell is now double underlined

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.

double underline Google Sheets

Other Google Sheets Formatting Articles

-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

 

-Google Sheets Dark Mode

 

-Add Line Break in Google Sheets

 

-Word Count 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.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->