Excel Check Boxes, Even Simpler Way
That got me thinking,
- Who is this user we keep talking about 😕
- Why not ?!?
In excel, you can add a check-box to spreadsheet using developer tools. See to the right:
But what if you needed a whole bunch of check-boxes?
Well, you could add one check box and copy paste the same a bunch of times. Only problem will be, all of them will refer to the same cell. Thus you check one, you check all. Checking out all might be a good option if you are in a party without a date. But, in excel, you need to be a bit more specific, no?
So, I created a bunch of check boxes, each linked to one separate cell. And now, being the good, caring and lovable person I am, I have placed them for download. So go ahead and get your bunch of check boxes, while the supplies last.
Once you have the file, all you need to do is, copy paste as many check boxes to your workbook as you want (there are a total of 30 in there). Change the display text to whatever fancies you at the moment. And you are good to go.
I can imagine 2 colleagues in a cube farm talking,
Colleague 1: Wtf, the checkboxes don’t work.
Colleague 2: Didnt you get them from Chandoo.org?
Colleague 1: No, I added them myself.
Colleague 2: No wonder 😛
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
More awesome tips for you:
Leave a Reply
|How to get tick marks in Excel? [custom cell formatting]||Master Excel 2007 Ribbon with this Free Learning Guide|