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.