Can You Put Text With a Checkbox in Google Sheets?

Yes—but a Google Sheets checkbox does not display ordinary text inside its box. Put the label in a neighboring cell, or set custom checked and unchecked values so the checkbox stores text such as “Done” and “To do” while remaining a checkbox.

What a Google Sheets checkbox does

A checkbox is a data-entry control in a cell. In its standard setup, an unchecked box has the value FALSE and a checked box has the value TRUE. The box is the cell’s visible interface; it is not a text field with a label area inside it. You can click it to switch its state, and formulas can use that state.

This distinction matters because “put text with a checkbox” can mean two different things. You might want a readable label beside the box, as in a task list, or you might want the cell to return text instead of TRUE and FALSE. Sheets supports both arrangements, but they work differently. It does not turn the checkbox itself into a box with a caption embedded in it.

To add a standard checkbox in the browser, select one or more cells and choose Insert > Checkbox. Selecting a range first creates a checkbox in every selected cell. You can then type task descriptions into adjacent cells, or customize the values associated with the checkbox.

Put the label in a neighboring cell

For most checklists, a separate label cell is the clearest and simplest choice. Put checkboxes in one column and the related text in the next. For example, column A could contain checkboxes and column B could contain tasks such as “Send the invoice” or “Book the room.” The words remain readable and editable without changing how the checkbox behaves.

A practical setup might look like this:

In A1, enter a heading such as “Done?”; in B1, enter “Task.”
Select A2:A20 and choose Insert > Checkbox.
Enter one task per row in B2:B20.
Widen column B so the descriptions are easy to read, and freeze the heading row if it helps when scrolling.

Keeping the state and description in separate cells makes sorting, filtering, and reporting more straightforward. You can filter the task list by the checkbox column, for instance, without searching through a mixed cell value. It is also easier for collaborators to understand what each control applies to, especially when a sheet contains several columns of information.

To make the label respond visually when its box is checked, select the label range, such as B2:B20, and use Format > Conditional formatting. Add a rule using “Custom formula is” with =$A2=TRUE, then choose a style such as gray text or strikethrough. The dollar sign keeps the rule tied to column A while the row number adjusts for each task. This changes the label’s appearance; it does not move the label into the checkbox.

Use custom text values for checked and unchecked states

If you want the checkbox cell to represent words rather than TRUE and FALSE, configure custom values. Select the checkbox cell or range, open Data > Data validation, and edit or add the checkbox rule. Under the checkbox criteria, enable Use custom cell values, then enter the value for the checked and unchecked states. For example, the checked value could be “Done” and the unchecked value could be “To do.” The precise labels shown in the rule editor can vary slightly as Google updates the Sheets interface.

After that change, the cell still looks and behaves like a checkbox, but its underlying value is the text you specified. This is useful when another part of the sheet expects words, or when a status column is more meaningful as “Approved” and “Waiting” than as TRUE and FALSE. Choose short, consistent values; spelling and spacing matter when formulas or filters compare them.

Custom values are not a way to show a permanent caption next to the box. The cell’s value changes when you click the box, so it will hold one state’s value at a time. If readers need to see an instruction or description regardless of whether the box is checked, keep that text in a separate cell or use a column heading, note, or nearby explanatory text.

Use checkbox states in formulas

With standard checkboxes in A2:A20 and task names in B2:B20, you can create a status label in C2 by entering =IF(A2,"Complete","Pending") and filling the formula down. For an unchecked box in A2, the result is “Pending”; after checking A2, it becomes “Complete.” This leaves the checkbox as a TRUE/FALSE control while displaying readable status text elsewhere.

You can also count checked boxes. If standard checkboxes occupy B2:B20 and seven of those 19 boxes are checked, enter =COUNTIF(B2:B20,TRUE) in another cell; the result is 7. This can provide a simple completion count. If you configured custom text values instead, make the criterion match the checked value exactly—for example, “Done”—rather than TRUE.

