Microsoft Excel – creating a checkbox for several cells in a column

I was recently asked how to create a checkbox which could be copied and pasted into a range of cells in Excel.

To work with checkboxes, you first have to have the Developer tab showing on the ribbon. To do this in Excel 2010, go to File – Options – Customize Ribbon, then on the Customize Ribbon section on the right, put a tick next to Developer and click OK. If you are using Excel 2007, go to the Office button, click Excel Options, then on the Popular tab, put a tick next to Show Developer tab in the Ribbon, then click OK.

To be able to insert a check box and adjust its size, I find it easiest if I first Zoom my worksheet so the cells look bigger for manipulation purposes.

Then on the Developer tab, in the Controls group, click the Insert dropdown and select the Check Box from the Form Controls. Using the mouse, size the checkbox in the first required cell.

Ensure Design mode is selected in the Controls group, right-click on the check box and select Edit Text. Remove the text from the control.

Now select the cell which contains the check box, and use the fill handle to copy down to the other required cells.

Find out more about our Excel training courses London, UK.

Find out more about our Excel training courses Dorset, Hampshire, Wiltshire, UK.

Find out more about our Excel training courses Sydney, Australia.




About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s