#How to delete an underline in excel how to
This video shows you how to remove Underline in MS Excel 2016.Excel Tips & Tricks.
This would give a bottom border to the cell, which looks as if you have underlined the cell. In case you want a double-underline, you can click on the ‘Border style’ option and then click on the double border option. If you want to select a range of cells in a column and give all the cells a bottom-border, choose the ‘Horizontal border’ option in the Border options in the toolbar.Problem: My boss is a CPA. He says I should double underline the grand total in a report. The Home tab of the ribbon offers a single underline icon. 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. On the Font tab, from the Underline dropdown you can select Single Accounting or Double Accounting. Gotcha: When you choose Double Underline from the Home tab's Underline dropdown, the Underline icon changes to a Double Underline icon. To apply a single underline, you then have to use the dropdown next to the Double Underline icon. If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons.
Add the double underline icon to the QAT.Underline, Double Underline, and Underline Gallery. 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. The double underline extends almost to the edge of the cell. how to remove red underline in word So the question is, how to remove the red line in Word Simply, you just need to turn off the Proofing tool. The big difference with the accounting underlines shows up when you use any of the (Indent) choices.
To do that, Step 1: Go to File tab, select Options. To try it, go to Format Cells, Alignment. Choose Right (Indent), Left (Indent), or Distributed (Indent) from the Horizontal Alignment dropdown. Underlines extend beyond numbers with accounting style.The accounting underline will extend beyond the numbers. How to delete underline in excel how to#.