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

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.


Download Practice Workbook

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


2 Simple Methods 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. Use Insert Option to Use Drawing Tools in Excel

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 is created using drawing tools in excel.

Use Drawing Tools in Excel

Read More: How to Remove Drawing Tools in Excel (3 Easy Methods)


Similar Readings


2. Utilize 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 Draw Isometric Drawing in Excel (with Easy Steps)


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.

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

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo