Circles
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Circles

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way that numbers in Excel can be circled. I have tried using the Windows Character Map but that only goes up to 10 ?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Possibly not what you want but there is a way. Select the cells you want to be circled, click on Data-Validation and enter a validation condition to suit the cells you want to be circled. Then click on Tools-Auditing and show the Auditing toolbar. Click on the icon with the tooltip 'Circle invalid data'. I'm not sure if you can format the circle (it can look a bit odd), and apologies if this isn't what you meant.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    autoshapes might help too

    insert
    picture
    autoshapes
    flowchart

    there's a circle in there, drag it over your cell and adjust the size n shape : it defaults to non-transparent, hiding your number, so right click on it

    format auto shape
    fill colour = no fill

    not sure you can automate it via relative macro cos of the placing, but you can copy paste the circle as normal.


    :: Pharma Z - Family drugstore ::

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks guys it solved the problem.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com