Learn how to use check marks and X’s in Excel to make your final work product much easier to read.
What Not to Do
For those who are not in the habit of using much formatting in Excel, the final version could look something like this:
Lame. Very lame. We can do much better than that.
How to Use Check Marks and X’s to Cells in Microsoft Excel
The video below provides an overview of how we can use check marks and x’s inside of cells in Microsoft Excel to illustrate whether or not a certain metric was met.
- Type a lowercase “a” in the cell for a check mark or a lowercase “r” in the cell for an “x.”
- Change the font for the cells in Step 1 above to “Webdings.” On the Home tab, look for the font drop-down box on the top left and change it to “Webdings.”
- Change the font color to green for the check marks and red for the x’s.
- Center the text in the cell by right-clicking on the cell and then choosing the “center” icon (see below for details).
- Increase the font size for the check marks, which are typically smaller than the x’s.
See below for an example of what the updated version could look like with the check marks and x’s.
If you enjoyed this content, you would love the Financial Analysis Kit, which is available absolutely free right now using the link below: