How to Underline in Google Sheets( Easy Guide )

In this tutorial, you will learn How to Underline in Google Sheets

To underline text in Google Sheets,Select the cell with text that you want to underline,Go to Format menu and Choose Text from the drop-down .Under Text menu drop-down you will get the options to Underline the text .Click on the Underline option

Format->Text>Underline

Let’s go through the steps in detail.

How to Underline in Google Sheets: Step by Step Guide

Enclosed are the steps to underline on your Google Sheets:

#How to Underline Specific Text in a Cell

To underline specific Text in a Cell in a Google Sheet follow the below steps :

Step 1: Open Google Sheet with the text that you want to underline.

Step 2: Choose the cell with the text that you want to underline.

How to Underline in Google Sheets

Step 3: Switch to Edit Mode

To start the Edit mode either you can use the F2 key shortcut or double-click on the cell with text.

Step 4: Now Choose the text in the cell that you want to Highlight.

Step 5: Now use the keyboard Shortcut CTRL+U to underline the text

#How to underline a specific cell or range of cells in Google Sheets.(Uderline using Bottom Border )

There might be a scenario where you need to underline a specific cell or range of cells in Google Sheets.

Follow the below steps to underline a specific cell or range in Google Sheets :

Step 1 : Open Google Sheet .

Step 2 : Choose the cell with text that you want to highlight.

  • Click on the Cell with the text that you want to Highlight.
  • Now press CTRL+A to select the text or use the mouse to Select the text

Step 3 : Click on the Borders button on the quick access menu bar.

Step 4: Choose Bottom border from the drop-down options

The Selected cell with the text will appear with bottom border and appear as if it underlined.

#How to Underline the entire text in a cell

Enclosed are the steps to underline the entire text in a cell ;

Step 1 : Open Google Sheet.

Step 2 : Select the cell with text that you want to Highlight.

Step 3 : Now Click on the Format menu on the Main menu bar.

Step 4 : Under Format menu ,Select Text->Underline.

  • Under Format menu choose Text from the available drop-down options.
  • Under Text Select Underline

Step 5 :Your Select cell or range of cell with text will be highlighted .

Other FAQs

How do I bold and underline in Google Sheets?

Follow the below steps to Bold and underline in Google Sheets.

1. Select the text that you want to Bold and underline in Google Sheets.
2.Now Click on the Fromat menu and Select Text
3.Under text you can select Bold,Ctrl + B to bold the text ,Underline Ctrl + U to underline the text and Italic Ctrl+I to italicize the text

How to Underline in Google Sheets(Summary)

In the above tutorial, we have provided you with various methods using which you can underline a specific text in Google Sheets.We hope this tutorial was helpful.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )