Create Harvey Balls in Excel?

G

Guest

How would I create Harvey Balls in Excel? (Circles full, half full etc that I
can use in a drop down selection menu)
 
J

JE McGimpsey

Mrebisz3154 said:
How would I create Harvey Balls in Excel? (Circles full, half full etc that I
can use in a drop down selection menu)

Using a font that contains these characters, put one character each in a
vertical range of cells (perhaps on another, hidden, worksheet) and name
the range (say, "harvey"). In the cell to contain the dropdown, choose
Data/Validation:

Allow: List
Source: =harvey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top