For this, you will go through right click > format cells (CTRL+1) approach only. 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. Clicking the command a second time removes the underline effect. Simply select the text you want to underline and click the command to add your underline. The solutions work in Excel 2016, 2013 as well as in earlier versions.
You can go to Home tab > Click on Underline U to insert single underline. Another fast way to underline text in Word, Excel, and PowerPoint is to simply click the Underline command on the Home tab in the Ribbon. In this article I will show you two quick and free ways to convert currency numbers into English words. For example, if we format the number to Accounting format, Excel will display the output as 500.00. Question – Is there a way to do single / double underlining without right clicking and taking Format Cells?Īnswer – Both Yes or No. Accounting Format: The Accounting format is also one of the number formattings in excel, which aligns the dollar sign at the left edge of the cell and displays it with two decimal points. 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. You can underline all or selected text in cells, apply a bottom border to cells or rows, or draw a line to underline cells. In the Underline box, you can select Single or Double Accounting. There are several ways to add underlining to data on a worksheet. To do so, right click on the cell and Format Cells (or CTRL+1) and go to Font tab.
In the task bar it looks solid but when you click out of the cell the line breaks. When i do it the underlines are broken and not a solid underline. I only need to underline a few words and not the whole paragraph. Grand Total is final total, hence that is double underlined. I need to underline a few words in a cell that is wrapped text and justified. Q1 and Q2 totals are Subtotals, hence they are single underlined. The concept, in simple terms (not in statement of account format) is illustrated below. Single Underlining is used to denote Subtotal and Double Underlining is used to denote Grand Total. They, sometimes, use Single Underlining and Double Underlining in their statement of accounts.
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.