how do you circle an item on an excel document

[KNOWAK]

i HAVE A FORM THAT I AM USING CREATED IN EXCEL. I NEED TO CIRCLE A NUMBER
PRESENTED ON THE FORM. HOW DO I CIRCLE A NUMBER ON THE FORM WITH EXCEL

 

[Dan]

I found this link:

http://office.microsoft.com/en-us/help/HA102083161033.aspx

 

[Jim Thomlinson]

Open up the drawing toolbar and drag an oval on your spreadsheet.

Tools | Customize | Toolbars -> check Drawing Toolbar
on the drawing toolbar is an icon with an oval on it. Click that button.
Your cursor will turn into a cross hair. Place the crosshai in the corner of
the cell you want to circle and while holding down the mouse button drag the
cursor to create your circle...

 

[Gord Dibben]

If you have many of these to do you can select multiple cells using CTRL +
Click then run this macro.

Sub My_Circle()
Dim X, Y As Single, area As Range
'rotate through areas - this allows multiple circles to be drawn
For Each area In Selection.Areas
With area
' x and y are numbers that are a function of the
' area's height and width
X = .Height * 0.1 'adjust to suit
Y = .Width * 0.1 'adjust to suit
ActiveSheet.Ovals.Add Top:=.Top - X, Left:=.Left - Y, _
Height:=.Height + 2 * X, Width:=.Width + 1.5 * Y
ActiveSheet.Ovals(ActiveSheet.Ovals.Count) _
.Interior.ColorIndex = xlNone
End With
Next area
End Sub


Gord Dibben MS Excel MVP