Instructions to insert Checkbox on Google Sheets

Checklist is a modest but powerful tool that is enjoyed by lots of people. It is often used to list tasks and to "check" if completed. On Google Sheets (Google Sheets) available tools so that you can insert this checkbox an easy way to utopia.

Unlike Excel , to date, to insert checkboxes in Google Sheets, you have to use the CHAR function and some are associated with special characters like checkboxes. The old process is too complicated and Google has added a new way of inserting new checkboxes on Google Sheets. The following article will show you how to insert checkboxes into a cell in Google Sheets (Google Sheets).

How to insert checkboxes on Google Sheets

• Sign into Google Drive and open the Google Sheets spreadsheet you want to insert the checkbox.
• Select the cell you want to insert the checkbox. You can create a to-do list and then insert a checkbox by selecting the adjacent blank column.
• Go to the Insert menu > Tick ​​box (or go to Insert > Check box )

• You can copy these checkboxes or drag to create copies as dragging formulas.
• To remove this checkbox is also very simple, just select the checkbox to remove and press Delete .

You can increase or decrease the size of these checkboxes by changing the font size on the toolbar. Google Sheets also allows you to pass custom values ​​with checkboxes. For example , a selected checkbox will be assigned a TRUE value while the unchecked box may have the value FALSE .

• Follow these steps to validate the checkbox value with the custom value you want:
• Select the cell containing the checkbox to change the value.
• On the toolbar to the Data > Data validation (or Data > Data Validation )

• Select the Use custom cell values ( Using custom cell value ). Enter your custom values into the box ticked ( selected ) and unticked ( unselected ).

• Click Save ( Save ).

That's it, you already know how to insert checkboxes into your spreadsheet. Using this check box will be a simple yet powerful tool to control your daily work, or it can also be used for many other purposes like filtering charts and pivot tables.