LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Tips

How to Add a Check Box in Google Sheets

In this article, you will learn how to make a tick box and utilize it in Google Sheets. It is helpful because you can use a check box simply as a tick box for to-do management or as a trigger of Conditional Formatting with other formulas.

How to make a check box in Google Sheets

  1. Select a cell or a range you want to insert a check box.
  2. Navigate to the “Insert” tab → “Checkbox”.
  3. Done
How to Add a Check Box in
How to insert a standard checkbox in Google Sheets

How to put a customized check box in Google Sheets

  1. Select a cell or a range you want to insert a check box.
  2. Go to the “Data” tab → “Data validation”, which shows up a pop-up window.
  3. Move to the drop-down list in the “Criteria” section and choose “Checkbox”.
  4. Check the box next to “Use custom cell values”.
  5. Insert the two values shown when the check box to be inserted is checked or not.
  6. Click the “Save” button..
How to Add a Check Box in
How to insert a customized check box in Google Sheets

Check this article if you are interested in Data Validation.

How to use a tick box in Google Sheets

As a check box can switch two values in a cell, it is often used with other functions such as IF, IFS, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, and/or Conditional Formatting. In the following cases in the picture, the checkboxes are general check boxes used as Conditional Formatting triggers.

Example 1: Project management: In this example, when you check a box, the entire row that has the tick box is highlighted in dark grey.

How to Add a Check Box in
Checkboxes can be used for task management.

Example 2: Formatting adjustment: When you click the check box, font colors change to block, and fill colors turn white. This is effective when you print out your spreadsheet with simple formatting.

How to Add a Check Box
A tick box can be used as a switch.

The following picture shows the Conditional Formatting settings for the two examples above. 

How to Add a Check
The settings of the Conditional Formatting used the two examples.

Check these articles if you are keen to learn more about Conditional Formatting.

Conditional Formatting in Google Sheets: Explained

Conditional Formatting Based on Another Cell Value in Google Sheets: Explained

How to delete a check box in Google Sheets

  1. Select the cell(s) containing the check(es) box you want to delete.
  2. Press the “Delete” button.
  3. Done.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.