Add checkbox in a column in Excel sheet

Asked By Alberto Dexter 20 points N/A Posted 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

• Status: Open
• Question Views: 1368
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Holzman Warren 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.

 

 

About Holzman Warren

Questions
0

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/18/2013
• Question Category: MS Excel