Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Underlining

Summary: Want a quick way to add some underlines to your cell values? It's easy using the shortcuts provided in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Everyone knows that you can underline text by simply selecting what you want underlined and then clicking on the Underline tool on the ribbon or toolbar. This adds a single underline. If you want a double underline, you can add one quickly by simply holding down the Shift key as you click on the underline tool. The double underline is added to your selected text. (Holding the Shift key to get a double underline doesn't work in Excel 2007. Instead, you must click the down-arrow at the right of the Underline tool and then select Double Underline.)

If you want any fancier underlines, you must display the Font tab of the Format Cells dialog box. You do this in Excel 2007 by displaying the Home tab of the ribbon and clicking the small icon at the bottom-right of the Font group. In previous versions of Excel you choose Cells from the Format menu.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2131) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.
 
Check out ExcelTips: Serioius Sorting today!