Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
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
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
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.