How to add a checkbox in Google Sheets

Adding a checkbox, also known as a tickbox, is a useful way to organise your spreadsheets.

Whether you want to make managing a work project easier, or want to organise your own personal monthly budget, Google Sheets allows you to easily add or delete checkboxes to make your spreadsheets more user friendly. 

Adding a checkbox is incredibly easy to do and can really tidy up your spreadsheet. Keep reading to learn how to add a checkbox in Google Sheets.

What you’ll need:

The short version:

  1. Open Google Sheets
  2. Open the document you would like to edit
  3. Select the cell or cells you’d like to add tick boxes to
  4. Select Insert on the top menu panel
  5. On the Insert menu, select Tick box
  1. Step

    Open Google Sheets

    There are a few ways to open Google Sheets. If you have downloaded the Google Sheets app then simply launch this. On the Google Chrome browser, you can either search for Google Sheets in the search panel or select the Google apps icon at the top-right of the New tab browser page, as shown here.

    On all other browsers, you can visit and sign in with your Google account there.Google Apps list with Google Sheets highlighted

  2. Step

    Open the document you would like to edit

    You can either create a new Blank spreadsheet or choose one of your previously edited spreadsheets that will be listed on this page.Google Sheets home page

  3. Step

    Select the cell or cells you’d like to add tick boxes to

    You can either select an individual cell or you can highlight multiple cells. To highlight multiple cells, hold down the left click button, either on your mouse or trackpad, against all the desired cells. Google Sheets with cell highlighted

  4. Step

    You’ll find this option listed just underneath the title of your Spreadsheet.Google Sheets with Insert on menu panel highlighted

  5. Step

    By selecting this, you will instantly insert a tick box into the cell. To delete it, simply tap the cell surrounding the box and press the delete or backspace key on your keyboard.Google Sheets with Insert menu open and Tick Box option highlighted


How can you add tick boxes via an Android app?

Once you’ve selected the cells you want to add tick boxes to, tap the three dots (More) button in the top-right >Tap Data validation > In the list under Criteria, tap Tick box.

Can you add tick boxes with an iOS app?

You can’t currently add tick boxes on the iOS app so you’ll have to either use an Android app or a browser. Once you’ve added the tick box in, you will be able to interact with it on the iOS app.

About the author

Leave a Reply

Your email address will not be published. Required fields are marked *