commloha.blogg.se - Shortcut key for double underline in excel

Underlines extend beyond numbers with accounting style.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. Just in case if you want to apply double underline, then click on the drop-down list of underline options and choose Double Underline. The below image shows a combination of all the above three options. Answer (1 of 2): What is the shortcut for underlining in Excel Ctrl + U will do underline the cell, or text within the cell. And to apply to Underline formatting, use Ctrl + U shortcut key.

The big difference with the accounting underlines shows up when you use any of the (Indent) choices. To apply Italic formatting, use Ctrl + I shortcut key. 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. Step 2: From the options tab, choose to add New Tab and choose the Strikethrough option and click on OK. If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons. Step 1: Right-click on the Font tab and choose the option of Customize the ribbon. 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. Shortcut Keys for Locating Character Formats Ctrl+Shift++, - Apply superscript formatting Ctrl+Shift+W, - Word underline Ctrl+Shift+D, - Double-underline.

The Home tab of the ribbon offers a single underline icon. He says I should double underline the grand total in a report.