Do you want to put a circle around a number on your Excel sheet, like a highlight, without coloring the cell? In this article, we will explain methods on how to put a circle around a number on your Excel sheet.
How to put a Circle around a Number in Excel
Follow the methods below to put a circle around a number in Excel.
- Using the Illustration feature.
- Using Symbol
- Using the Quick Access Toolbar
1] Using the Illustration feature
On the Insert tab, click the Illustration button, click Shapes, and select the oval shape from the menu.
Draw the shape on the spreadsheet; make it small.
Now go to the Shape Format tab, click the Shape Fill button, and select No Fill from the menu.
Now, drag the oval shape over the number that you want to circle.
2] Using Symbol
On the Insert tab, click the Text button and select Text Box from the menu.
Draw the text box on the spreadsheet.
On the Shape Format tab, click the Shape Fill button and select No Fill from the menu.
Double-click the text box.
Then go back to the Insert tab, click the Symbol button, and select Symbol from the menu.
A Symbol dialog box will open.
Click the Font box, select (Normal Text) and the Subset should be ‘Combining Diacritical Marks for Symbol.’
Select the circle, then click Insert.
The Symbol is inserted into the textbox.
Move the text box over the number that you want to be circled; the circle symbol will move with it.
If you want to increase the symbol, Highlight the symbol, then click the Font size button and select a size from the list.
Select the text box.
Then, go to the Shape Format tab, click the Shape Outline, and select No Outline.
The outline around the text box will disappear.
3] Using the Quick Access Toolbar
Click the drop-down arrow on the Quick Access Toolbar and select More Commands from the menu or click the File tab and select Options from the backstage view.
An Excel Options dialog box will appear.
Click the Quick Access Toolbar on the left.
In the Choose from command list, select all commands.
Then scroll down to Oval, click Add, then click OK.
The oval shape is added to the Quick Access Toolbar.
Click the Oval command on the Quick Access Toolbar and draw it over the number.
Then click the Shape Format tab, click the Shape Fill button, and select No Fill from the menu.
Now, the number is circled.
How do you make a number with a circle around it?
On the Insert tab, click the Illustration button, click Shape, and select Oval from the menu. Draw the oval shape on the spreadsheet. Right-click the Shape, select Edit Text, and enter the number into the shape.
READ: How to view or display Document Properties in Excel
How do I make a text box in a circle in Excel?
On the Insert tab, click the Text button and select Text Box from the menu. Draw the text box on the spreadsheet. Click the Shape Format button, Click the Edit Shape button, hover the cursor over Change Shape, and select Oval from the menu. Use the points around the shape to turn it into a circle. Now we have a circle.
READ: How to remove Scientific Notation in Excel
I hope you understand how to put a circle around a number in Excel.
Leave a Reply