How to Circle Text in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Suitable Ways to Circle Text in Excel

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.

How to Circle Text in Excel


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.

Use Basic Shapes to Circle Text in Excel

  • Now, your cursor will look like a “+” sign. Drag your cursor to create an oval shape around your desired text.

Use Basic Shapes to Circle Text in Excel

  • 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.

Use Basic Shapes to Circle Text in Excel

  • 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.

How to Circle Text in Excel

Notes

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.

Use Basic Shapes to Circle Text in Excel

Read More: How to Circle Something in Excel (2 Suitable Ways)


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.

Draw a Circle to Wrap Around Text in Excel

  • 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.

Draw a Circle to Wrap Around Text in Excel

  • 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.

Draw a Circle to Wrap Around Text in Excel

Read More: How to Circle Invalid Data in Excel (4 Suitable Ways)


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

Run a VBA code to Circle Text in Excel

  • Finally, press  F5  to run the code and go back to your worksheet.
  • You will find a circle around the selected cell.

Run a VBA code to Circle Text in Excel


Notes
  • 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 (4 Quick Tricks)


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

Alif Bin Hussain
Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo