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 double underline extends almost to the edge of the cell. 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.
#Double underline in excel how to
The dropdown leads to double underline.Īlternate Strategy: You can also press Ctrl+1 to access the Format Cells dialog. For numbers, the single underline is under the characters.Strategy: You select the grand total cell and, instead of clicking the Underline icon, you click the dropdown arrow next to the Underline icon. The Home tab of the ribbon offers a single underline icon. He says I should double underline the grand total in a report.