How to Make Lines on an Excel Spreadsheet

By Lysis

When creating a spreadsheet, you can format the font, cells and borders. One option is creating borders around the cells. This type of formatting is used to separate totals from numbers, section off different types of data or just make a spreadsheet more attractive. At the top of the Excel window, you can choose a line and where it is placed on the cell. For Excel 2007, this option is in the Font group on the Home tab of the Office Fluent Ribbon. For older versions of Excel, the line tool is in the main toolbar.

Step 1

Open the Excel spreadsheet you want to edit. You can do this by double-clicking the document on your hard drive. Excel automatically opens along with the document.

Step 2

Highlight all the cells around which you want the lines to appear. For instance, if you want a line to appear between the first row and the second row, highlight the cells in the second row.

Step 3

Click the "Border" drop-down box, and select a location for the line. If you want to add a line between row 1 and row 2 and you've highlighted all the cells in row 2, choose the "Top Border" command.

Step 4

Click any cell on the spreadsheet to see the results. You'll notice a line that stretches across all the cells you had highlighted. If you want to change the location of the lines, click the "Undo" key.

Step 5

Click the "Save" button to save the border changes to the file.

Tips & Warnings

  • You can also create vertical lines on the spreadsheet by highlighting columns of cells instead of rows.