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.