How To Draw A Circle In Excel

How to circle around a jail cell in Excel?

When you lot edit a worksheet, you may want to draw a circumvolve around a cell to show it evidently just as below screenshot shown. Now I will introduce some tricks for you lot to circumvolve around a cell in Excel.

Circle effectually a cell with Oval shape

Circle around a cell with VBA

Office Tab Enable Tabbed Editing and Browsing in Office, and Brand Your Work Much Easier...

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

• Reuse Anything: Add the most used or circuitous formulas, charts and anything else to your favorites, and quickly reuse them in the hereafter.
• More than xx text features: Extract Number from Text Cord; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
• Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Indistinguishable Rows and Sum.
• Separate Tools: Separate Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
• Paste Skipping Hidden/Filtered Rows; Count And Sum by Groundwork Colour; Ship Personalized Emails to Multiple Recipients in Bulk.
• Super Filter: Create avant-garde filter schemes and apply to whatsoever sheets; Sort by week, mean solar day, frequency and more than; Filter by bold, formulas, annotate...
• More than 300 powerful features; Works with Function 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

---

Circle around a cell with Oval shape

---

To circle effectually a cell, you demand to insert an oval shape.

1. Click Insert > Shapes, and select Oval shape from the Basic Shapes section in the list. Meet screenshot:

ii. Draw the oval to circle around the prison cell you demand. Encounter screenshot:

three. Right click at the shape and select Format Shape from context carte.

four. In the Format Shape dialog (or Format Shape pane), click Fill tab, and drag the arrow of Transparency to the right to make sure 100% displaying in the textbox. Run across screenshot:

5. Close the dialog. At present you lot can see there is a circle around the jail cell.

Tip: In default, the shape will move and resize with the cell.

---

Circle around a cell with VBA

If you lot want to rapidly circle effectually a cell, you can use the VBA code.

1. Select the cell y'all desire to circle and press Alt + F11 keys together to open the Microsoft Visual Bones for Applications window.

ii. Click Insert > Module and copy the follow VBA code to the popped out window.

VBA: Circumvolve around a jail cell.

                Sub DrawCircle() 	'Updateby20141105 	Dim Arng As Range 	Dim WorkRng As Range 	Gear up WorkRng = Application.Selection 	For Each Arng In WorkRng.Areas 		With Arng 			x = Arng.Height * 0.1 			y = Arng.Width * 0.ane 			Awarding.ActiveSheet.Ovals.Add Top: = .Meridian - x, Left: = .Left - y, _ 			Height: = .Height + 2 * x, Width: = .Width + ane.five * y 			With Application.ActiveSheet.Ovals(ActiveSheet.Ovals.Count) 				.Interior.ColorIndex = xlNone 				.ShapeRange.Line.Weight = 1.25 			End With 		Cease With 	Next 	WorkRng.Select End Sub                              

3. Press F5 cardinal or click Run push button to run the VBA lawmaking, at present the selected prison cell is circled.

Tips:

(ane) If you select multiple next cells in the beginning step, this VBA macro will circle effectually these cells together.

(2) If you select multiple non-adjacent cells in the first pace, this VBA macro will circle around each cell individually.

---

The Best Function Productivity Tools

Kutools for Excel Solves Virtually of Your Problems, and Increases Your Productivity by fourscore%

• Reuse: Quickly insert complex formulas, charts  and anything that you have used earlier; Encrypt Cells with password; Create Mailing List and ship emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Re-create Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Excerpt Text, Add together Text, Remove by Position, Remove Space; Create and Impress Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (salvage and employ filter schemes to other sheets); Advanced Sort by calendar month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on central columns; Split Data into Multiple Sheets; Batch Catechumen xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-solar day costless trial. 60-day money back guarantee.

---

Office Tab Brings Tabbed interface to Role, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Projection.
• Open and create multiple documents in new tabs of the aforementioned window, rather than in new windows.
• Increases your productivity past 50%, and reduces hundreds of mouse clicks for yous every day!

Source: https://www.extendoffice.com/documents/excel/2231-excel-circle-around-cell.html

Posted by: levineingle1968.blogspot.com

Share this post