How to Use Drawing Tools in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel you might need to draw various shapes in the workbook. Does it seem possible? Can we really draw inside a spreadsheet? The answer is “Yes”. You can draw using drawing tools in Excel. In order to draw anything inside your worksheet just go to the “Insert” option and you will find various drawing tools like “Shapes”, “SmartArt”, and “3-D Models”. Today, I am going to show you how to use drawing tools in Excel.

In the following, I have shared 2 simple and quick methods to use drawing tools in Excel. Stay tuned!


1. Using Drawing Tools from Excel Insert Tab

For drawing, I would personally suggest using “Shapes” from the “Insert” option. It’s simple and easy to use. In this method, I will make a flow chart using different shapes of drawing tools. Follow the steps below-

Step 1:

  • First, open your workbook and choose “Shapes” from the “Insert” option.

Use Insert Option to Use Drawing Tools in Excel

  • Second, from the drop-down list, you will get various shapes to draw.
  • As we are creating a flow chart, choose a “Rectangle” shape.

  • Now, draw according to your demanded size in the worksheet.

Use Insert Option to Use Drawing Tools in Excel

  • Similarly, we will insert a “Decision” shape from the list.

  • In summary, we have successfully drawn two shapes in our worksheet.

Use Insert Option to Use Drawing Tools in Excel

Step 2:

  • You can copy and paste the shapes if you want. Here, I have selected a shape and then copy-press “Ctrl+C”.

Use Insert Option to Use Drawing Tools in Excel

  • After that, select a location and press Ctrl+V to paste and get the same shape.

  • In order to display the final output, let’s draw an “Oval” shape at the right corner of the worksheet.

Use Insert Option to Use Drawing Tools in Excel

  • As a result, our flow chart is almost finished with different shapes.

Use Insert Option to Use Drawing Tools in Excel

Step 3:

  • However, we will put “Indicating Lines” between the shapes. To do so-
  • In the same fashion, choose “Arrow Line” from the “Shapes” option.

  • Then, draw the arrow line between two shapes.

Use Insert Option to Use Drawing Tools in Excel

  • Similarly, draw the arrow line again to connect all the shapes.

  • Unless drawing the same arrow line let’s draw an “Elbow Arrow” for the right side shape.

  • After choosing it from the list, place the connector on your sheet.

Use Insert Option to Use Drawing Tools in Excel

  • Finally, we have our flow chart ready drawing various shapes using the drawing tools.

Use Insert Option to Use Drawing Tools in Excel

Step 4:

  • In addition, let’s fill the shapes with texts to make it more lucrative.

Use Insert Option to Use Drawing Tools in Excel

  • On the other hand, you can change the format from the “Shape Format” option.
  • Here, selecting the texts I have changed the text format using the “WordArt Styles”.

  • In conclusion, our final flow chart has been created using drawing tools in Excel.

Use Drawing Tools in Excel

Read More: How to Remove Drawing Tools in Excel


2. Applying Draw Feature to Use Drawing Tools

You can also utilize the draw feature to use drawing tools in Excel. In the following, I have shared steps on how to use the draw feature. Please follow-

Steps:

  • While in the workbook select a “Drawing Pen” from the “Draw” option.
  • Moreover, you can change the “Color” if you want. Here, I have selected “Black Color” to draw a border.

Utilize Draw Feature to Use Drawing Tools

  • Besides, I have drawn a shape manually on the sheet.

  • Hence, I have chosen another “Highlight Pen” and a “Color” to draw.

Utilize Draw Feature to Use Drawing Tools

  • Finally, I have highlighted the previously drawn border using the drawing tools in excel. Simple isn’t it?

Utilize Draw Feature to Use Drawing Tools

Read More: How to Create Drawing Register in Excel


Things to Remember

  • Suppose you don’t have the “Draw” option at the top ribbon. Don’t worry. Just follow these instructions to get the “Draw” feature. Go to File > Options > Customize Ribbon. From the “Commands” drop-down list choose “All Commands” and select “Draw” After selecting press “Add” and then hit the OK button to get it.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, I have tried to cover all the methods of using drawing tools in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel projects.
Wasim Akram
Wasim Akram

Wasim Akram, BSc, Industrial and Production Engineering, Ahsanullah University of Science & Technology, has been working with the ExcelDemy project for 10 months. Currently working as as Excel and VBA content developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He published almost 150 articles and has many more coming. He is very passionate about learning new things about Microsoft office Suite and Data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo