Menu
Select the text that you want to underline. On the Home tab, click the Font dialog box launcher. On Font tab, in the Underline or Underline style box, choose the double underline style. There is no easy way to make a double underline in Google Sheets. But there is a workaround to do it, if you can't or won't use Excel. The video encoding makes it look like a thick blurry line.
Excel provides both single and double underlining. It also provides special variants of each for numbers using Accounting format. Let's take a look. For most basic underlining, you can 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. For example, if you apply a double underline, the button will keep that selection until you select single underline again. Excel actually provides two more underline options for use with the Accounting number format.
You can't see these options on the ribbon, but in the Format Cells dialog box, you'll find them listed in the underline menu as 'Single Accounting' and 'Double Accounting' The accounting variants of underline options increase the row height a bit, and provide more space between the underline and the text. We can see this if we apply the different formats side by side.
Note that Excel will automatically apply the accounting version of underlining in cases where the selection contains only cells using the Accounting format. There's no indication that this has been done, but you can see the accounting version has been applied in the format cells dialog box. This doesn't happen with other number formats, or when the selection contains content in different formats. For example, if we apply underlining to cells in the currency format, Excel does not use the accounting version.
In fact, when the selection contains any format but Accounting, normal underlining will be applied. Finally, depending on your needs, keep in mind that applying a border on the bottom of cells is another way of underlining content in Excel. Unlike text underlining, cell borders run edge to edge across the entire cell. We'll look at borders more closely an upcoming lesson.
There are several different types of underlines you can use in Excel. Underlining of information within cells is handled by displaying the Home tab of the ribbon and, within the Cells group, clicking the down-arrow to the right of Format and choosing Format Cells. Excel displays the Format Cells dialog box; you should make sure the Font tab is visible. (See Figure 1.) Figure 1. The Font tab of the Format Cells dialog box.
In the Underline box, in the lower-left corner, you can select any of five different underline types. Underline Type Meaning None Removes any underlining from the cell contents. Single Adds a single underline, the width of the cell contents.
Double Adds a double-line underline, the width of the cell contents. Single Accounting Adds a single underline that is noticeably lower than the Single underline. In addition, the width of the underline extends the entire cell width if the cell contains text or dates. Double Accounting Adds a double-line underline that is noticeably lower than the Double underline. In addition, the width of the underline extends the entire cell width if the cell contains text or dates.