The accounting underline will extend beyond the numbers. Choose Right (Indent), Left (Indent), or Distributed (Indent) from the Horizontal Alignment dropdown. To try it, go to Format Cells, Alignment. The big difference with the accounting underlines shows up when you use any of the (Indent) choices. The Home tab of the ribbon offers a single underline icon. The double underline extends almost to the edge of the cell. He says I should double underline the grand total in a report. To change the formatting of the line, click the line to select it. Drag to draw a line underneath the cells that you want to underline. What is the difference between underlines and accounting underlines? For text, an accounting underline extends most of the way across the cell, while a regular underline includes only the characters in the cell.įor numbers, the single underline is under the characters. Draw a line to underline cells On the Insert tab, in the Illustrations group, click Shapes.
Add the double underline icon to the QAT.Underline, Double Underline, and Underline Gallery. 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. Gotcha: When you choose Double Underline from the Home tab's Underline dropdown, the Underline icon changes to a Double Underline icon. On the Font tab, from the Underline dropdown you can select Single Accounting or Double Accounting. The dropdown leads to double underline.Īlternate Strategy: You can also press Ctrl+1 to access the Format Cells dialog.Strategy: You select the grand total cell and, instead of clicking the Underline icon, you click the dropdown arrow next to the Underline icon. Click the Bold, Italic, or Underline buttons on the Home tab. If you use borders for underlining numbers you have to insert a small column between each column of numbers to seperate the columns. In addition to changing the font type, you can amplify your project using other features in the Font group such as Bold, Italic, or Underline. The Home tab of the ribbon offers a single underline icon. We would like to use the Accounting Underlines because they will leave a blank space at the beginning and end of an underline (single or double) which is the width of a parenthesis character i.e. He says I should double underline the grand total in a report.