N/APosted on - 12/17/2013
I have prepared an Excel sheet that consists of a few columns. In two of these columns, I would like to add a checkbox each so it gets checked for every order I get. Is it possible to creat a check box in a column? How can this be done, please give me a step by step tutorial. Thanks
Add checkbox in a column in Excel sheet
To insert Checkboxes in a spreadsheet you need to use the Developer tab. This solution is based on Excel 2007:
To activate the Developer Tab:
1 Click on the Office Button and select “Excel Options”
2 Select “Popular” if this is not already selected
3 Select the “Show Developer tab in the Ribbon” checkbox and click OK.
To insert the Checkbox:
1 Select the Developer tab
2 Click on the Insert icon
4 Select the Checkbox button
5 Click on the area where you want you checkbox to appear
6 Right click on the Checkbox and select Format control to customize the appearance and behavior of the Checkbox.