How to Underline Text in Excel & Google Sheets

This tutorial will demonstrate how to underline text in Excel and Google Sheets.

 

 

Single Underline

1. First, click in the single cell, or Select the range of cells you wish to underline.
2. Then, in the Ribbon, select Home > Font > Underline (or press CTRL + U on the keyboard).

 

 

The text is now underlined.

You can click on the Underline icon or press CTRL + U to switch the underline off again, as they are toggle commands.

Double Underline

1. First, click in the single cell, or select the range of cells you wish to underline.
2. Then, in the Ribbon, select Home > Font and then select Double Underline from the Underline drop down list.

 

 

The text will then be double underlined.

 

 

Accounting Underline

Accounting underlining differs from normal underlining in that it extends across most of the cell, not just the existing text or data.

1. First, click in the single cell, or select the range of cells you wish to underline.
2. Then, in the Ribbon, select Home > Font and then select the small icon in the bottom right hand corner of the font group (or press SHIFT + CTRL + F on the keyboard).

 

 

3. In the Format Cells Dialog box, select Single Accounting or Double Accounting and then click OK.

 

 

A single or double accounting underline extends across most of the selected cell.

 

 

Underline Text in Google Sheets

1. First, click in the single cell, or select the range of cells you wish to underline.
2. Then, in the menu, select Format > Text > Underline (or press CTRL + U on the keyboard).

 

 

Your text is then underlined.

Double Underline

Google does not support double or accounting underline, but you can double underline a cell, by inserting a bottom border.

1. In the Toolbar, select Borders, then select the double line from the Border Style drop down list.

 

 

2. Click on the Bottom border icon to set a border for the selected cell or range of cells.

 

 

You selected cell or cells will now have a double-bottom border.