Creating checkboxes in Google Sheets or creating check boxes in Google Sheets helps us make quick surveys right in the data table. Or creating a checklist in Google Sheets also makes it easier for you to compile content statistics, through counting the number of checkboxes in Google Sheets. And how to create checkboxes in Google Sheets is very simple, with many different ways to do it according to the tutorial below.
1. How to insert tick box on Google Sheets using Checkbox
Step 1:
You can log in to Google Sheets and enter the content you want to create a checkbox, or create a checkbox and insert the content.
Next select the content you want to insert the checkbox and click Insert item (Insert) on the toolbar and press Checkbox (Tick box).
Step 2:
Soon we will see the checkbox appear in the selected content.
To continue entering check boxes into the remaining content, scroll down to the remaining cells or click copy.
To adjust the size of these tick boxes, you need to adjust the text size in the toolbar. If you want to delete the tick box in any content, you need to select it and then press the Delete key.
2. Insert Google Sheets checkbox using Data Validation
Additionally, Google Sheets also allows passing custom values with checkboxes. For example, a checkbox assigned the value TRUE will be selected, and a checkbox that is not selected will be assigned the value FLASE.
Step 1:
Select the checkbox containing the value you want to change, then click Data section (Data) in the toolbar, select Data validation… (Data validation).
Step 2:
In the new interface, select the box Use custom cell values (Use custom cell values). Enter custom cell values in Ticked and Unticked.
Then press Save button (Save) to save.
Finally we will have a complete list as shown below.
3. How to insert checkboxes in Google Sheets using keyboard shortcuts
Step 1:
At the Google Sheets interface, click Help section then select Shortcuts section in the displayed list.
Step 2:
Displays the shortcut interface for us to set up. First you Enable the Enable Compatibility Shortcuts in Worksheets setting.
So you can use keyboard shortcuts in Google Sheets data tables.
Step 3:
Now you Press the key combination Alt + I + X, Press these 3 keys consecutively on the keyboard. And the results will display the checkbox in the data table as shown below.
Now you just need to drag the first checkbox down like the other checkbox you want to insert.
4. Insert checkbox in Google Sheets using the CHAR function
The CHAR function is a function that returns a character in the character set used based on the number from 1 to 255 corresponding to that character in the code. The checkbox icon in Windows has the code 9989. You just need to apply CHAR function formula is =CHAR(table_number) It's okay to show the checkbox in Sheets.
5. Insert checkbox into Google Sheets as an image
In case you just want to use the checkbox as a guide, do not need to check it and want a more beautiful checkbox style, you can insert it as an image.
We find the checkbox image you want to use online and insert it into Google Sheets as usual.
Note, when inserting an image in Google Sheets, which here is a checkbox image, you must select it insert image in cell.
The checkbox image results can also be inserted into the Google Sheets spreadsheet.
So you have many ways to insert checkboxes in Google Docs, depending on each person's needs when inserting checkboxes into Google Sheets.