Now select the cell which contains the check box, and use the fill handle to copy down to the other required cells.įind out more about our Excel training courses London, UK.įind out more about our Excel training courses Dorset, Hampshire, Wiltshire, UK.įind out more about our Excel training courses Sydney, Australia. Using the mouse, size the checkbox in the first required cell.Įnsure Design mode is selected in the Controls group, right-click on the check box and select Edit Text. Then on the Developer tab, in the Controls group, click the Insert dropdown and select the Check Box from the Form Controls. 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. 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 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. To work with checkboxes, you first have to have the Developer tab showing on the ribbon. Step 3: Do the same for the rest of the cells, and you will get all the results as ‘Unsold’ as the checkbox is unchecked. IF (F5,'Sold','Unsold') Press Enter to see the first result.

I was recently asked how to create a checkbox which could be copied and pasted into a range of cells in Excel. Step 2: Type the formula in cell D5 to apply the IF It will show ‘Sold’ for TRUE value and ‘unsold’ for the FALSE value.

Checkbox for excel 2010