In this blog post, we will learn how to create a check box form control in Excel, use it to receive user input and store it in a cell.
A sample implementation is below.
![Final checkbox appearance](https://indzara.com/wp-content/uploads/2018/11/19-Final-checkbox-appearance.png)
We want to allow the user to choose the days that are weekend days.
Let’s type Day and Sunday.
If you select the Sunday cell and drag it down to 6 more cells, Excel will automatically populate the other weekdays.
![Fill the cells down](https://indzara.com/wp-content/uploads/2018/11/2-Fill-the-cells-down.png)
Excel fills the series for us to help with data entry, as it knows the common series such as days of week, months in a year, etc.
![Fill Series](https://indzara.com/wp-content/uploads/2018/11/3-Fill-Series.png)
Check Box does not work in Excel Online yet. So, if you plan to use your file online to edit in your browser, then please do not use this technique. Instead you can use the drop-down list technique.
1. Enable Developer Ribbon
Click on File –> Options.
![File Options](https://indzara.com/wp-content/uploads/2018/11/4-File-Options.png)
Select Customize Ribbon on the left sidebar and then check the box next to ‘Developer’ on the right side.
![Select Developer ribbon](https://indzara.com/wp-content/uploads/2018/11/5-Select-Developer-ribbon.png)
Press OK.
Now Developer ribbon appears.
![Developer ribbon appears](https://indzara.com/wp-content/uploads/2018/11/6-Developer-ribbon-appears.png)
2. Insert Check Box control
Insert Check Box control.
![Insert Check box control](https://indzara.com/wp-content/uploads/2018/11/7-Insert-Check-box-control.png)
Then, click where you want the box to be and drag to create the check box.
![Create first check box](https://indzara.com/wp-content/uploads/2018/11/8-create-first-check-box.png)
Right click on the check box and then select Edit Text.
![Right click and select Edit Text](https://indzara.com/wp-content/uploads/2018/11/9-Right-click-and-select-Edit-Text.png)
Remove the default text in the box. This is usually difficult to format. We will not need that text as we will use the text that we typed already in the previous column.
![Check box with no text](https://indzara.com/wp-content/uploads/2018/11/10-Check-box-with-no-text.png)
3. Link Check Box to a cell
Right Click and select Format Control.
![Right click and select Format Control](https://indzara.com/wp-content/uploads/2018/11/11-Right-click-and-select-Format-Control.png)
Now, we want to establish the link from the Check Box control to a cell.
![Select the Cell Link](https://indzara.com/wp-content/uploads/2018/11/12-Select-the-Cell-Link.png)
In the Control tab, select cell $F$4 as Cell link.
Now that we have created the link, when you click on the check box to select, the cell F4 will display TRUE.
![Selecting the check box will return TRUE](https://indzara.com/wp-content/uploads/2018/11/13-Selecting-the-check-box-will-return-TRUE.png)
If you click on the box again to uncheck or deselect, then the text display in cell F4 says FALSE.
![Unchecking the check box will return FALSE](https://indzara.com/wp-content/uploads/2018/11/14-Unchecking-the-check-box-will-return-FALSE.png)
This is how we can let the Check Box control change the value. If it is checked, Sunday is a weekend, if it is not checked, it is a working day.
![Weekday selection column](https://indzara.com/wp-content/uploads/2018/11/15-Weekday-selection-column.png)
4. Copying Check Boxes
Now, we need to create this for other 6 days.
- Select cell F4 and press Ctrl+C to copy.
- Now, select cells F5 to F10.
- Press Ctrl+V to Paste
![Create 6 more checkboxes](https://indzara.com/wp-content/uploads/2018/11/16-Create-6-more-checkboxes.png)
All the new checkboxes will also be pointing to the same cell F4.
We must change each of them to point to a different day (checkbox next to Monday should point to cell F5 (Monday).)
![Change cell link in all the checkboxes](https://indzara.com/wp-content/uploads/2018/11/17-Change-cell-link-in-all-the-checkboxes.png)
After changing all the check boxes, we will change the font color to white.
![Change font color to make the text invisible](https://indzara.com/wp-content/uploads/2018/11/18-Change-font-color-to-make-the-text-invisible.png)
This is done only for cosmetic purposes. Check box itself visually shows selected or not. So, we don’t need the display of TRUE or FALSE as well. Though the value is necessary for calculations, we don’t need it visible.
We will have the following appearance which is much cleaner.
![Final checkbox appearance](https://indzara.com/wp-content/uploads/2018/11/19-Final-checkbox-appearance.png)