Thứ Ba, Tháng Hai 11, 2025
spot_img
HomeFinanceHow to create checkboxes in Google Sheets

How to create checkboxes in Google Sheets

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.

Import Google Sheets content

Next select the content you want to insert the checkbox and click Insert item (Insert) on the toolbar and press Checkbox (Tick box).

Insert tick box

Step 2:

Soon we will see the checkbox appear in the selected content.

Insert checkboxes into 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.

Copy tick box

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).

Xem thêm  Instructions for closing negative number brackets in Excel

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.

Validate tick box data

Finally we will have a complete list as shown below.

Google Sheets inserts tick boxes

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.

Enable keyboard shortcuts in Google Sheets tables

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.

Keyboard shortcuts in Google Sheets

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.

Insert checkbox in Google Sheets table

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.

Insert checkbox in Google Sheets table using CHAR function

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.

Xem thêm  7 Notion productivity tips you may not know

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.

Insert images in Google Sheets tables

The checkbox image results can also be inserted into the Google Sheets spreadsheet.

Image of checkbox in Google Sheets table

So you have many ways to insert checkboxes in Google Docs, depending on each person's needs when inserting checkboxes into Google Sheets.

Video tutorial on inserting checkboxes on Google Sheets

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments