If the user wants to insert a checkbox in Excel worksheet, then this is not an easy task but this makes your work easier and your worksheet looks quite impressive. Hence, in this blog you will read how to insert Checkbox in Excel. For support, just contact to the support team of Microsoft via Office.com/setup.
Method To Insert Checkbox in Excel:
- Show Developer Tab on the Ribbon: To add Developer Tab in the Excel Ribbon, first you have to right click anywhere over the ribbon. Then, you should click on Customize the Ribbon option. Now, you should visit to the File option and then click on Options and after this, click on Customize the Ribbon.In the Customize the Ribbon, you should click on the Main Tabs and it is selected by default. After this, you should make a check sign over the Developer box and then tap on the OK option. When you get the Developer tab in your Excel ribbon, then you will get access to the interactive controls like CheckBox.
- Organize the Data: If you are making an excel checklist, then first you should make a list of items or tasks for which you are making the checkboxes.
- Add a checkbox: To add checkboxes in Excel, first you should go to the Developer tab and then select Controls group. After this, you should click on the Insert option and then choose the CheckBox under Form Controls. Now, you should click on the cell in which you wish to put your first checkbox. Then, you will view Checkbox control will be near it, but not exactly in that cell. If you want to keep the checkboxes in the proper position, then you should put your mouse pointer over it. When the pointer gets changed to four-pointed arrow shape, then you should drag down the checkbox where you wish to keep it. If you want to remove off the text “Check Box 1” from the checkbox then you should right click over the checkbox. And then select the text and just erase it. Or, you can also right click on the checkbox, and then click on the Edit Text option and then just delete the text. Now your checkbox is ready, then just copy it down to other cells.
- Copy Checkbox to other Cells: First, you should choose the cells which have the checkboxes by using arrow keys of your keyboard and then just place the cursor over the lower right hand side of the cell. If your mouse pointer changes to thick black cross shape then you should drag it to the place where you wish to copy the checkbox. Now, you have added the checkboxes to all the items which are there in the checklist.After this, you have to link a checkbox to a cell.
Create An Interactive Checklist In Excel:
If you want to link the checkbox with a certain cell, then you should right click over the checkbox. Now, you have to click on the Format Control option. Here in the opened Format Control dialog box, you should go to the Control tab. And then click on the cell link box and then select the empty cell over the sheet in which you want to link to the checkbox. At this point, you can also type the cell reference manually. You have to repeat the same steps for the remaining checkboxes. After this, click on each link of linked checkboxes. Then in linked cells, you will observe TRUE displays for the chosen checkboxes and false for cleared checkboxes.
How you can Delete A Checkbox In Excel? Office.Com/Setup
There are two ways to delete a checkbox in MS Excel.
First Method:
For this, first you have to select a checkbox and then press delete. But if you have more than one checkboxes in your worksheet, then you have to select all the checkboxes by pressing the control key. After this, you should press delete key to delete them all.
Second Method:
You can use the selection pane to delete them. For this, you have to go to home tab and then choose Editing. After this, you have to click on Find & Select and then choose Selection Pane. Then in selection pane, you will see the list of all the checkboxes which you have used in your worksheet. Here, you should select each of them one by one or you can also select more than one by one by using the control key. After selecting, you should press delete option.
With the help of above method, you can insert checkbox in Excel. For more information about Excel, just visit to the site of MS Office via Www.Office.Com/Setup.
Read Also –