How to Add a Line in Excel
By Alan Sembera
Adding lines to your Excel spreadsheet can help organize your information to create a more professional look for business documents. Excel features two basic methods for adding lines. You can add a single border to a range of cells, or you can use the drawing tool to create a variety of straight, curved and even diagonal lines.
Select the "Home" tab at the top of Excel, then click the downward pointing arrow next to the small square symbol in the "Fonts" section of the toolbar. This will open the "Borders" drop-down menu.
Select the "Line Color" or "Line Style" options if you want to customize your line. You can change its color and thickness, or choose other features such as double lines or dotted lines.
Choose the "Draw Borders" option when you are ready to create the line.
Click on the worksheet at the point where you want to begin your line. While holding down the mouse button, move your pointer to the location where you want to end the line, then release the mouse button. For better accuracy, begin your line by clicking at the intersection of a row and column.
Double-click anywhere on the worksheet to disable the tool and resume normal editing.
Select the "Insert" tab at the top of Excel and click "Shapes" in the "Illustrations" section of the toolbar.
Select the first option under "Lines" in the drop-down menu to create a straight line. Select one of the other options to create a curved line or specialty line.
Click at the point where you want to begin your line. While holding down the mouse button, move to the point where you want to end the line and then release the mouse button.
Adjust the length of the line by clicking on the line to make small circles appear at each end of the line. Click one of the circles and drag it to another point on the worksheet. You can move a line by first clicking the line to select it, and then dragging it to a new location.
If you wish to add a new row of cells, simply right-click on the row header directly below the location where you want the new row, choose "Insert" from the pop-up menu and click "Insert Row Above."
Information in this article applies to Microsoft Excel 2013. It may vary slightly or significantly with other versions or products.
Alan Sembera began writing for local newspapers in Texas and Louisiana. His professional career includes stints as a computer tech, information editor and income tax preparer. Sembera now writes full time about business and technology. He holds a Bachelor of Arts in journalism from Texas A&M University.