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. If you use the underscore key for your text on your keyboard and then the underline button in the multiline text editor to under line the string of underscores you end up with a dashed line above a continuos line but you can't put text in place of the underscores. 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. Press and hold this keyboard shortcut combination to add multiple underlines next to each other, creating an underline.
If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons. To apply a single underline, you then have to use the dropdown next to the Double Underline icon.
Both are acceptable formats as far as accounting is concerned. Updated: by Computer Hope To create an underline without any text in Microsoft Word, press Ctrl + U to start the underline, then, press Ctrl + Shift + spacebar to create non-breaking spaces. Gotcha: When you choose Double Underline from the Home tab's Underline dropdown, the Underline icon changes to a Double Underline icon. 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. Step 2: Select the cell(s) to which you want to apply the double underline formatting. Step 1: Open the spreadsheet containing the value(s) that you wish to double underline. The steps in this article were performed in Excel 2013, but will work in Excel 2010 or 2016 as well.
#How to make double underline in excel how to
Question – What is the difference between Single / Double and Single / Double Accounting underlines?Īnswer – The only difference is vertical distance between number and underlines. How to Double Underline a Value (Numbers or Letters) in Excel 2013. 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. 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.