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
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)
Advertise on the
ExcelTips Site
Working with Imperial Linear Distances
Incomplete and Corrupt Sorting
Quickly Removing a Toolbar Button
Deriving High and Low Non-Zero Values
Counting Cells with Specific Characters
Excel provides tools that allow you to create a number of shapes that were previously only available through the use of a drawing program. One of these shapes is a line. (Yes, the simple line!) How you create a line depends on the version of Excel you are using.
If you are using a version prior to Excel 2007, you normally use the Drawing toolbar to create a line. Follow these steps with the Drawing toolbar visible:
If you are using Excel 2007, the Drawing toolbar is no longer used. Instead, you should follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2460) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.