In this article:

How to Underline in Google Sheets [Easiest Way in 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 and trying our software for tracking due date reminders.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started