How to Make Lines on an Excel Spreadsheet

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

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.

Video of the Day

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.

Advertisement

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.

Advertisement

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.

Video of the Day

Advertisement

Advertisement

references