How can I add a double underline Strategy: You select the grand total cell and, instead of clicking the Underline icon, you click the dropdown arrow next to the Underline icon. Select the text that you want to underline in the cell.
HOW TO GET DOUBLE UNDERLINE IN EXCEL HOW TO
Double-click on the cell (or press F2) to get into the edit mode. Excel - Quick Guide, This chapter teaches you how to start an excel 2010 application in simple steps.
Underlines extend beyond numbers with accounting style. The Home tab of the ribbon offers a single underline icon. Learn how to double underline in Word, Excel and PowerPoint using a single keyboard shortcut.You can also use the Font Dialog box shortcuts in Word, Excel an. Select the cell that has the text that you want to underline. 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.
Add the double underline icon to the QAT. Underline, Double Underline, and Underline Gallery. After youve underlined your text, you can apply justification to extend your text to your documents. You can also apply additional underline styles to your text, such as dashed lines and decorative styles. Another option: If the column of figures is in a Table (even a single column just for the figures), remove the Borders from the Table & apply just a double line Bottom border to the cell containing the. You can increase the emphasis of words in your document by underlining your text in Microsoft Word. If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons. For a one shot instance just select the characters to be underlined then go to Format> Font & select double from the list of Underline Styles. If you don't like the continuous line you get when using cell borders to format totals or column headings in Excel, you'll be glad to know that you can get the look you want with just a few clicks. 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.
The Home tab of the ribbon offers a single underline icon. He says I should double underline the grand total in a report.
0 kommentar(er)