When using a formula to create a visible label, remember that the formula result is not the same as editable text. A cell containing an IF formula will recalculate when the checkbox changes. If someone types over that formula, the formula is replaced. Keep formulas in a dedicated status column and protect that range if collaborators should not edit it.

Formatting and usability choices

Make the relationship between a box and its label obvious. A narrow checkbox column beside a wider description column usually works better than placing checkbox cells far from the text they control. Use a clear header, consistent row spacing, and wrapping for longer descriptions. Avoid merged cells in the main data range if you expect to sort or filter the checklist.

Consider how the sheet will be used by people who rely on keyboard navigation or assistive technology. Keep a descriptive text label in a cell, rather than relying only on color or on an unexplained row of checkboxes. A heading such as “Task” gives context to the descriptions, while “Done?” makes the checkbox column’s purpose clear. Conditional formatting can reinforce state, but the checked value should remain understandable without color alone.

For shared sheets, also decide who can edit the checklist and who can change its structure. A collaborator who can edit the checkbox cells can change their states; changing validation rules or formulas may require broader editing access. If users keep overwriting formulas or labels, separate input cells from calculated cells and explain which columns they should edit.

Common problems and fixes

The checkbox appears, but no words show. That is expected: standard checkboxes show their state, not a caption. Add the label in an adjacent cell.
A formula does not recognize a custom checkbox value. Check the exact checked value in the data-validation rule. “Done” and “done” or “Done ” with a trailing space may not match as intended.
Typing a label removes the checkbox. Typing into the checkbox cell replaces its current contents or value. Put the label in another cell, or restore the checkbox with Insert > Checkbox.
Sorting separates tasks from their checkboxes. Sort the complete table range, including both the checkbox and label columns, rather than sorting just one column.
The checkbox rule seems inconsistent across a range. Review the selected range in the data-validation rule and confirm that custom checked and unchecked values are configured as intended.

When a checkbox cell contains a custom text value, formulas designed for TRUE and FALSE may no longer work as written. For example, comparisons to TRUE will not count a cell whose checked value is “Done.” Either keep the default boolean values and convert them to text in a separate formula column, or update formulas to test the custom text. Using one approach consistently across the sheet prevents confusing mixed results.

Which setup should you choose?

Choose adjacent label cells for a normal checklist, sign-off list, inventory check, or project tracker. This layout is easy to scan and gives each row a clear description. It is also the more flexible option when you need to sort, filter, add notes, or use formulas that distinguish checked from unchecked tasks.

Choose custom checkbox values when the value stored by the checkbox itself needs to be a specific word or number for a downstream formula or workflow. It can be convenient for simple status tracking, but it changes what formulas should expect in that cell. Choose a formula-driven status column when you want a separate text display that updates automatically but still want the checkbox to retain standard TRUE/FALSE values.

In short, these are three related but distinct designs: a checkbox beside a permanent label, a checkbox whose underlying value is custom text, or a checkbox plus a formula-generated status. Pick the one that matches how the sheet will be read and what other formulas or processes need to use.

Frequently Asked Questions

Can I put words inside a Google Sheets checkbox?
No. The checkbox is a control in the cell, not a text box with an embedded caption. Put words in a neighboring cell, or use custom values if you want the cell to return text when checked or unchecked.

How do I add a label beside a checkbox?
Insert a checkbox in one column with Insert > Checkbox, then type the label in the next column on the same row. Keep the columns together when sorting or filtering.

Can a checked checkbox display “Yes” instead of TRUE?
Yes. Edit the checkbox’s data-validation rule through Data > Data validation, enable custom cell values, and set the checked value to “Yes.” Set an unchecked value too if you want it to return text in both states.

Can a checkbox automatically cross out its task?
Yes. Apply conditional formatting to the task-label range and use a custom formula that refers to the checkbox in the same row, such as =$A2=TRUE when checkboxes are in column A. Select a strikethrough style in the formatting options.

Can I use a checkbox in a formula?
Yes. A standard checkbox evaluates as TRUE when checked and FALSE when unchecked, so it can be used with functions such as IF or COUNTIF. If you set custom values, write formulas that test those values instead.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.