How To Underline On Google Sheets

5 Ways to Add and Remove Underline Text in Google Sheets

This post is going to show you all the ways you can add or remove underlined text in Google Sheets.

Google Sheets is an amazing data analysis tool, but information technology is also used for many other tasks besides.

Information technology has all the usual text formatting features, so you tin can even utilize it as a text editor.

The underline format is a groovy option to assistance highlight your text past adding a line directly underneath. It can be added to your Google Sheets text data in a couple of different means.

In this mail, I'll evidence you all the ways you can add and remove underlining to your text.

Permit'southward have a look!

Add Underline Format to the Entire Text in a Cell

Y'all can add underline formatting to a single cell at a time or an unabridged range of cells in a couple of clicks.

To add the underline formatting follow these three steps.

1. Select the cell or range of cells to which you would like to add together underline formatting.
2. Go to the Format tab in the workbook menu.
3. Select Underline from the menu options.

Now all the text in all the selected cells will appear in an underlined format.

Keyboard Shortcut to Underline Text

If y'all prefer to use your keyboard in that location is a handy keyboard shortcut yous can use.

Select the cell or range of cells to underline, so press Ctrl + U on your keyboard.

This keyboard shortcut is a much quicker way than using the workbook menu and it's easy to retrieve. U stands for Underline.

Add Underline Format with the iOS or Android Mobile App

Are you lot are using your Google Canvas on a mobile device? Don't worry, you tin can yet underline your text!

You'll detect in the mobile Sheets app that bold, strikethrough, and font color icons appear on the bottom control bar, simply the underline icon is missing. You can access more text format options from the acme command bar.

Follow these steps to add together the underline format to your text using the Sheets mobile app.

1. Select the cells which you desire to add underlining.
2. Press the A with lines icon. This volition open upwardly more format options.
3. Select the Text tab then click on the underlined U icon.

Now all the text in the cells y'all had selected will accept a line underneath!

Add Underline to Function of the Text in a Cell

I but showed you how to underline all the text in a cell, just it is also possible to underline but office of the text inside a prison cell.

This is not bad if you want to emphasize one or two words in a larger bit of text.

To add the underline format to office of the text inside a jail cell follow these four steps.

1. Select the cell which contains the text you lot desire to underline.
2. The text will exist visible in the formula bar. Highlight the office of the text to which you want apply the underline format.
3. Press Ctrl + U on your keyboard.
4. Press Enter to accept the change and exit editing mode on the prison cell.

At present merely the part of the text you selected volition have the underline formatting.

Remove Underline Format Text

Clearing all formatting from your text will remove whatever underline format, only you may only want to remove the underline and continue all the other formats.

Removing any underlined format is just as easy equally calculation it. In fact, it's the same steps. The underline commands act as a toggle and will remove the format if it is already applied and add the format if it is not already applied.

To remove any underline format follow these steps.

1. Select the prison cell or range of cells which y'all want to remove formatting from.
2. Become to the Format tab in the menu.
3. Click on Underline from the menu options.

You can also use the keyboard shortcut to remove the underline format instead.

1. Select the cells you want to remove underlines from.
2. Press Ctrl + U on the keyboard.

Note: If the selected cells contain a partial underline formatting, then you will need to repeat this a 2d time. This is because the starting time fourth dimension, Sheets will use underline format to all the parts which don't have it. And then the second time volition remove all underline format.

Add a Lesser Border to a Cell

Another option that can give a like outcome as calculation underline format is to add together a bottom border to the prison cell which contains the text.

Equally long as your text stays on one line, this bottom edge volition look very similar to the underline format.

This outcome is even better when you lot remove the gridlines from the worksheet then the bottom border is more prominent.

Select the cell you want to add a bottom edge to ➜ click on the filigree icon in the command bar ➜ select the Bottom border option.

You tin meet the resulting line will extend the entire width of the cell and not merely the width of the text inside the cell. In comparison, the cells with the underlined format will simply show a line the same width as the text.

This will also exist noticeable when a cell is formatted with wrapped text. Only the bottom wrapped text will announced to be underlined with the edge.

Yet, this might be the verbal style yous are looking for.

Conclusions

At that place are multiple ways to add and remove the underline format to your text in Google Sheets.

You can fifty-fifty add underlining from your mobile device with the Sheets app.

You can fifty-fifty get the same await with jail cell borders.

Did you know all these? Practise you know a method that's not in the post? Let me know about it in the comments beneath!

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps, and SharePoint. You lot tin can find other interesting manufactures from John on his blog or YouTube channel.

Source: https://www.oksheets.com/underline-format/

Share this post