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.
- How to write dash in Word and Excel
- Change the slash to a dot in Excel format
- 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 .
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.
A list of 5 underlined format appears for users to choose. Each underlined format will be different and the target will be different.
- None: do not use underline, remove underlined content.
- Single: create 1 underline under the content, extending along the cell contents.
- Double: create 2 underlining under the content, extending along the cell contents.
- 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.
- Double Accounting: create 2 smaller underscores than Double type. The cell length will also extend with the content in the cell.
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:
- How to combine 2 columns Full name in Excel does not lose content
- How to create a password protection for Excel sheets
- These are the most basic functions in Excel that you need to understand
Hope this article is useful to you!
You should read it
- How to delete table format in Excel
- Instructions on how to fix reverse dates in Excel
- How to convert money into words in Excel, without an add-in, supports both 32-bit and 64-bit Excel
- How to arrange incremental dates in Excel
- How to display 0 in front of a number in Excel
- Microsoft Excel test P5
- Tips for adding in Excel you need to know
- How to use Style in Excel
May be interested
- How to underline the broken word on Wordinstead of the underlined style under regular text, users can underline the broken character on word.
- How to remove the underline, delete the red brick, blue brick under the word in Wordremoving red underscores and underlining under the text in word 20126, 2013, 2010, 2007 will help your text look glimpsed and less distracting when reading. this is part of word's spell-check feature, which wants to remove that red-green dashboard.
- Underline in Wordwhen we work with text to emphasize or highlight to make it easier to identify, we will certainly use the underlined or italicized tool. word supports many different types of underlining and can be customized to suit the needs of the individual user.
- How to copy styles between 2 Word files (Import, import styles from the old word file to the new file)the following article shows you how to copy styles between 2 word files (import / import styles from old word files to new files) to save you time when working when creating new documents. for example, you need to copy existing styles that users have made available from f
- How to remove the red underline and save text automatically in Wordintroduce to you how to remove the red underline and how to save text automatically in word quickly and efficiently.
- How to Use Styles in Microsoft Word to Format Documents Consistentlymastering word's styles feature can dramatically improve the quality of your work, whether you're creating a business report, an academic paper, or a personal project.
- How to underline at the end of a URL in Chromechrome sometimes adds an underline to a url, causing problems when typing it into the address bar. and here is how to fix this.
- How to turn off spell check in Word - Turn off red underline in Wordthe spell check feature in word is very useful, but it shows up as a red underline when you edit text. this doesn't really affect much, but if it makes you feel uncomfortable when reading, why not turn off this spell check feature?
- Get started with Excel for beginnersexcel plays an important role in many areas. you work with computers and often use excel. are you still wondering and how to use excel?
- How to Use iPhone 16's Photographic Stylesiphone 16's photographic styles bring a new way to enhance photos.