See all How-To Articles

How to Underline Text in Excel & Google Sheets

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

 

underline intro

 

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).

 

underline ribbon

 

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.

 

underline double

 

The text will then be double underlined.

 

underline double underline

 

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).

 

underline font

 

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

 

underline accounting

 

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

 

underline accounting table

 

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).

 

underline gs underline

 

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.

 

underline gs select border type

 

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

 

underline gs bottomborder

 

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

 

underline-gs double bottom border