Insert Checkbox Shortcut in Google Sheets

A checkbox in Google Sheets is a clickable little square that flips between TRUE and FALSE. Click it once, it’s checked. Click it again, it’s clear.

They’re handy for to-do lists, status trackers, attendance sheets, or anything where a row needs a “done” toggle. The fact that the cell value is TRUE or FALSE means you can count, filter, and reference checkboxes in formulas.

Google Sheets has no built-in keyboard shortcut for inserting a checkbox on Windows or Mac. The fastest route is the Insert menu, which drops one in with just two clicks.

Is There a Keyboard Shortcut for Inserting a Checkbox in Google Sheets?

Insert Checkbox Keyboard Shortcut (Windows Windows)

No native keyboard shortcut on Windows. Use the Insert menu below.

Insert Checkbox Keyboard Shortcut (Mac Mac)

No native keyboard shortcut on Mac. Use the Insert menu below.

There is no key combo for this on either platform. The Insert menu is the standard route, and it works on a single cell or a whole range at once.

Once a checkbox is in place, clicking it toggles the value between TRUE (checked) and FALSE (unchecked). The cell holds a real boolean, so formulas can read it. =COUNTIF(A:A, TRUE) counts checked boxes. =IF(A2, "Done", "Open") returns a label based on the box. Conditional formatting can react to it too, like shading an entire row green when its checkbox is ticked.

How to Insert a Checkbox in Google Sheets (Step by Step)

  1. Select the cell or range where you want checkboxes.
  2. Open the Insert menu.
  3. Click Checkbox.
  4. The selected cells now each show a checkbox, unchecked by default.
  5. Click any checkbox to flip it on or off.

Here’s a quick example. You have a task list in column A and want a tick box in column B for each task.

Select B2 through the last task row, then go to Insert and click Checkbox.

Drop =COUNTIF(B:B, TRUE) in another cell to see a live count of completed tasks. The number updates the moment you tick or untick anything.

Another Way to Insert a Checkbox (Custom Values via Data Validation)

The Insert menu gives you plain TRUE / FALSE checkboxes. If you want the unchecked cell to read “Pending” instead of FALSE, or the checked cell to read “Done” instead of TRUE, use data validation.

  1. Select the cells that already have checkboxes (or empty cells you’ll add them to).
  2. Open Data and click Data validation.
  3. In the rule, pick Checkbox as the criteria.
  4. Tick Use custom cell values and fill in the Checked and Unchecked text.
  5. Click Done.

The cell still shows a checkbox visually, but the underlying value is whatever string you set. Formulas pick up that string, not TRUE / FALSE.

Things to Watch For

  • Copy-paste replicates the checkbox. Copy a cell with a checkbox, paste over a range, and every target cell gets its own checkbox.
  • Typing in a checkbox cell removes the checkbox. If you type a number or text in there, the checkbox is overwritten. To get it back, go to Insert and click Checkbox again.
  • Delete key clears the value, not the box. Pressing Delete on a checked box turns it back to FALSE. Pressing Delete again removes the checkbox entirely.
  • Custom values are case-sensitive in formulas. If you set the checked value to “Done” with a capital D, =COUNTIF(A:A, "done") still works (COUNTIF is case-insensitive), but =A2="done" returns FALSE. Match the case when you can.
  • Excel export converts checkboxes to a TRUE / FALSE cell in older versions of Excel. Newer Excel has its own checkbox feature, but the round-trip is not always clean.

Google Sheets keyboard shortcuts

Related Google Sheets shortcuts: