Now the shape is in the right general area, but it is not positioned ideally around the text in the cell. Right-click the cell where you want to paste the shape (B10), and choose Paste (Keep source formatting, or use the keyboard shortcut CTRL + V).ģ. Right-click the shape, and choose Copy (or use the keyboard shortcut CTRL + C).Ģ. To avoid formatting a new shape, you can copy the existing one and position it around cell B10.ġ. Now let’s say you want to circle another name (for example, Jennifer) with the same shape (transparent with a red outline). Note: You can also insert a shape using VBA code. To do this, click on the shape to select it, and in the Ribbon, go to Format Shape > Shape Fill (and Shape Outline). Similarly, you can also circle a range of cells by expanding the shape.Īnother option to format the shape is to use the options in the Ribbon. Then (3) click Line, and (4) choose the line color (red).įinally, the shape is transparent with the red outline, and the text in B5 is circled. (1) Click Fill, and (2) set the transparency to 100% (this removes the fill color of the shape). The Format Shape menu comes up on the right side of the screen.

To change the oval’s appearance, right-click on the shape and choose Format Shape.Ĥ. The shape needs to have a red line and transparent fill, so you can see the text from the cell underneath.ģ. Position it where you want to start the shape and drag the cursor to form the shape.Īs a result of this step, the oval is inserted, but as you can see below, the fill color and line color are both blue. Any shape that you insert will be added to the Recently Used Shapes section at the top.Ģ. Here you can choose to insert any shape offered (rectangle, circle, etc.). In the Ribbon, go to Insert > Shapes > Basic Shapes > Oval. You can circle, for example, Michael in cell B5 with a red oval.ġ.

Say you have the following list of names in Column B:

In Excel, you can circle a cell using the oval shape. In this article, you will learn how to make a circle around something in Excel and Google Sheets.

How to add circle in google docs