![is doodlebob and the magic pencil an official game is doodlebob and the magic pencil an official game](https://i.ytimg.com/vi/tnlqauf7tSA/hqdefault.jpg)
The checkbox is a form control that is not embedded in a cell. 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. For selecting a checkbox, bring the mouse over the checkbox area (not the cell) and right click there. 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 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. 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. You may also copy the checkbox across a range of cells by simply using the mouse. For that, select the cell that contains a checkbox. Move the mouse pointer towards the right bottom of that cell until solid line + sign appears. Now, drag the fill handle to the range of cells where you want to copy that checkbox. You can see, we displayed checkboxes for showing the status of a product whether it is “In stock” or not. The ticked state means the specific product is in stock. 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 “Format Control” dialog should appear that enables you customizing the fill color, Line style (color, Style, Dashed, Arrows under the “Colors and Lines” tabs).
![is doodlebob and the magic pencil an official game is doodlebob and the magic pencil an official game](https://vignette.wikia.nocookie.net/mugen/images/1/1d/Krustykrab.png)
Similarly, you may press the size tab for changing height, width, and scale of a checkbox. 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. If a checkbox is ticked, it is taken as TRUE while for the unchecked state it is FALSE. The TRUE/FALSE values of the checkbox in ticked and un-ticked states can be visible if you link a cell to a checkbox. This can really be useful for making checkboxes more interactive. I will show one such example after this section, first have a look how TRUE/FALSE states can be reflected in cells. You can see, a few cells are displaying TRUE that are checked and others FALSE text that is unchecked. This can be done easily by following these steps. Right-click the checkbox for which you want to display TRUE/FALSE and select the “Format Control” option. You can see the Cell link text box as shown by the red arrow below: Select the Control tab in Format Control dialog box. That means the ticked/un-ticked state values (TRUE/FALSE) will display in the same cell where I created the checkbox. You may enter any other cell as per your requirement and press OK. Using the TRUE/FALSE value for more practical example Now tick/untick the checkbox and see the updated value in the linked cell. This TRUE/VALUE in the cell can be very useful.
![is doodlebob and the magic pencil an official game is doodlebob and the magic pencil an official game](https://i.ytimg.com/vi/eM5tPACLuWc/hqdefault.jpg)
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.