- Jul 15
Ensure a Single Check Box Selection
- Neale Blackwood
- Tips & Shortcuts, Charts
- 0 comments
Check boxes are supposed to be used to allow multiple selections. But since they are now so easy to insert, you might want to use them to allow a single selection. Here’s one way to do that.
Sign up to hear about free Excel training.
I won't share your email with anyone.
1 min read
In the image below I have a chart from a blog post last year.
One of the columns has been highlighted via clicking a checkbox in column D.
But as you can see below you can also highlight another column.
If you only want one column to be highlighted, you can use Excel’s data validation to stop more than one check box being clicked.
Make sure only one or no check box is selected.
With the range D2:D7 selected press in sequence Alt D L.
In the dialog that opens, click the Allow: drop down and select Custom.
In the Formula: box enter the following formula.
=COUNTIF($D$2:$D$7,TRUE)<=1This formula ensures only one check box can be selected at a time.
You now must uncheck the selected check box before you can select another check box.
