How to use underline styles in Excel

The underlined text format is too familiar to office users, in Word and Excel when we want to emphasize or highlight certain content to readers. Often, the underlined format will appear on the menu interface so you can use it immediately. However, many other underlined styles have been hidden on the Excel interface.

We can choose the type of double underline, or adjust the underline length equivalent to the length of the content ,, . So how to use the underlined formatting in Excel has been hidden? The following article will guide you how to use the underlined format in Excel.

1. How to write dash in Word and Excel
2. Change the slash to a dot in Excel format
3. A guide to the full Excel 2016 (Part 12): Page formatting and spreadsheet printing

Instructions for using Excel underlined format

Step 1:

At the Excel table interface, select the content you want to use underlined format, then click the Home tab and then select the Font setting group. Click on the arrow icon .

How to use underline styles in Excel Picture 1

Step 2:

The Format Cells dialog box appears at the Font tab, then click on the Underline section to use the underlined format under the content. Note, you can press Ctrl + 1 to quickly open the Format Cells dialog box.

How to use underline styles in Excel Picture 2

A list of 5 underlined format appears for users to choose. Each underlined format will be different and the target will be different.

1. None: do not use underline, remove underlined content.
2. Single: create 1 underline under the content, extending along the cell contents.
3. Double: create 2 underlining under the content, extending along the cell contents.
4. Single Accounting: create an underscore similar to Single, but the distance between the text and the underscore will be farther than Single. The length of the underscore is equal to the length of the cell contents.
5. Double Accounting: create 2 smaller underscores than Double type. The cell length will also extend with the content in the cell.

How to use underline styles in Excel Picture 3

Single Accounting and Double Accounting format underline formats will be used in book statistics, especially for accounting. Single Accounting is used to mark subtotal and Double Accounting is used to mark the final total (Final Total).

Depending on what type of document needs to be processed in Excel, as well as the content in the document we choose to underline accordingly. For the types of financial reporting documents, accounting documents will use the type of underscore underline with larger letters.

See more:

1. How to combine 2 columns Full name in Excel does not lose content
2. How to create a password protection for Excel sheets
3. These are the most basic functions in Excel that you need to understand

Hope this article is useful to you!