![excel how to make check boxes linked to cell excel how to make check boxes linked to cell](https://cdn.extendoffice.com/images/stories/doc-excel/insert-multiple-checkboxes/doc-insert-multiple-checkboxes-10.png)
For example, in our example table, we have a Status column that tells whether a product is In Stock or Out of Stock.įor the demo, I have created another column containing checkboxes. This TRUE/VALUE in the cell can be very useful. Using the TRUE/FALSE value for more practical example Now tick/untick the checkbox and see the updated value in the linked cell. You may enter any other cell as per your requirement and press OK. That means the ticked/un-ticked state values (TRUE/FALSE) will display in the same cell where I created the checkbox. You can see the Cell link text box as shown by the red arrow below: Select the Control tab in Format Control dialog box. Right-click the checkbox for which you want to display TRUE/FALSE and select the “Format Control” option. This can be done easily by following these steps. You can see, a few cells are displaying TRUE that are checked and others FALSE text that is unchecked. I will show one such example after this section, first have a look how TRUE/FALSE states can be reflected in cells. This can really be useful for making checkboxes more interactive. The TRUE/FALSE values of the checkbox in ticked and un-ticked states can be visible if you link a cell to a checkbox. If a checkbox is ticked, it is taken as TRUE while for the unchecked state it is FALSE. You may play with other tabs for making a checkbox as per the need and liking.Īs mentioned earlier, the Excel checkboxes work in TRUE/FALSE states. Similarly, you may press the size tab for changing height, width, and scale of a checkbox.
![excel how to make check boxes linked to cell excel how to make check boxes linked to cell](https://i.ytimg.com/vi/LVu3E64w1-k/maxresdefault.jpg)
The “Format Control” dialog should appear that enables you customizing the fill color, Line style (color, Style, Dashed, Arrows under the “Colors and Lines” tabs). To access that, select the checkbox by right-clicking on it and press “Format Control”: You may change the look of the checkbox by using “Format Control” option. The ticked state means the specific product is in stock. You can see, we displayed checkboxes for showing the status of a product whether it is “In stock” or not. Now, drag the fill handle to the range of cells where you want to copy that checkbox. Move the mouse pointer towards the right bottom of that cell until solid line + sign appears. For that, select the cell that contains a checkbox. You may also copy the checkbox across a range of cells by simply using the mouse. If you have large Excel sheet with plenty of data and you require using checkboxes then creating a checkbox one by one can be a tedious task. For modifying the caption/visible text of the checkbox, right click in the checkbox and press the Edit Text option as shown below: The default text is not something that you want in your Excel table. The checkbox should be selected.įor moving the checkbox, use the arrow keys on the keyboard OR as Move icon appears while you hover over the checkbox, use the mouse for moving checkbox anywhere. For selecting a checkbox, bring the mouse over the checkbox area (not the cell) and right click there. Instead, you can place it over a cell and linked any cell to its True/False states.Īfter a checkbox is placed in the Excel sheet, you may move it by selecting that checkbox.
![excel how to make check boxes linked to cell excel how to make check boxes linked to cell](https://cdn.extendoffice.com/images/stories/doc-excel/insert-multiple-checkboxes/doc-insert-multiple-checkboxes-6.png)
The checkbox is a form control that is not embedded in a cell. Under the Developer tab, press Insert and look for checkbox as shown below:Īfter clicking the checkbox under the form control, click in the area of excel sheet (in a cell) where a checkbox should be inserted. If you are using Excel 2007, then go to Microsoft Icon on the top left –> Excel Options –> Popular –> “Show Developers tab in the Ribbon”. There, you may see the “Developer” checkbox – Tick this and press OK. In Excel 2010 and above, go to File –> Options –> Customize Ribbon. If Developer tab is not visible, this is how you may configure it to display. For placing a checkbox in a sheet, go to the “Developer” tab. The checkbox is a form control in Excel that you may place over a cell. Steps for inserting checkbox into Excel sheet This is followed by a few examples of using it for different Excel tables, so you can see checkboxes in action.
![excel how to make check boxes linked to cell excel how to make check boxes linked to cell](https://cdn.extendoffice.com/images/stories/doc-excel/doc-checkbox-checked-based-on-cell-value/doc-checkbox-checked-based-on-checkbox-1.png)
In this tutorial, I am going to show you how to create checkbox (also called tick box) in the Excel sheet. If that Excel checkbox is un-ticked state, some other value can be displayed in the same associated cell.įor example, display Pass as the checkbox is ticked and Fail as it is unchecked on a student result sheet. If the checkbox is in the True state by ticking, you may display a particular value in an associated cell. Similarly, you may turn a checkbox “On and Off” more accurately True/False. If you On a switch to a machine, it should start working and in the Off state, it should stop.