In this article, we’ll learn how to insert shape in Excel. Understanding how to work with shapes can significantly elevate your Excel skills.
We will explore 2 easy methods to insert shapes in Excel. Firstly, you are going to use the Insert tab and secondly, you will learn a time-saving keyboard shortcut.
You will also learn the formatting options to customize their appearance and discuss how to efficiently delete shapes when you no longer need them. So let’s dive in!
Download Practice Workbook
Download this practice workbook from here.
2 Easy Methods to Insert Shapes in Excel
In this section, I will illustrate 2 easy methods to insert shape in Excel.
1. From Insert Tab
The first method is to insert a shape from the Insert tab.
- Go to the Insert tab >> Illustrations >> Shapes.
- Then, choose a shape you like. I am going to select a rectangle.
- Then, drag your cursor over an area where you want to insert the shape.
Excel inserts a rectangle shape.
2. Using Keyboard Shortcut
The second method is to insert a shape using the keyboard shortcut.
- Press ALT + N >> SH on your keyboard.
- Then, choose a shape you like. I am going to select a rectangle again.
- Then, drag your cursor over an area where you want to insert the shape.
Excel inserts a rectangle.
How to Format Shapes in Excel
You can format a shape in multiple ways. In this section, I will show how you can
- Change the fill color.
- Write something inside the shape.
The formatting options are available in the Shape Format tab.
Changing Fill Color
- Select the shape >> go to the Shape Format tab (this will appear only after you select the shape >> Shape Fill >> choose a color.
- Excel will change the fill color.
Writing Inside Shape
- Double-click the shape to activate the editing mode.
- Then, type something you want.
- Once you have written something, you can format the text from the Home tab. I have formatted it in the following way.
You can avail of other formatting options from the Shape Format tab.
How to Delete a Shape in Excel
Now, let’s see how you can delete a shape in Excel.
- First, select the shape.
- Then, press the DELETE button on your keyboard.
Excel deletes the shape.
Things to Remember
- Different shapes offer different formatting options.
Frequently Asked Questions
1. How do I rotate a shape to a specific angle?
Ans: To rotate a shape to a specific angle in Excel, select the shape, go to the Format tab, click on the Rotate button, and choose the desired angle from the options.
2. Can I group multiple shapes together in Excel?
Ans: Yes, you can group multiple shapes together in Excel. Select the shapes you want to group (hold the CTRL key to select multiple shapes), right-click, and choose Group from the context menu.
3. Can I hyperlink a shape to a different location in Excel?
Ans: Yes, you can hyperlink a shape to a different location in Excel. Right-click the shape, select Hyperlink, choose Existing File or Web Page, and then browse to the location or enter the URL you want to link to.
Conclusion
In conclusion, understanding how to work with shapes in Excel can significantly enhance your spreadsheet presentations. With the ability to insert, format, and delete shapes, you have unlocked a powerful tool for visual communication. Whether you are enhancing reports, or adding a touch of creativity, this article will help you make your data stand out.
Related Articles
<< Go Back to Excel Shapes | Learn Excel