Microsoft Excel 2010

Double or Accounting Underline Text

SUMMARY: Choose from several underline styles in an Excel 2010 workbook.

It's simple to underline text in Microsoft Excel 2010 - either press the CTRL + U keys or press the U button in the Font section of the "Home" tab in the Ribbon. However, you may not know that a couple of other underline styles are available besides the single basic underline, such as styles that underline everything except currency symbols. See the screenshot on the right for an example.

1. Select a cell you want to underline in a different style. Note that you can only apply one underline style per cell.

2. Click the "Home" tab in the Ribbon. In the "Font" section, click the button at the bottom-right to open the "Font" tab of the "Format Cells" dialog box. Or you can press CTRL + SHIFT + F.

3. When the dialog box appears, click the pull-down underneath "Underline" to choose from the following styles:

* None

* Single

* Double

* Single Accounting - Underline everything except currency symbols

* Double Accounting - Double underline everything except currency symbols

Applying the Double Accounting underline style to a cell in Excel 2010

4. Click "OK" to save your changes.

Return to the Microsoft Excel 2010 page.

Print this tip

Get the Newsletter

Thanks For Sharing!

Newest Tips:

Microsoft Word 2010
Make Sure Others Can See Your Fonts

Microsoft PowerPoint 2010
Animations or Video Displaying Poorly?

Google Chrome
[MODIFIED] Report a Malfunctioning Web Page, Crash, or Other Issue

Google Gmail
Show Unread Message Count as an Icon

Follow Us!

Email Twitter RSS

About MalekTips and the Author