Add checkbox in a column in Excel sheet

Asked By 20 points N/A Posted on -


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

Answered By 0 points N/A #199695

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.



Login/Register to Answer

Related Questions