How to insert checkboxes on Google Sheets

When working with content as an option list, adding a checkbox will make it easier for you to manage. On Google Sheets, the checkbok feature or check box has been added to this online editor. The tool is available in the interface on the toolbar so you just need to press select to use. Thus, users do not need to insert a formula or function to insert checkbok on Google Sheets.

1. Tricks using Google Sheets should not be ignored
2. List of common shortcuts for Google Sheets on computers (Part 1)
3. How to highlight duplicate content on Google Sheets

How to insert a box on Google Sheets

Step 1:

You sign in to Google Sheets and enter the content you want to create the checkbox, or create the checkbox to insert the content.

How to insert checkboxes on Google Sheets Picture 1

Next select the content you want to insert the checkbox and then click Insert in the toolbar and click the Check box (Tick box).

How to insert checkboxes on Google Sheets Picture 2

Step 2:

Soon we will see a checkbox that appears in the selected content.

How to insert checkboxes on Google Sheets Picture 3

To enter the check box for the remaining content, scroll down to the remaining boxes or click copy.

To resize these tick box cells, you need to adjust through the font size in the toolbar. If you want to delete the tick box in any content, press it and press the Delete key next.

How to insert checkboxes on Google Sheets Picture 4

Step 3:

In addition, Google Sheets also allows to transfer custom values ​​with checkboxes. For example, the checkbox that is assigned TRUE value will be selected and the unchecked checkbox will be assigned FLASE value.

Select the checkbox containing the value you want to change and click on Data in the toolbar, select Data validation . (Data validation).

How to insert checkboxes on Google Sheets Picture 5

Step 4:

In the new interface select the box Use Use custom values ​​(Use custom cell values). Enter the value depending on the cell in the selected box (Ticked) and Unticked.

Then click the Save button (Save) to save.

How to insert checkboxes on Google Sheets Picture 6

Finally we will get the complete list of tables as shown below.

How to insert checkboxes on Google Sheets Picture 7

Thus, we have finished inserting the Google Sheets box with a simple way. Users will easily manage the content in the table, used for many different purposes, especially making a survey.

See more:

1. How to set up the right to edit spreadsheets on Google Sheets
2. 6 useful functions in Google Sheets you may not know yet
3. How to format conditional cells in Google Sheets

I wish you all success!