#Double underline in excel how to#

The fonts are changed to make the spreadsheet more readable and delicate. Strikethrough is applied by either clicking the Strikethrough (ab) icon or using the keyboard shortcut CTRL + 5 or Command + Shift + Xįonts can be changed in four different ways: color, font name, size and other characteristics. Underline is applied by either clicking the Underline (U) icon or using the keyboard shortcut CTRL + U or Command + U Italic is applied by either clicking the Italic (I) icon or using the keyboard shortcut CTRL + I or Command + I CATCH This will not allow you to do accounting single / double underlining. Click the small arrow next to U to expose option to insert double underline. The commands can be found below the font name drop down menu:īold is applied by either clicking the Bold (B) icon in the Ribbon or using the keyboard shortcut CTRL + B or Command + B You can go to Home tab > Click on Underline U to insert single underline.

#Double underline in excel how to#

You can apply different characteristics to fonts such as: Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML. To change the font size of the font, just click on the font size drop down menu: If you use the underscore key for your text on your keyboard and then the underline button in the multiline text editor to under line the string of underscores you end up with a dashed line above a continuos line but you cant put text in place of the underscores. Good job! You have successfully changed the fonts from Calibri to Arial for the range A1:C4.

If you like this topic, please consider buying the entire e-book. The example has both text ( A1:B1) and numbers ( A4:C4) Excel: Double Underline a Grand Total This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. > On the Font tab, from the Underline dropdown list, choose Double Accounting. The font name can be changed for both numbers and text. 'Debra Dalgleish' wrote: > Select the cells that you want to format.