how to ring a cell in red pen?

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,397
Office Version
  1. 2007
I'm writing a user guide for one of my workbooks.

I want to use screen grabs and highlight the relevant cell as you might by ringing it with a red pen - i'm sure you've all seen this effect, I see it all the time in excel tutorials.

How is this done? Is there a drawing shape which looks like this?
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Try this:
Insert menu
Choose shapes
There are oval shapes
Choose no fill
Hold down shift key while dragging to make perfect round circle
Choose Outline
Format to your likeing
Etc.
 
Last edited:
Upvote 0
For most of those circled screen grabs that you see, the circle is added by the grabbing/editing software and not by Excel.

Following My Answer Is This's advice will show you why most folks find it easier to add the circle with other software. For screen grabs.

If you want your worksheet to have a circle, the internal to Excel method has to be used.
 
Upvote 0
For most of those circled screen grabs that you see, the circle is added by the grabbing/editing software and not by Excel.

Following My Answer Is This's advice will show you why most folks find it easier to add the circle with other software. For screen grabs.

If you want your worksheet to have a circle, the internal to Excel method has to be used.

Can you give an example of an grabbing/editing software that does this?
 
Upvote 0
ezosEbT.gif
 
Upvote 0
I can put a circle around my cell in fifteen seconds I'm surprised that's considered a long time. And you can make one circle and the duplicate it by holding down the ctrl while dragging. Creating twenty circles in another fifteen seconds.
 
Upvote 0
I usually use snipping tool, which I personally think is a great tool, but I would normally would paste the image into a word document, and then in word add a red circle on top of the image. I'm very interested in a faster approach.
 
Upvote 0
I use the insert shape using Excel 2013. Your could record a Macro and then have a shape on the screen in seconds. For example this script.
Code:
Sub MakeCircle()
'
' MakeCircle Macro
    ActiveSheet.Shapes.AddShape(msoShapeOval, 141, 95.25, 131.25, 96.75).Select
    Selection.ShapeRange.Fill.Visible = msoFalse
    With Selection.ShapeRange.Line
        .Visible = msoTrue
        .ForeColor.RGB = RGB(255, 0, 0)
        .Transparency = 0
    End With
    With Selection.ShapeRange.Line
        .Visible = msoTrue
        .Weight = 4.5
    End With
    Range("F16").Select
End Sub
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,877
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top