Sometimes you might need to enclose a text inside a circle to highlight it or for some other purpose while working on Excel. You can do this easily and quickly by following a few steps. In this article, we will show you how to circle text in Excel in 3 easy ways.
How to Circle Text in Excel: 3 Suitable Ways
In this article, we will demonstrate 3 easy methods using the Basic Shapes, Shapes command, and VBA code to circle text in Excel. We will use the following dataset for this purpose.
1. Use Basic Shapes to Circle Text in Excel
In this method, you will learn how to use basic shapes to circle text in Excel. The steps to do it are discussed below.
Steps:
- First of all, go to the Insert tab and click on Shapes.
- Next, select Oval from the Basic Shapes category.
- Now, your cursor will look like a “+” sign. Drag your cursor to create an oval shape around your desired text.
- Once you create the oval shape, it will be filled with color by default.
- To remove the color, right-click on the shape and go to Format Shapes or go directly to Fill.
- Then select No Fill to make the text visible.
- Finally, you will have your text inside the circle.
- Similarly, you can create a circle with text for the rest of the cells as you want.
If you want to curve your text around a circle, you can follow the next steps.
- First, insert a Textbox in your worksheet and type your desired text.
- Then go to Text Effects under the Shape Format tab and select Transform.
- From there, select Circle.
- Finally, keep increasing your text size until it makes a complete circle.
Read More: How to Circle Something in Excel
2. Draw a Circle to Wrap Around Text in Excel
Now we will draw a circle to wrap around the text in Excel. We will follow the simple procedure discussed below to do so.
Steps:
- First, click on Shapes from the Insert tab and select Curve under Lines.
- The cursor will look like a “+” sign now. Move your cursor and use the left button of the mouse to create a circular shape around your text.
- Once you are done drawing the shape, the shape will have a default fill color.
- To remove the fill color and make the text visible, click on Fill and select No Fill.
- Now you will find the text visible inside the drawn circle.
Read More: How to Create Concentric Circle Chart in Excel
3. Run an Excel VBA to Circle Text
We can also use a VBA code to create a circle around text. Read the following steps to learn how to do it.
Steps:
- First of all, select the cell you want to circle.
- Next, press Alt+F11 to open the Microsoft Visual Basic window.
- Then click on Module under the Insert tab.
- After that, copy the following VBA code and paste it into the Module.
Sub VBA_Circle_Text()
Dim CircRNG As Range
Dim JobRng As Range
Set JobRng = Application.Selection
For Each CircRNG In JobRng.Areas
With CircRNG
m = CircRNG.Height * 0.15
n = CircRNG.Width * 0.2
Application.ActiveSheet.Ovals.Add Top:=.Top - m, Left:=.Left - n, _
Height:=.Height + 2.25 * m, Width:=.Width + 1.75 * n
With Application.ActiveSheet.Ovals(ActiveSheet.Ovals.Count)
.Interior.ColorIndex = xlNone
.ShapeRange.Line.Weight = 2
End With
End With
Next
JobRng.Select
End Sub
- Finally, press F5 to run the code and go back to your worksheet.
- You will find a circle around the selected cell.
- You can use shapes to wrap the text by following the same steps.
- In case of curving the text around a circle, don’t forget to increase the text size, otherwise, you won’t get the complete circle.
Read More: How to Put a Circle Around a Number in Excel
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
Conclusion
Thanks for making it this far. I hope you find this article useful. Now you know three suitable ways to circle text in Excel. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.
Related Articles
<< Go Back to Circle in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
