![how to do a double underline in excel how to do a double underline in excel](https://support.content.office.net/en-us/media/81e2f1b5-520e-4e00-bea1-59b463d40efc.png)
- How to do a double underline in excel for free#
- How to do a double underline in excel how to#
- How to do a double underline in excel update#
This is an update of a post from December 2010. And for totals, select your cell(s) and click the down arrow next to the underline button on the ribbon, You’ll find a choice there for double underline. It has a pared down feature set so that the user does not go insane trying to dig through the options on a touch screen.
How to do a double underline in excel for free#
(If you underline first, it won’t work.) In Excel this is called Accounting Underline. Excel Mobile App Double Underline (iPad, iPhone and Android) Microsoft has made a light version of it’s popular Excel spreadsheet program available for free on iOS and Android devices.
![how to do a double underline in excel how to do a double underline in excel](https://www.excelarticles.com/image/LE10001176.jpg)
How do I get rid of double underline in Excel Highlight the total row, right -click on the row, select Format Cells from the pop-up menu, and then on the Font tab, select Double Accounting from the Underline dropdown box, then click OK.2013. Or will it? If you first format cells with either the comma format or the accounting format and then format the text as underlined, the underline will extend almost the entire width of the column. To remove the the double underline, with you text selected simply hit the shortcut again. You could format the text in the headings to be underlined, but then the line will only be as wide as the text or numbers in the cell. But that is tedious to set up and interferes with using the ctrl+arrow or End+arrow keyboard shortcuts. A common solution is to have very narrow empty columns between the columns of data. Working with data is often more than simply using the right formula to perform your calculations. But for totals or subtotals, many people don’t like the continuous line that it creates they would prefer a separate underline in each column. Putting a bottom border on a row of cells can be a good choice for column headings on a spreadsheet. In the Font section, click the button at the bottom-right to open the Font tab of the Format Cells dialog box. Note that you can only apply one underline style per cell.
![how to do a double underline in excel how to do a double underline in excel](https://i.ytimg.com/vi/HqbUnjwSubo/maxresdefault.jpg)
Most people that I’ve shown this to are just as surprised as I was when someone first showed me. Select a cell you want to underline in a different style. This deselects the Underline button and removes the underline from your text.Today’s Excel tip is very simple, but it can save a lot of time when formatting a spreadsheet. Select the underlined text and click the Underline button in the Font section on the Home tab. Then, use the options in the Style drop-down box. If you used the table method above to underline spaces, select the table and head back to Table Properties > Borders and Shading. Right-click the selected text and pick “Font.”Choose the line in the Underline Style drop-down box and click “OK.” Then, do one of the following.Ĭlick the arrow next to the Underline button in the Font section of the Home tab. If you’ve already applied the underline, select all of the underlined text. To change the line style at the time you apply the underline, select the text you want to underline.
How to do a double underline in excel how to#
RELATED: How to Add a Dotted Line in a Microsoft Word Document And you can change the line before or after you apply the underline to your text or spaces. You can pick a double underline, a bolder line, or a dotted line in a variety of styles. You have a few different ways to change the format for your underline. Then format with Double underline and Single top line. Then, goto Edit - GOTO - SPECIAL - VISIBLE CELLS ONLY. Highlight the SUbtotals and not the Grandtotal. You’ll then have a single line as your “underlined spaces.” Drop your subtotals to level 2 so all you see are the subtotals.