Checkmarks in Excel
July 19, 2018 - by Bill Jelen
Creating checkmarks in Excel is usually a hassle. Yes, you could type a capital letter P and change the font to Wingdings 2, but who can remember that combination?
I was discussing Icon Sets in my Power Excel seminar in Atlanta and a fellow named Jack Whipple explained how he uses icon sets to create checkmarks in Excel.
Jack has a list of things that have to be completed during month-end close. He adds a symbol next to each item:
Here is the system in action. Jack explains that he uses the empty circle to indicate things that are not done. If he prints the list and carries it around on a clipboard, he can add a checkbox inside the circle to manually mark things as he walks around.