Where is teh single accounting underline in excel

Click the small arrow next to U to expose option to insert double underline.Д¬ATCH вЂ“ This will not allow you to do accounting single / double underlining.

You can go to Home tab > Click on Underline U to insert single underline. Question вЂ“ Is there a way to do single / double underlining without right clicking and taking Format Cells?ДЄnswer вЂ“ Both Yes or No. That is the difference and it is an individual choice. One almost touches the number itself and one almost touches the lower boundary of the cell. Both are acceptable formats as far as accounting is concerned. Question вЂ“ Then what to choose between Single / Double and Single / Double Accounting underlines?ДЄnswer вЂ“ It depends upon you / recipient of the Excel sheet what appeals to you / his eyes. Question вЂ“ What is the difference between Single / Double and Single / Double Accounting underlines?ДЄnswer вЂ“ The only difference is vertical distance between number and underlines. In the Underline box, you can select Single or Double Accounting. To do so, right click on the cell and Format Cells (or CTRL+1) and go to Font tab. Grand Total is final total, hence that is double underlined. Note: To remove an underline click the down-arrow next to the Underline field and then select. 33 Single accounting underline 34 Double accounting underline. Q1 and Q2 totals are Subtotals, hence they are single underlined. Single Accounting or Double Accounting Underline. If the number format you use is the same as one of Excels built in number formats. The concept, in simple terms (not in statement of account format) is illustrated below. Single Accounting and Double Accounting underlines are accounting practices. Evan Evan 1,206 5 5 silver badges 17 17 bronze badges. Stack Overflow works best with JavaScript enabled. Single UnderliningВ is used to denote Subtotal and Double UnderliningВ is used to denote Grand Total. Currently my solution is to have 4 cells stacked on top of each other with the bottom border of each cell turned on. They, sometimes, use Single Underlining and Double Underlining in their statement of accounts. For this, you will go through right click > format cells (CTRL+1) approach only.Accountants were the first and foremost users of spreadsheet programs and they are still the dominant group using Excel.В If you are working for accountants, you need to know this concept as these are critical formats for the accountants.

Q1 and Q2 totals are Subtotals, hence they are single underlined. Single UnderliningВ is used to denote Subtotal and Double UnderliningВ is used to denote Grand Total. Accountants were the first and foremost users of spreadsheet programs and they are still the dominant group using Excel.В If you are working for accountants, you need to know this concept as these are critical formats for the accountants.

Where is teh single accounting underline in excel