Insert a Shape in an Excel Spreadsheet – Quick Tip

Excel sheet with an oval shape.

This quick tip shows you how to insert a shape on an Excel spreadsheet. In this lesson, we will use the circle as our shape.

For the purpose of this instruction, we use Excel 2016.

Steps to Insert a Shape in Excel

Start a new file (Ctrl-N) and follow the steps below to insert an oval or circle in Excel.

The key steps to insert a shape in Excel.
The key steps to insert a shape in Excel.
The final step to inserting a shape in Excel.
The final step to inserting a shape in Excel.
  1. Select Insert from the menu bar.
  2. Under the Insert ribbon, click Illustrations. Note: You can skip this step in Excel 2010.
  3. Click Shapes under the Illustrations or Insert ribbon.
  4. Under Basic Shapes, select the Oval shape.
  5. Click any where on the sheet to place the oval.

Success!

Excel sheet with an oval shape.
Excel sheet with an oval shape.

Your oval is now a part of an Excel sheet. That is all to it.

Ideas

As you see, Excel is more than just an app to calculate numbers. You can do a lot with it. Now, we know you are wondering what you are going to do with a circle in Excel. Well, you can do a lot with it.

One thing you can do is, link it to a cell and have it update automatically every time you change the contents of the cell. For die hard users and developers, you can turn it into a clickable object or make it move, as in animation.

Additional Information

Related Quick Tips

Link a Cell to a Shape in Excel


Questions and Comments

If you have any questions or comments, feel free to contact us at training@techronology.com.


Quick Tips

Techronology Home