Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to draw a line in Excel – Excelchat

Although Excel is mainly used for numbers and formulas, it also features a drawing tool that enables us to insert pictures, lines and shapes.  This article provides a step-by-step tutorial on how to draw lines.  

Figure 1.  Final result:  How to draw lines

How to draw a line?

In order to draw a line, we make use of the drawing tool:    

  • Click Insert tab > Shapes > Lines

From the drop-down menu, we choose the type of line we want to insert.  The choices in the menu are: Lines, Arrows, Curves, Free-form and Scribble.

Figure 2.  Lines option in Shapes menu

  • Select the first line button
  • The mouse pointer will then show a plus “+” sign.  We click the mouse button anywhere on our worksheet where we want to place our line, then hold and drag it until the desired length and orientation is achieved
  • Release the mouse button

We have now successfully created a line through the drawing tool.  The image below shows a diagonal line.  

Figure 3.  Output: How to draw a line

Draw a perfectly straight line

If we want to draw a perfectly straight line, we have to drag the line to the right and keep a straight line as we move the cursor across the screen.  There are times, however, when we still end up with a slightly slanted line even when we have diligently tried to make the line straight.

Below image is an example of a slanted line with a height of 0.05 cm.

Figure 4.  Slanted line height preview

A perfectly straight line must have zero height.  Hence, we can make any horizontal line straight by changing the height to zero “0 cm”.  

Figure 5.  Perfectly straight line with zero height

Tip:  

While drawing a line, we can make it straight by pressing the Shift key on the keyboard while we drag the cursor to attain the desired length.

Customize a line

After we draw a line, we can customize it through any of the following:

  • Right-click the line and choose from the menu.  We can change the connector type or format the line color, style, size, position, etc.

Figure 6.  Line menu options

  • The connector types to choose from are Straight, elbow or Curved

Figure 7.  Connector type options

  • We can choose from the built-in pre-set styles or format the line color, weight and dash style.

Figure 8.  Line style options

Figure 9.  Line weight options

Figure 10.  Line dashes options

  • For more formatting options, we can select Format Shape after we right-click the line to launch the Format Shape dialog box.  

Figure 11.  Format Shape dialog box

Format Shapes offers all the formatting options that we need when we draw a line such as line color, weight and types, shadow or glow effects, 3D rotation, size and properties.  

Figure 12.  Output: Draw and customize lines

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc