How to Draw Shapes in Excel (2 Suitable Ways)

Sometimes we need to add different shapes to our worksheets in Microsoft Excel. This is very useful to make flow charts, decision-making charts, etc. Also, it helps us to represent our dataset in a unique way. Are you looking for answers to the question of how to draw shapes in Excel? In this article, we’ll discuss how to draw shapes in Excel in 2 suitable ways.


Download Practice Workbook

You can download the Excel workbook from here.


2 Suitable Ways to Draw Shapes in Excel

There are 2 suitable ways to draw shapes in Excel. One is by using the Insert tab and the another is by utilizing the Draw feature. The first method draws the shapes more accurately while the second method is manual. In this article, we will discuss both methods.


1. Use of Shapes Menu from Insert Tab

For drawing, using the Shapes feature from the Insert tab is the most common approach. It’s simple and easy to use. It gives lots of variety of shapes to insert into your workbook. In this example, we will draw different types of shapes in Excel using the Shapes feature from the Insert tab. Follow the steps below to apply this method.

Steps:

  • First, open your workbook.
  • Second, go to the Insert tab and click on the Shapes feature as shown below.
  • After that, in order to draw a Rectangle, click on the Rectangle shape like the image below.

Suitable Ways to Draw Shapes in Excel

  • Now, draw according to your desired size in the worksheet as shown below.

Suitable Ways to Draw Shapes in Excel

  • Afterward, under the Format option click on More like the below one.

Suitable Ways to Draw Shapes in Excel

  • Then, select the preferred theme style you want.

Suitable Ways to Draw Shapes in Excel

  • As a result, a Rectangle will be added to your worksheet like the following figure.

Suitable Ways to Draw Shapes in Excel

  • Subsequently, in order to add an Arrow to your worksheet, go to the Insert tab and click on the Shapes option as shown below.
  • After that, click on the Arrow sign like the image below.

Suitable Ways to Draw Shapes in Excel

  • Then, select the preferred color of Arrow you want.

Suitable Ways to Draw Shapes in Excel

  • As a result, an Arrow will be added to your worksheet like the following figure.

  • Furthermore, in order to add an Oval shape to your worksheet, go to the Insert tab and click on the Shapes option as shown below.
  • After that, click on the Oval shape like the image below.

  • Now, draw according to your desired size in the worksheet as shown below.

  • Next, under the Format option click on More like the below one.

  • After that, select the preferred theme style you want.

  • Finally, an Oval shape will be added to your worksheet like the following figure.

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


Similar Readings


2. Utilize Draw Feature

We can also use the Draw feature to draw shapes manually. In this method, the accuracy depends on your drawing skills since the drawing will be done manually. If you want to draw shapes in your own style you can use this method. Follow the steps below to draw shapes in Excel by utilizing the Draw feature.

Steps:

  • Firstly, go to the Draw tab.
  • Secondly, choose the Draw option selecting your preferred color pen. In this example, I have chosen the black one.

Suitable Ways to Draw Shapes in Excel

  • After that, draw a Rectangle manually of your preferred size like the image below.

Suitable Ways to Draw Shapes in Excel

  • Subsequently, you can draw an Arrow of your preferred size manually as shown below.

Suitable Ways to Draw Shapes in Excel

  • Finally, you can finish your drawing by adding a Decision Making shape to your worksheet like the below one.

Note: 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 Commands drop-down list choose All Commands and select Draw after selecting press Add and then press the OK button to get it.

Read More: How to Draw to Scale in Excel (2 Easy Ways)


How to Remove Drawing Shapes in Excel

A lot of times when you copy any data from other sources, there might be a lot of unnecessary shapes and objects. Then we feel the necessity to remove those shapes. The dataset that we will use to remove the drawing tools contains various shapes as Excel objects. The Go To Special feature in Excel allows you to quickly find and select any item that meets certain criteria. We will use this feature to remove drawing tools from our Excel worksheet.

Suitable Ways to Draw Shapes in Excel

Follow the steps below to remove drawing shapes using this feature.

Steps:

  • First, go to the Home tab.

Suitable Ways to Draw Shapes in Excel

  • Then, go to the Editing section and click on the drop-down Find & Select.
  • Here, select Go To Special.

Suitable Ways to Draw Shapes in Excel

  • Now, in the Go To Special window, select Objects and press OK.

Suitable Ways to Draw Shapes in Excel

  • As a result, this will find and select all the objects that are present in the current worksheet.

  • Finally, press Delete and Excel will remove all the shapes.

Read More: How to Remove Unwanted Objects in Excel (4 Quick Methods)


Things to Remember

  • Using the Insert tab method is the easiest way to draw different shapes in Excel. Also, it draws the shapes more accurately.
  • Utilizing the Draw feature is a manual method. It gives you more freedom to draw shapes in your own style but the accuracy depends on your own drawing skills.

Conclusion

Hence, follow the above-described steps. Thus, you can easily learn how to draw shapes in Excel. Hope this will be helpful. Follow the ExcelDemy website for more articles like this. Don’t forget to drop your comments, suggestions, or queries in the comment section below.


Related Articles

Md. Asaduzzaman

Md. Asaduzzaman

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo