See all How-To Articles

How to Underline Text in Excel & Google Sheets

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

 

underline intro

 

There are plenty of options for formatting text in Excel. You can bold text, strikethrough, make superscripts and subscripts, etc. Read on for how to underline text in Excel.

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 is then 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 corner of the Font group (or press CTRL + SHIFT + 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. (You can also use bottom borders this way in Excel.)

  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

 

Your selected cell (or cells) now has a double-bottom border.

 

underline-gs double bottom border

See all How-To Articles