Draw Circle Around Cell in Excel
How to circle around a cell in Excel?
When you edit a worksheet, yous may want to draw a circle around a cell to evidence information technology obviously merely as beneath screenshot shown. Now I will introduce some tricks for yous to circumvolve around a prison cell in Excel.
Circle around a cell with Oval shape
Circle effectually a cell with VBA
Office Tab Enable Tabbed Editing and Browsing in Office, and Brand Your Work Much Easier...
Kutools for Excel Solves Nearly of Your Bug, and Increases Your Productivity by 80%
- Reuse Anything: Add the almost used or complex formulas, charts and anything else to your favorites, and chop-chop reuse them in the future.
- More than 20 text features: Extract Number from Text String; Excerpt or Remove Part of Texts; Catechumen Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into 1; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; 1 Workbook to Multiple Excel, PDF or CSV Files; One Cavalcade to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum past Groundwork Colour; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to whatsoever sheets; Sort by week, twenty-four hour period, frequency and more; Filter by bold, formulas, comment...
- More than than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Piece of cake deploying in your enterprise or arrangement.
Circle around a prison cell with Oval shape
To circumvolve effectually a prison cell, you need to insert an oval shape.
1. Click Insert > Shapes, and select Oval shape from the Bones Shapes section in the list. See screenshot:
ii. Describe the oval to circle around the prison cell you demand. Encounter screenshot:
iii. Correct click at the shape and select Format Shape from context carte du jour.
iv. In the Format Shape dialog (or Format Shape pane), click Fill tab, and drag the arrow of Transparency to the right to brand sure 100% displaying in the textbox. See screenshot:
5. Shut the dialog. At present yous can run across there is a circle around the cell.
Tip: In default, the shape will movement and resize with the cell.
Circumvolve around a cell with VBA
If you desire to quickly circle around a cell, you tin can use the VBA code.
1. Select the cell yous want to circle and press Alt + F11 keys together to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module and copy the follow VBA code to the popped out window.
VBA: Circle effectually a cell.
Sub DrawCircle() 'Updateby20141105 Dim Arng Every bit Range Dim WorkRng As Range Set WorkRng = Awarding.Option For Each Arng In WorkRng.Areas With Arng x = Arng.Superlative * 0.1 y = Arng.Width * 0.1 Awarding.ActiveSheet.Ovals.Add Top: = .Top - ten, Left: = .Left - y, _ Superlative: = .Height + 2 * ten, Width: = .Width + i.five * y With Awarding.ActiveSheet.Ovals(ActiveSheet.Ovals.Count) .Interior.ColorIndex = xlNone .ShapeRange.Line.Weight = ane.25 End With Terminate With Side by side WorkRng.Select End Sub 3. Press F5 key or click Run button to run the VBA code, now the selected cell is circled.
Tips:
(one) If you select multiple side by side cells in the starting time step, this VBA macro volition circle around these cells together.
(2) If you select multiple non-adjacent cells in the first step, this VBA macro will circle effectually each cell individually.
The Best Office Productivity Tools
Kutools for Excel Solves Near of Your Bug, and Increases Your Productivity by eighty%
- Reuse: Quickly insert circuitous formulas, charts and anything that you take used before; Encrypt Cells with password; Create Mailing Listing and send 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 up Cells Content; Combine Duplicate Rows/Columns... Preclude 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 Copy Multiple Cells without irresolute formula reference; Machine Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add together Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by calendar month/week/day, frequency and more than; Special Filter past bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Piece of cake deploying in your enterprise or organization. Full features 30-day gratis trial. 60-24-hour interval money dorsum guarantee.
Office Tab Brings Tabbed interface to Office, and Brand Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
- Open up and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by l%, and reduces hundreds of mouse clicks for you every 24-hour interval!
Source: https://www.extendoffice.com/documents/excel/2231-excel-circle-around-cell.html
0 Response to "Draw Circle Around Cell in Excel"
Post a Comment