Add a checkbox in three steps

Open the Google Sheet, select the cells where you want checkboxes, then go to Insert > Checkbox. Google Sheets will place an empty checkbox in each selected cell. Click any checkbox to toggle it between checked and unchecked — the box itself stores TRUE when checked and FALSE when unchecked, which you can use in formulas.

You do not need to format the cells first or install anything. The checkbox is a built-in tool in Google Sheets, available on desktop and mobile. Once inserted, checkboxes behave like any other cell value: you can sort by them, filter by them, or reference them in other formulas.

Key Takeaways

  • Select the cells where you want checkboxes, then use Insert > Checkbox to add them all at once.
  • A checked box stores the value TRUE; an unchecked box stores FALSE, which formulas can read.
  • You can sort or filter a sheet by checkbox status to group completed or uncompleted tasks together.
  • Checkboxes work the same way on mobile as on desktop, and you can edit them in offline mode.

Select cells before you insert

The first step is to highlight the range where you want checkboxes. Click on a single cell, or drag to select multiple cells in a row, column, or block. You can also click the column header to select an entire column, or click the row number to select an entire row — though this is usually more than you need.

If your cells already contain data (like task names or dates), the checkbox will be added to those same cells without erasing the data. The checkbox appears as a small square to the left of any existing text. If you want checkboxes in a column by themselves, select an empty column first.

Open the Insert menu and choose Checkbox

With your cells selected, click the Insert menu at the top of the sheet. A dropdown will appear with options including Checkbox. Click it. Google Sheets will immediately place a checkbox in each selected cell.

On mobile (Android or iOS), tap the three-line menu icon, then tap Insert, then Checkbox. The process is the same — all selected cells get a checkbox at once. If you selected only one cell, only that cell gets a checkbox.

Use checkboxes in formulas and filters

Once a checkbox is in place, clicking it toggles between TRUE (checked) and FALSE (unchecked). You can reference this value in other cells using a formula. For example, if column A contains task names and column B contains checkboxes, you could write =COUNTIF(B:B, TRUE) in another cell to count how many tasks are marked complete.

You can also filter by checkbox status. Click the filter icon (funnel shape) at the top of a column with checkboxes, then select "TRUE" to show only checked items, or "FALSE" to show only unchecked items. This is useful for to-do lists or project trackers where you want to hide finished tasks temporarily.

Sorting by checkbox column works the same way: click the column header, then choose Data > Sort range. Google Sheets will move all checked boxes to the top or bottom depending on your choice, grouping your completed and incomplete items together.

Customize checkbox labels (optional)

By default, a checkbox shows as an empty square when unchecked and a filled square when checked. You can change what text or symbol appears instead. Select the cells with checkboxes, then go to Insert > Checkbox again. A dialog box will appear with options to set custom labels for checked and unchecked states.

For example, you could set the unchecked label to "No" and the checked label to "Yes", or use emoji like ☐ and ☑. Type your preferred labels in the dialog, then click Insert. The checkboxes will now display your custom symbols when toggled, though the underlying TRUE/FALSE value remains the same for formulas.

Copy and paste checkboxes to other sheets

If you have checkboxes in one sheet and want the same setup in another sheet in the same file, select the cells with checkboxes and copy them (Ctrl+C or Cmd+C). Go to the other sheet, select where you want them, and paste (Ctrl+V or Cmd+V). The checkboxes will paste as checkboxes, not as text.

If you want to copy only the checkbox structure without the current checked/unchecked state, select the cells, copy them, then use Paste Special (Ctrl+Shift+V or Cmd+Shift+V) and choose "Paste format only". This will add empty checkboxes to the new location without copying whether they were checked.

Troubleshooting common checkbox issues

If you select cells and Insert > Checkbox is grayed out, you may have selected cells that are protected or in a read-only sheet. Check that you have edit permission for the sheet. If the sheet is shared, the owner may have locked certain columns or ranges — ask them to unlock the cells you need.

If a checkbox is not responding when you click it, try refreshing the page (F5 or Cmd+R). Occasionally a checkbox will appear frozen if the sheet is syncing with other users' changes. Refreshing usually fixes this. If the problem persists, try opening the sheet in a different browser or clearing your browser cache.

If you accidentally delete a checkbox and want to undo it, press Ctrl+Z (or Cmd+Z on Mac) immediately. This will restore the checkbox and its checked/unchecked state. If you have already made other changes, undo will revert those too, so use it only if the deletion was your last action.

Frequently Asked Questions

Can I use checkboxes in a shared sheet where multiple people edit?

Yes. When one person checks or unchecks a box, the change syncs to everyone viewing the sheet in real time. Each person sees the current state of all checkboxes. If two people click the same checkbox at the exact same moment, Google Sheets will register one click and ignore the other, then show the result to both.

What happens to checkbox data if I convert the sheet to a PDF or Excel file?

In a PDF export, checkboxes appear as their current symbol (checked or unchecked box). In an Excel file, checkboxes are converted to TRUE or FALSE text values, so you lose the interactive checkbox but keep the data. If you download as CSV, checkboxes become TRUE or FALSE as plain text.

Can I make a checkbox required so someone has to check it before submitting?

Not directly in Google Sheets. However, if you are using Google Forms connected to a sheet, you can make a checkbox question required in the form itself. For a plain sheet, you would need to use data validation rules or a script to enforce this, which requires more advanced setup.

Do checkboxes work offline in Google Sheets?

Yes. If you have enabled offline mode in Google Sheets, you can click checkboxes and toggle them while not connected to the internet. When you reconnect, the changes sync to your online sheet. Offline mode must be turned on in advance — go to File > Offline to enable it.

Can I add a checkbox to a cell that already has a formula?

No. A cell can hold either a formula or a checkbox, not both. If you try to insert a checkbox in a cell with a formula, Google Sheets will ask you to clear the cell first. If you need both a checkbox and a formula, put the checkbox in one column and the formula in another, then reference the checkbox column in your formula.