Results 1 to 3 of 3

Thread: What is the way to circle a number in Microsoft Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    105

    What is the way to circle a number in Microsoft Excel

    I want to focus the reader's attention on a particular cell, by circling it. How do I do that in Excel.

  2. #2
    Join Date
    Nov 2010
    Posts
    503

    Re: What is the way to circle a number in Microsoft Excel

    You can do that by opening the Drawing toolbar if your version of Excel is 2003 or less. Then select the oval tool and circle the cell you want to draw attention to. If you're using 2007 click INSERT on the ribbon and then click Shapes. In the BASIC SHAPES category locate the oval tool and then circle the cell. You'll have to format the drawing object so that it's transparent so you can view the cell contents. If you need a perfect circle hold down a shift key and then draw your oval. The shift key will force the oval to a perfect circle.

  3. #3
    Join Date
    Nov 2010
    Posts
    422

    Re: What is the way to circle a number in Microsoft Excel

    There is no default way to do that. All you can do is insert the same via object and then format it to set the value as behind text. You can do that by right-clicking on the object and then choosing format object. Other than this there is not other way. Or you can simply create am macro for the entire process and run it whenever you need to add a circle to the number.

Similar Threads

  1. How to get circle around a Text in Microsoft Excel
    By M.N.S in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 12:57 PM
  2. Adding digit in front of number in cell in Microsoft Excel
    By Thedevotee in forum MS Office Support
    Replies: 2
    Last Post: 07-02-2012, 07:45 PM
  3. Replies: 2
    Last Post: 01-02-2012, 07:10 PM
  4. Replies: 5
    Last Post: 11-07-2011, 10:38 AM
  5. How to draw a circle in Excel 2007
    By Daksha90 in forum Windows Software
    Replies: 5
    Last Post: 13-06-2011, 08:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,708,484.72457 seconds with 17 queries