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.
There are 2 suitable ways to draw shapes in Excel. One is by using the Insert tab and the other 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. Using Shapes Feature to Draw Shapes in Excel
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.
- Now, draw according to your desired size in the worksheet as shown below.
- Afterward, under the Format option click on More like the below one.
- Then, select the preferred theme style you want.
- As a result, a Rectangle will be added to your worksheet like the following figure.
- 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.
- Then, select the preferred color of Arrow you want.
- 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 Draw a Floor Plan in Excel
2. Drawing Shapes in Excel with the 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.
- After that, draw a Rectangle manually of your preferred size like the image below.
- Subsequently, you can draw an Arrow of your preferred size manually as shown below.
- Finally, you can finish your drawing by adding a Decision-Making shape to your worksheet like the below one.
Read More: How to Draw to Scale in Excel
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.
Follow the steps below to remove drawing shapes using this feature.
Steps:
- First, go to the Home tab.
- Then, go to the Editing section and click on the drop-down Find & Select.
- Here, select Go To Special.
- Now, in the Go To Special window, select Objects and press OK.
- 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
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.
Download Practice Workbook
You can download the Excel workbook from here.
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
- How to Draw Engineering Drawing in Excel
- How to Make Fishbone Diagram in Excel
- How to Make Sankey Diagram in Excel
- How to Draw Isometric Drawing in Excel
- How to Draw Lines in Excel
<< Go Back to Drawing in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
