How To Underline In Google Sheets (Step By Step Guide)

Underlining text in Google Sheets is SOOO easy that it only takes about a second to do it! Just select the cell and press CTRL+U. That’s all!

In this guide, I will give you a quick rundown of how to underline text in google sheets using 3 methods. Plus, I’ll also walk you through how to double underline, underline parts of the text and even whole rows in Google Sheets.

3 Ways To Underline Text In Google Sheets

Let’s take a look at all the ways we can underline text in Google Sheets:

Underline Text In Google Sheets Using The Keyboard Shortcut

That’s pretty much the fastest way to underline in Google Sheets. Select the cell you want to underline, and simply press CTRL + U on Windows or CMD + U on Mac.

Fun fact: These shortcut keys (or hotkeys) to underline are the same across all Google Workspace and Microsoft Office products.

Underline Text Using The Options Menu

The screenshot highlights the steps required to underline a text from the Options menu.

To underline text in google sheets using the underline feature in the options menu, you need to:

  1. Select the Cell
  2. Click Format on the options menu
  3. Hover down to the Text menu (#3)
  4. Click on Underline

Tada! You just underlined the cell.

Underline Only Part Of The Text In A Cell

To underline a part of the text in a cell in google sheets, you need to select the cell you want to edit, and then Double-click on the cell. Or you could press F2 on your keyboard which will also take you into edit mode

Now you need to select the part of the text you want to underline. Next, press CTRL/CMD + U.

It’s also important to note that we cannot do it through the options menu because when we click Format, the edit mode on the cell goes away and the entire cell gets selected instead.

How To Underline A Whole Row In Google Sheets

Let’s take a quick look at two ways how to underline entire rows: 

Underline By Selecting The Whole Row

The gif shows user selecting entire row number 1 and applying underline styling automatically to to all entries

To underline a whole row of cells in Google Sheets, you need to first select the row or the rows that you want to underline. 

Then head on to the Format on the Options menu, and click on Underline that’s under the text menu. 

Or you can just select the rows and hit Ctrl / CMD + U on your keyboard.

Add A Bottom Border That Will Fake Underline

Arrow points on the bottom border icon

You can also “fake” underline entire rows using cell borders. To do this, select the rows like before and then click on the Border Icon on the toolbar.

You will see a lot of border types there, and you need to select the bottom border which is essentially a square icon that only has a bottom line.

How To Double Underline In Google Sheets

The only way to double-underline is by using borders. To double underline a cell or multiple cells in google sheets, you need to:

  1. Select the cell or multiple cells or the entire row you want double underlined.
  2. Click on the Border Icon on the toolbar and select the bottom border.
  3. Next click on the Border Style which is the last option in the border menu.
  4. Click the double line
There are two arrows on the screenshot. The first arrow shows which icon to click to change border styling, and the second arrow is pointing to the double-border style (its the one on the very bottom)

How To Remove Underline In Google Sheets

Removing an underline in a cell or multiple cells in google sheets is the same as underlining cells.

Select the underlined cells and go to the options menu – Text and click on underline. Or just press CTRL U and the underline will be removed from the selected cells.

How To Underline In Google Sheets Mobile App (iPhone, Ipad, Android)

Just like in the desktop version, to underline text in Google Sheets App:

Step 1: Select the cell, cells, or text

Step 2: Tap on the Text Formatting icon

The arrow on the screenshot points to the text formatting icon in the Google Sheets mobile app

Step 3: And then tap Underline

The arrow on the screenshot points to icon that toggles underline styles for the text

Some Questions You May Have (FAQs)

How Do I Stop Underlining In Google Sheets?

When underlining a cell once, it will keep underling even if you delete the text that was there. To stop underlining in Google Sheets, select this cell and press CTRL + Z. 

How To Do Accounting Underline In Google Sheets?

To do an accounting underline in Google sheets, you need to select the cell and set a bottom border from the toolbar. Next, select the border style and set double lines.

How Do You Underline In Google Sheets Without A Mouse?

Once the document loads you press TAB to get the cell selector inside the sheet. Next, move around the cells using the arrow keys and go to the cell you want to underline. Once you are there, press CTRL + U.

How To Underline text in Google Sheets using the Toolbar

Unfortunately, unlike MS Excel or Google Docs, Google Sheets does not have an underline shortcut on the toolbar. So you cannot use the toolbar for underlining.

My Final Thoughts

Underlining text in google sheets is easy and straightforward. You can do it using the options menu or just by pressing CTRL + U.

You can also create double underline in a cell or multiple cells in google sheets using borders.

Now that you know how to underline in google sheets, why not give it a try and see for yourself?

Leave a Reply

Your email address will not be published. Required fields are marked *