Underline in excel how to#

Here, you’ll find links to step-by-step tutorials that will walk you through a variety of different situations – such as various ways to format charts and graphs, shortcuts for entering formulas and changing formats, and even how to play games like Craps in Excel. If you’re looking for more tips and tricks, check out 91 Tips for Calculating With Microsoft Excel. Then, you can copy that cell and paste the format only to other cells on your spreadsheet. Quick Tip: If you need to double underline several values, you can just perform this sequence once. Summary: You can add a double underline to a number, but you have to use the Font tab of the Format Cells dialog.Ĭommands Discussed: Format – Cells – Font – Underline

Go to the Font tab and select the appropriate option from the Underline drop down list. 1288.Īlternatively (and this also works in Excel 20), you can right-click on the cell in question and choose Format Cells. The cell will have a double underline, as shown in Fig. In the Underline dropdown, choose double or double accounting.

From the menu, select Format – Cells – Font. Note: Click any image for a larger view of the figure. 1287, you only have an underline icon on the Formatting toolbar. He says you should double underline the grand total in a report. For this, you will go through right click > format cells (CTRL+1) approach only.Problem: Your boss is a CPA. 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.

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.

Underline in excel