Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Drawing Lines.
by Allen Wyatt
(last updated December 5, 2015)
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!) Here's the easiest way to create your line:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2460) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Drawing Lines.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
A picture is worth a thousand words, but getting the picture—particularly a screen shot—into a workbook may seem ...Discover More
The graphics features of Excel allow you to add a number of predefined AutoShapes to a workbook. If you want to add shapes to ...Discover More
Create a simple drawing object, and Excel makes some assumptions about how that object should appear. Excel provides a wide ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."