- #Double underline in excel for mac update#
- #Double underline in excel for mac mac#
- #Double underline in excel for mac windows#
Therefore, it won’t really look like a true double underline. As you can see, this does creates two lines, but the top line is only as wide as the characters in the cell. The first option is to use a single bottom border on a cell and then use the underline font style. The remainder of this article is preserved just in case you want to know how hard we had it way back when! Bottom border and underline
#Double underline in excel for mac update#
Update – As of late February 2017, a double underline is available in Google sheets without needing to use any workarounds. None of them are perfect, but you should be able to get the effect that you are looking for. What is one to do? Before you abandon ship, you should realize that there are a few decent work arounds for the issues. In Excel, you can add other styles of borders like Bottom Double Border, Thick Bottom Border, Top, and Bottom Border, Top and Thick Bottom Border, Top and Double Bottom Border.
![double underline in excel for mac double underline in excel for mac](https://images.tips.net/S06/Figs/T8383F2.png)
If we put the format that we found ( -409,0. The format displayed is the format used by Excel. This is one of the few ways in which Sheets is inferior to Excel. This is an example of the type of control you have in Excel to format how you want the cells to look specifically. The easiest way to do this is to open the Number Formatting dialog in Excel and set the format that you want: Then, while still in the dialog, change to Custom. There has been much gnashing of teeth for those making the switch to Google Sheets when they find that their faithful double underline function is not there. You have to buy the Microsoft office package if you don't have it already, and it will come with word, excel, and powerpoint.
![double underline in excel for mac double underline in excel for mac](http://www.word-2016.com/wp-content/uploads/2016/12/right-click-options.gif)
![double underline in excel for mac double underline in excel for mac](https://support.content.office.net/en-us/media/d1963e2c-2fcf-4698-a201-40505b052dd7.png)
Underline, Double Underline, and Underline Gallery. If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons. 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. The first option is to use a single bottom border on a cell and then use the underline font style. On the Font tab, from the Underline dropdown you can select Single Accounting or Double Accounting. Available list styles include discs, dashes, numbers, uppercase/lowercase letters, and uppercase/lowercase. Of course, there is a simpler and safer method. You can delete it directly with the 'Delete duplicates' option.
#Double underline in excel for mac mac#
Cycle through ordered and unordered lists styles. Removing duplicates in excel on Mac is easy. The dropdown leads to double underline.Īlternate Strategy: You can also press Ctrl+1 to access the Format Cells dialog. 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. Cycle through the four native underline styles (single, single accounting, double, and double accounting).
![double underline in excel for mac double underline in excel for mac](https://nutsandboltsspeedtraining.com/wp-content/uploads/2017/12/How-to-Double-Underline-3.png)
These are the steps you may use to type this symbol in Word, Excel or PowerPoint.
#Double underline in excel for mac windows#
Alternatively, for windows users, press and hold the alt key and type 95 on the number pad. Strategy: You select the grand total cell and, instead of clicking the Underline icon, you click the dropdown arrow next to the Underline icon. For both Windows and Mac, press and hold the Shift key and hit once on the - (Minus) key. The Home tab of the ribbon offers a single underline icon. He says I should double underline the grand total in a report.