Excel is not only a wonderful tool for data entry and data analysis, but also great at making charts, flow charts, simple diagrams, etc.
It’s quite simple in Excel to insert a line and then customize and position it. In fact, you’ll be surprised how many options you get when you need to draw a line in Excel.
You can easily draw a line to connect two boxes (to show the flow) or add a line in an Excel chart to highlight some specific data point or the trend.
Excel also allows you to use your cursor or touch screen option to manually draw a line or create other shapes.
This Tutorial Covers:
ToggleHow to Insert a Line in Excel (Using Illustation)
To insert a line in the worksheet in Excel, you need to use the Shapes option. It inserts a line as a shape object that you can drag and place anywhere in the worksheet.
You can also easily customize it- such as change the size, thickness, color, add effects such as shadow, etc.
Below are the steps to insert a line shape in Excel:
- Open the Excel workbook and activate the worksheet in which you want to draw/insert the line
- Click the Insert tab
- Click on Illustrations
- Click on the Shapes icon
- Choose from any of the existing 12 Line options
- Go to the worksheet, click the left key on your mouse/trackpad and drag the cursor to insert a line of that length
The above steps would instantly insert the line that you selected in step 5.
These are the 12 line options that you have available in Excel:
- Straight Line
- Line Arrow (with arrow at one end of the line)
- Line Arrow Double (arrow at both ends)
- Connector: Elbow (use this to connect boxes, this is not a straight line)
- Connector: Elbow arrow (arrow at one end)
- Connector: Elbow double-arrow (arrow at both ends)
- Connector: Curved
- Connector: Curved Arrow
- Connector: Curved Double-Arrow
- Curve
- Freeform: Shape
- Freeform: Scribble
Adding Multiple Lines in One Go
When you use the above steps, you can only insert any of the line shapes once. If you need to insert it again (say you want to insert 3 lines), you will have to repeat the process two times again.
Instead, you can lock the drawing mode so you can keep inserting the lines in one go.
Below are the steps to lock the line drawing mode:
- Open the Excel workbook and activate the worksheet in which you want to draw/insert the line
- Click the Insert tab
- Click on Illustrations
- Click on the Shapes icon
- Right-click on any of the line shapes that you want lock (i.e., the one that you want to insert multiple times)
- Click on Lock Drawing Mode
- Click anywhere in the worksheet
When you do the above steps, you will notice that your cursor changes and remains a plus icon. You can now click and drag and insert multiple lines in one go.
To unlock the line drawing mode, hit the Escape key.
Customizing Lines/Arrows in Excel
Apart from inserting different types of lines, you can also further customize the line shapes you insert.
When you click on any of the line shapes in the worksheet, you will see a new contextual tab appear in the ribbon – the Shape Format tab.
In this new tab, you get some additional options to format the lines.
Also read: Insert Arrows in Excel (Symbol, Shape, Icon)
Shape Styles Options
In the Shape Styles group, there are some inbuilt theme styles and preset styles you can use. To see all these options, you can click on the More icon.
Then you can select any of the existing styles and it will be applied to all the selected lines in the worksheet.
Apart from this, you can also change the line outline by clicking on the Shape Outline option.
In Shape Outline, you can change the following:
- Color of the line
- Weight of the line (thickness)
- Style of the line (solid, dot, dash, etc)
- Arrows
And finally, you can also add some Effects to the line, such as shadow, glow, or reflection. This can be done using the Shape Effect options.
To use these, select one or multiple lines to which you want to add the Effects and then use the options in Shape Effect.
Arranging the Lines
If you’re working with more than a few line shapes in Excel, you will find it useful to know about the ‘Arrange’ options.
You can find these in the Arrange group in the Shape Format tab (which only appears when you select any shape in the worksheet).
Following are the options that are available to you:
- Bring Forward / Send Backward – in case you want to rearrange the shapes
- Selection Pane – this opens a pane on the right where you can see all the shapes in the worksheet. You also have the option to hide some shapes from this pane
- Align – To align the lines left/center/right or top/middle/bottom. This comes in handy when working with multiple shapes where you want these shapes to be neatly aligned
- Rotate – to change the angle to the line
- Group – to group mutiple lines/shapes. For example, you can group lines and boxes using this so they will move/size together.
Note that most of the shape ‘Arrange options’ will become available only when you have more than one shape in the worksheet.
Also read: How to Create QR Codes in Excel
Example 1 – Adding a Line to Connect Boxes/Shapes
Now that I’ve covered the basics of how to insert and format line shapes in Excel, let me show you a couple of examples of how you can use this in real life.
A common example is when you have boxes in the worksheet and you want to connect these boxes using lines. These could be simple lines or lines with arrows that also show the flow
Below I have an example, where I have two boxes, and I want to draw lines between these to connect them.
Below are the steps to do this:
- Click the Insert tab
- Click on Illustrations
- Click on Shapes
- Click on the Line icon
- In the worsheet, click on the right border of the first box and drag the cursor to the left border of the second box.
This will insert a line and you will get something as shown below.
You can also use different styles of the lines, such as with arrows or connectors.
Also read: How to Create a New Line In Excel Cell
Example 2 – Adding a Line in Excel Charts
Apart from connecting boxes and making flowcharts, arrows are also useful when you want to highlight specific data points in a chart in Excel.
Below is an example where I wanted to highlight one specific data point with some context, so I added some text in the chart and then used an arrow to point that text towards one specific data point.
You can format the line using the same colors used in the chart, or you can use a contrasting color to make it stand out.
How to Draw a Line in Excel (Using Cursor / Touch)
So far, I have covered how to insert a line shape in Excel that you can drag and drop anywhere in the worksheet and format the colors, thickness, etc.
But there is also an option to manually draw a line or shape in Excel.
The Draw option in Excel allows you to use your cursor (or a pen or touch if you have a touch screen) and draw on the screen.
You can use it to quickly draw some shapes and lines – such as a simple flow chart or an organization chart.
It won’t look as neat and clean as the shapes that you can insert, but in some cases, it could be faster and more useful – for example, if you are trying to show a process in excel on a call or in a presentation.
You can access these options in the Draw tab in the ribbon, where you can select the pen (with different colors and thickness) and use it for drawing lines or shapes.
You can change the pen color and size by clicking on the downward arrow that appears when you select any pen.
In case you don’t see the Draw option in the ribbon, right-click on any of the existing ribbon options and click on Customize the Ribbon. In the Excel Options dialog box that opens, check the Draw option (in the right pane) and click OK.
While using the Draw option is quite easy and self-explanatory, there is one useful feature that I want to highlight – Ink to Shape.
Using the Ink to Shape option, you can draw lines and shapes in the worksheet, and then use this option to convert these into neat-looking shapes (such as proper straight lines and boxes/squares/rectangles).
Below is an example of something I drew using my cursor.
And now below are the steps to convert these hand draw boxes and lines into proper shapes:
- Click the Select Object option in the Draw tab
- Select the shapes you want to convert
- Click on the Ink to Shape option
Here is the result I got:
The above option will try its best to convert your free-form hand-drawn shapes into proper lines and boxes.
This feature is not perfect sometimes can’t understand the shapes. But it still works well and can save you a lot of time if you have a lot of these hand-drawn shapes that need to be converted.
In this tutorial, I covered how to draw a line in Excel using the insert shapes options and the draw options.
I hope you found this tutorial useful!
Other Excel tutorials you may also like: