How to put a horizontal line in Microsoft Excel Spreadsheet

In Excel, a horizontal line is a formatting element that can be added to a spreadsheet to separate or distinguish one section of data from another. Horizontal lines are useful for visually organizing and presenting data, as they create clear boundaries between different sections of a spreadsheet.

In this tutorial, we will learn how to put a horizontal line in Microsoft Excel Spreadsheet. In Excel, there are multiple methods to add a horizontal line. A horizontal line can be added by inserting a line from the illustrations or we can simply add a horizontal border using the Format Cells option.

Method 1: Put a Horizontal Line from the Illustrations

Step 1 – Go to the Insert Tab

• Go to the Insert tab in the menu bar.

Step 2 – Click on the Shapes Button

• Click on the Shapes button in the Illustrations section.

Step 3 – Select the Line

• Select the type of line you want to put.

Step 4 – Draw the Line Horizontally

• Click where you want the line to start and drag and drop till where you want the line to end.

Method 2: Put a Horizontal Line Using the Format Cells Option

Step 1 – Select the Cells 

• Select the cells in which you want to put the horizontal line.

Step 2 – Right Click

• Right-click on the selected cells.
• A context menu will appear.

Step 3 – Click on the Format Cells Option

• Click on the Format Cells option in the context menu.

Step 4 – Go to the Border Tab

• Go to the Border tab in the Format Cells dialog box.

Step 5 – Select a Horizontal Border and Style of the Border

• Select a Horizontal border from the Border section.
• Select the style or color of the border in the style and color sections.

Step 6 – Click on OK

• Click on OK in the Format Cells dialog box.
• The horizontal line will appear.