How to Add a Checkbox in Google Sheets on Android or iPhone

To add checkboxes in the Google Sheets mobile app, select the cell or range, tap the three-dot More menu, choose Data validation, set the criteria to Checkbox, and save. You can then tap each box to mark a task complete or switch it back off. Have the spreadsheet open in the Sheets app and know which cells should contain the boxes before you begin.

What You’ll Need

The Google Sheets app on an Android phone or iPhone, with the spreadsheet open and editing access.
A cell or range of cells where you want the checkboxes. You can use an empty column beside a task list, for example.
An internet connection if the file has not been made available offline or your edits need to sync.

The steps are similar on Android and iOS, though labels or menu placement can vary slightly with app updates and screen size. If your app does not show the data-validation option, use the troubleshooting section below.

Step-by-Step

Open the spreadsheet in the Sheets app. Find the file in the Google Sheets app and open it. If it opens in a preview or another app, use the option to open it with Google Sheets. Confirm that you can edit the file: a view-only document will not let you add checkboxes. If you have access to more than one Google account, check that you opened the account with editing permission.
Choose where the checkboxes belong. Tap the first target cell. For a task list, this is often the cell beside the first task, rather than the task-name cell itself. To add checkboxes to a group of cells at once, drag the blue selection handles to include the full range. You can also tap the row or column header if you intend to select an entire row or column, but use a limited range when possible so you do not add checkboxes to hundreds of unused cells.
Open the cell options. With the target cell or range selected, tap the three-dot More menu near the top of the screen. Look for Data validation in the menu. Depending on your device and app version, the menu may be scrollable, so swipe through its options if you do not see the command immediately. Take care not to tap a nearby formatting or sharing option by mistake.
Set the validation rule to Checkbox. In the Data validation controls, open the criteria selector and choose Checkbox. A checkbox is a type of cell input rule: it adds a tappable box and limits the cell to checked or unchecked states. If the screen offers additional settings, leave them at their defaults for a basic checklist. Custom checked and unchecked values are useful for special workflows, but are not required for ordinary task tracking.
Save or apply the rule. Tap Save or the equivalent confirmation button shown by your app. The selected cell or cells should now display empty checkbox squares. If you selected a range, the rule should apply to every cell in that selection. Wait a moment for the change to sync if the file is online; a brief delay does not necessarily mean the insertion failed.
Test a checkbox. Tap one of the new boxes. It should change to a checked state; tap it again to clear it. If the cell enters text-editing mode rather than toggling, tap the box itself once more or exit the cell editor and try again. Check one box in the range first so you can confirm the result before filling a large checklist.
Add task labels or other context. If you have not already done so, put each task or item in a neighboring cell. For example, place task names in column A and checkboxes in column B, with a header such as “Done” above the checkbox column. Keep labels separate from checkbox cells so that tapping a box changes its state instead of replacing a task description.
Verify a few rows and the saved file. Tap several boxes on and off, including one farther down the selected range. Check that the boxes line up with the intended items and that no unrelated cells were included. If you use the sheet on another device, allow it to sync and then confirm the changes appear there too.

Once inserted, a checkbox is not just a symbol pasted into a cell. It acts as a two-state input: unchecked and checked. In Google Sheets, those states normally correspond to the Boolean values FALSE and TRUE. That makes checkboxes useful for simple lists and for spreadsheet logic, but you do not need to work with formulas to use them as a visual checklist.

Common Mistakes

Selecting the wrong cell or range. A checkbox appears in every selected cell, including blank cells. Before applying the rule, look at the selection outline and confirm it starts and ends where intended. If you accidentally selected an entire column, undo promptly or remove the rule from the extra cells.
Trying to type a checkmark into the cell. Typing a symbol such as ✓ creates text, not the interactive checkbox control. Use Data validation and the Checkbox criterion when you want a box that can be toggled and used as a true/false value.
Expecting the checkbox to label itself. The box only represents a state; it does not describe what is complete. Put the task, name, or item in a neighboring cell, and consider adding a column heading so other people understand what checking the box means.
Using a file you cannot edit. A shared spreadsheet may open in view-only mode, or your account may have commenter access. In that case the checkbox controls may be unavailable or edits cannot be saved. Ask the owner for editor access or make an authorized copy if that is appropriate.
Assuming a checkmark is decorative only. A checkbox can affect formulas and filters because its value is TRUE or FALSE by default. If the sheet already uses formulas, changing a box may change totals, status labels, or other calculated results. Check the surrounding sheet before making bulk changes.
Applying the rule to a very large area. Selecting hundreds of extra rows can make the sheet harder to scan and may complicate later data entry. Apply the rule to the rows you need now; you can extend it to new rows later.

Tips

Keep the layout predictable. Put all checkboxes in one narrow column and the matching descriptions immediately beside them. Consistent alignment makes a long list easier to use on a small screen.
Use a header and a clear meaning. Headings such as “Done,” “Reviewed,” or “Paid” explain what a checked state represents. Avoid vague labels if several people will update the file.
Apply checkboxes to a batch. If you already know the list size, select the whole target range before choosing Checkbox. This is quicker and more consistent than repeating the rule one cell at a time.
Leave space for future entries. For a list that grows, you can include a modest number of extra rows, or add the checkbox rule to new cells as you add items. Avoid selecting the entire sheet unless you have a specific reason.
Remember that a checked box is data. The default TRUE and FALSE values can be used in formulas or filtered as values. If you plan to build calculations around the list, keep the checkbox column free of unrelated text.
Use the browser procedure when needed. If the mobile app does not expose Data validation on your device, open the spreadsheet in Google Sheets in a desktop browser. In the web version, select the cells and choose Insert > Checkbox. This is a Google Sheets web command; Excel has its own checkbox tools and the Sheets mobile steps do not apply there.

Troubleshooting

Data validation is missing from the More menu. First confirm that you are editing in the Google Sheets app, rather than viewing a file preview, and that the app is up to date. Check that you have editor permission and that a cell is selected. If the command still is not available, use a computer browser and choose Insert > Checkbox after selecting the target cells. You can also try the phone’s browser with its desktop-site option, but the desktop interface may be cramped and may redirect you to the app.

The checkbox option is disabled or changes will not save. Check whether the file is view-only, protected, or subject to a restriction set by its owner. If you can edit other cells but not these, the target cells may be protected. Ask the owner to grant access or adjust protection rather than trying to bypass it. Also check your connection and wait for pending edits to sync.

The boxes appeared in the wrong places. Use Undo immediately if the insertion was your last action. Otherwise, select the unintended cells, open Data validation, and remove the checkbox rule if that option is available. Then select the correct range and apply the rule again. Before repeating the action, zoom out or inspect the row and column labels to make sure the selection is accurate.

Tapping a box does not change it. Make sure you are tapping the checkbox rather than opening the cell editor or selecting a neighboring cell. If the sheet is protected or view-only, toggling may be blocked. Close any editing keyboard, tap outside the text-entry area, and try the square again. If only one cell fails, check whether it has a different rule or protection setting from the rest of the range.

The box looks checked, but a formula or filter behaves unexpectedly. Standard checkboxes use TRUE and FALSE values, but a sheet owner can configure custom values. Review the validation rule on that cell, and check any formulas or filters that refer to the column. Do not replace the cell contents with typed words unless the sheet’s rules and formulas are designed for those values.

Frequently Asked Questions

Can I add checkboxes in the Google Sheets app on both Android and iPhone?
Yes. In the mobile app, select the cells, open More, choose Data validation, and set the criteria to Checkbox. Menu labels or placement can vary slightly by app version.

Can I put a checkbox in several cells at once?
Yes. Select the full range before applying the Checkbox criterion. Every selected cell receives its own checkbox, so verify the range carefully first.

What do checked and unchecked boxes mean to Sheets?
By default, checked is TRUE and unchecked is FALSE. A spreadsheet owner can set custom values, so an existing sheet may behave differently.

Can I use a checkbox without an internet connection?
You may be able to edit a file that has been made available offline in the Sheets app. Changes made offline sync when a connection returns. If the file was not saved for offline access, it may not be available to edit.

How do I remove a checkbox?
Select the cell or range and remove its data-validation rule in the app if that option is available. In Google Sheets on the web, select the cells and use Data > Data validation to remove the rule. Deleting the rule removes the checkbox behavior; inspect the cells afterward if you need to preserve or clear their values.

Is adding a checkbox in Google Sheets the same as adding one in Excel?
No. Google Sheets and Excel have separate menus and checkbox implementations. Use the Google Sheets steps for a Sheets file; for Excel, use the checkbox feature provided by your Excel version.

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.