# How to Put a Circle Around a Number in Excel (4 Quick Tricks)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, I am going to share with you 4 quick tricks to put a circle around a number in Excel. You can easily apply these methods in any set of data to arrange the numerical values inside circles or any other shapes. To achieve this task, we will also see some useful features that might come in handy in many other Excel-related tasks.

## How to Put a Circle Around a Number in Excel: 4 Quick Tricks

We have taken a concise dataset to explain the steps clearly. The dataset has approximately 7 rows and 3 columns. Initially, we are keeping all the cells in General format. For all the datasets, we have 3 unique columns which are Product ID, Product Name, and Sales (units). Although we may vary the number of columns later if that is needed.

### 1. Using Excel Illustrations Feature

In this first method, we will use the Excel illustrations feature to put a circle around a number. Follow the steps below to do this.

Steps:

• First, go to the Insert tab and click on Shapes under Illustrations.

• Next, select the Oval shape from the list of available shapes.

• As a result, this will insert the oval shape where you click on the sheet.

• Then, select the shape and navigate to the Shape Format tab at the top of the screen.
• Next, click on the Shape Fill drop-down and select No Fill.

• Consequently, this will create a circle around the number in the dataset.

Read More: How to Draw a Circle in Excel with Specific RadiusÂ

### 2. Inserting Excel Symbol to Put Circle Around a Number

We can also use the symbol options in Excel to put a circle around a number very easily. Let us see how to do that in a few steps.

Steps:

• To begin with, go to the Insert tab and click on Text Box under Text.

• As a result, this will insert a text box on the location you click on the sheet.
• Now, again go to the Insert tab and click on Symbol under Symbols.

• Next, in the Symbol window, select the Circle symbol and click Insert.

• Immediately, you should see the circle shape inside the text box.

• Finally, move the circle to the position you desire and this will give you the final result.

Read More: How to Create Concentric Circle Chart in Excel

Another very useful option we have in Excel is the Quick Access Toolbar which gives us a quick and easy way to get to any commands. Below we shall see how to apply this to put a circle around a number very easily.

Steps:

• Next, click on More Commands.

• Now, in the Excel Options window, select All Commands under Choose commands from.
• Then, select the Oval option and click on Add.
• After that click OK.

• As a result, this will add the Oval shape command in the Quick Access Toolbar as in the image below.
• Now, click on the Oval shape and again click on the sheet where you want to insert the shape.
• Finally, format the shape as we saw before and you should get the following result.

Read More: How to Draw a Mohr Circle in Excel

### 4. Applying Excel VBA to Put a Circle Around a Number

If you are familiar with VBA in Excel, then you can put a circle around a number with just a few clicks. Below are the steps to achieve this.

Steps:

• First of all, go to the Developer tab and click on Visual Basic.

• Next, in the new window, click on Insert and select Module.

• Then, in the Module window enter the following code:
``````Sub CircleToNumber()
Â Â Â  Dim p, s As Single, Sh_area, Sh_oldrange As Range
Â Â Â  Set Sh_oldrange = Selection.Cells(1)
Â Â Â Â Â Â  For Each Sh_area In Selection.Areas
Â Â Â Â Â Â  With Sh_area
Â Â Â Â Â Â Â  p = .Height * 0.1
Â Â Â Â Â Â Â  s = .Width * 0.1
Â Â Â Â Â Â Â Â  ActiveSheet.Ovals.Add Top:=.Top - p, Left:=.Left - s, _
Â Â Â Â Â Â Â Â Â  Height:=.Height + 2 * p, Width:=.Width + 1.5 * s
Â Â Â Â Â Â Â  With ActiveSheet.Ovals(ActiveSheet.Ovals.Count)
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  .Interior.ColorIndex = xlNone
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  .ShapeRange.Line.Weight = 1.25
Â Â Â Â Â Â Â  End With
Â Â Â Â Â Â Â  End With
Â Â Â  Next Sh_area
Sh_oldrange.Select
End Sub``````

In the above code, we are initially declaring Single and Range type variables. The Selection method allows us to work with the selected cells. The ActiveSheet.Ovals.Add command adds the oval shape in the set location from the top and left. Finally, Interior.ColorIndex portion sets the fill color of the shape to null.

• After that, go to the Developer tab and click on Macros.

• Now, in the new Macro window, select the macro CircleToNumber and click on Run.

• Consequently, this will add an oval to the cell you are currently in and you can convert this into a circle by resizing the shape.

## Conclusion

I hope that you were able to apply the methods that I showed in this tutorial on how to put a circle around a number in Excel. As you can see, there are quite a few ways to achieve this. So wisely choose the method that suits your situation best. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion.Â If you have any queries, please let me know in the comments.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF