How to apply different underline options in Excel

Abstract

Excel provides both single and double underlining.

It also provides a special variant of each for numbers using the Accounting format.

Let’s take a look.

For most basic underlining, you’re free to just use the Underline button on the ribbon.

The Underline button toggles underlining on and off.

It also provides a menu for selecting single and double-underlining.

The Underline button remembers your last selection.

Excel actually provides two more underline options for use with the Accounting number format.

We can see this if we apply the different formats side by side.

This doesn’t happen with other number formats or when the selection contains content in different formats.

In fact, when the selection contains any format but Accounting, normal underlining will be applied.

Unlike text underlining, cell borders run edge to edge across the entire cell.

We’ll look at borders more closely in an upcoming lesson.