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

 

Drawing Lines

Summary: Want to add some lines to your worksheet? You can add all sorts of them by following the techniques described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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:

  1. Select a line weight and type by clicking on the Line Style tool on the toolbar.
  2. Click on the line tool.
  3. Position the mouse pointer where one end of the line is to be located.
  4. Click and hold the mouse button.
  5. Drag the mouse until the line is the desired length.
  6. Release the mouse button.

If you are using Excel 2007, the Drawing toolbar is no longer used. Instead, you should follow these steps:

  1. Display the Insert tab of the ribbon.
  2. Click the Shapes tool in the Illustrations group. Excel displays a drop-down cornucopia of drawing objects.
  3. Click the line that most closely resembles the type of line you want to draw.
  4. Position the mouse pointer where one end of the line is to be located.
  5. Click and hold the mouse button.
  6. Drag the mouse until the line is the desired length.
  7. Release the mouse button.

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

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!