Posted inExcel
Feedback collection
2 years ago
Checkbox in cell to represent TRUE/FALSE values
This is a request for a way to format a cell so it will that display boolean values as a checked box if TRUE, or an unchecked box if FALSE, and gray if there is no value. Although there are options to represent True/False values, they're not as smooth as a simple checkbox. For example, you can just type 1 or 0 into the cell, or use a Yes/No dropdown, but those are not as preferable.
Great news! We've added this.
WebGreat news! We've added this.
Official Microsoft response
Jake A.
Official Microsoft response
14 days agoCheckboxes have been released to the Current Channel. Go to Insert -> Checkbox to insert them. We look forward to your feedback!
Vote
57 comments