Family Encyclopedia >> Work

How to insert a checkbox in Google Sheets

Why is the humble checklist such a powerful tool? Well, it helps you keep track of anything, step by step or even as a random to-do list. Plus, it's so simple to create. If you love checklists, you'll love the news that it's so easy to insert a checkbox (or "Checkbox") into Google Sheets.

How to insert a checkbox in Google Sheets

Until now, to insert a checkbox in Google Sheets, you had to use the CHAR function and a number associated with the checkbox-like special character. This process above is complicated for something as simple as a checkbox, so it's nice that you can now insert a checkbox from the toolbar.

  1. Sign in to Google Drive and open a spreadsheet in Google Sheets.
  2. Select the cells in which you want to have checkboxes. You can also create your list first and then insert the checkbox by selecting the next empty column of cells.
  3. On the menu, click Insert> checkbox .
    How to insert a checkbox in Google Sheets
  4. To remove the checkboxes, select the checkboxes you want to remove and press Clear .

You can increase or decrease the size of check boxes by changing the font size on the toolbar. Google Sheets also allows you to pass custom values ​​with checkboxes. For example, a checked box might indicate "TRUE" while an unchecked box might indicate "FALSE." For example, you could use this with a multiple choice Question and Answer.

Follow these steps to validate the checkboxes with the custom values ​​you want.

  1. Select cells with checkboxes..
  2. From the toolbar, go to Data> Data Validation .
  3. In the data validation dialog, choose Checkbox as the Criteria .
    How to insert a checkbox in Google Sheets
  4. Select Use custom cell values . Enter your custom value in the Markup and Unmarked fields.
  5. Click Save .

A checkbox in a spreadsheet can be a simple device for keeping track of everyday tasks. Use checklist templates and tools to avoid mistakes. This human flaw makes checklists so effective. We show you how you can create your own checklists to save time and money. Read More