How to Draw Separating Lines in Excel

Draw a Border Line
1. Open the Excel worksheet.
2. Click the “Home” tab on the command ribbon.
3. Click the arrow next to the “Border” button in the 'Font' group to display a list of border styles. To create a custom line, click the “Draw Border” option in the “Draw Borders” section. The pointer converts to a pencil symbol.
4. Click and drag the cursor on the worksheet to start the line.
5. Release the mouse to end the line. Press any key to convert the pencil symbol back to a pointer.
Insert a Pre-Defined Border
6. Open the Excel worksheet.
7. Click and drag on the range of worksheet cells that will contain the new border or line.
8. Click the “Home” tab on the command ribbon.
9. Click the arrow next to the “Border” button in the “Font” group to display a list of border styles.
10. Click the preferred pre-designed border style, such as “Left Border,” “Thick Box Border” or “Top and Double Bottom Border.” The selected cells display the lines.