A Google Sheets checkbox task list starts with labels beside empty cells, followed by Insert → Checkbox on the chosen range. After this exercise, you can check and clear three controls, compare their row labels and record the result of reopening the same file.
Content last updated: 19 October 2026.
What does a checkbox actually record?
A Google Sheets checkbox task list puts a selectable control beside each item. A checkbox is a cell control you can check and clear, rather than a square character typed into a sentence. This exercise uses three controls and a small observation card. It does not create an automated project system or verify that someone performed a real task.
Imagine a small photography studio making an internal sample checklist. The items concern preparing a portfolio draft, but no actual portfolio is reviewed here. The studio, labels and expected states are fictional teaching material. No signed-in account exercise, client deployment or measured productivity improvement is reported.
If you need an assistant to design a broader spreadsheet, the Gemini in Sheets guide covers a separate route. Here you will use the ordinary Insert menu. You decide where the controls belong, toggle them yourself and inspect the neighbouring labels. Keep the first result small enough to explain without relying on an automated summary.
Set up three labels and an empty destination range
On a computer, open sheets.google.com with an account you are allowed to use. Choose Blank to create a new spreadsheet you can edit. Select the file title, name it Portfolio checkbox practice and press Enter. Do not practise by adding controls to a supposedly unused column in a shared operational file. A new file keeps the scope clear.
Enter Task in A1 and Mark in B1. Put Choose an image in A2, Read the caption in A3 and Check the layout in A4. Leave B2, B3 and B4 empty. After typing a cell, click outside it to finish the entry. At this point you should have text labels but no checkbox controls.
Use the table below as a layout reference. The words Empty cell describe the intended state; do not type them into column B. B1 is a heading, not one of the cells that will receive a checkbox. Column A contains the labels and must stay as text.
| Row | Column A | Column B |
|---|---|---|
| 1 | Task | Mark |
| 2 | Choose an image | Empty cell |
| 3 | Read the caption | Empty cell |
| 4 | Check the layout | Empty cell |
Inspect B2:B4 before continuing. That range notation means the three cells in column B from row two through row four. If they contain existing text, formulas or controls, stop rather than applying a new rule over them. Confirm that you opened the intended new practice file. The preparation output is a named spreadsheet with two headings, three labels and three genuinely empty destination cells.
How do you insert the three checkbox controls?
Select B2 through B4 and inspect the highlighted range. It should not include the labels in column A or the heading in B1. Choose Insert → Checkbox from the top menu. Google's desktop instructions describe adding controls to selected cells through that route. Interface language can change the wording, so identify the checkbox function rather than expecting identical labels.
Look for a separate checkbox in B2, B3 and B4. For this practice, the expected starting state is that all three are unchecked. Read the actual state from your own screen. If a selection is already present, record it and resolve the starting state before beginning the toggle sequence. Do not describe an expected state as something you observed merely because the controls appeared.
Read the three labels again. A2 should still say Choose an image, A3 Read the caption and A4 Check the layout. B1 should still contain Mark. If the heading received a checkbox or a label changed, the selected range did not meet the brief. The presence of some checkboxes is not enough to pass this stage.
Keep custom values out of this first exercise. Google documents setting alternative checked and unchecked values, but you do not need that setup to learn where the controls go. We also will not add formulas, charts, filters, conditional colours or an automatic completion counter. The first output is simply three correctly positioned controls next to unchanged text.
Check selection, clearing and row correspondence
Click B2 once. Expect B2 to be checked while B3 and B4 remain unchecked. Read the label beside B2 as well as its cell address. The selected control should correspond to Choose an image. That small comparison helps prevent you from marking the wrong row while assuming that any visible check is the intended one.
Click B2 again to clear it. Expect all three controls to be unchecked again. Then click B3 once. Your intended final state is B2 unchecked, B3 checked and B4 unchecked. The selection should now sit beside Read the caption. This sequence checks both directions of interaction instead of only demonstrating that a mark can appear.
Stop if the neighbouring text changes, another control changes unexpectedly, or you cannot identify the clicked cell. Do not continue making selections until the sheet looks roughly right. Record the action and the difference. The following table is a set of expected states, not evidence from an observed Google session.
| Stage | B2 | B3 | B4 |
|---|---|---|---|
| Start | Unchecked | Unchecked | Unchecked |
| Click B2 once | Checked | Unchecked | Unchecked |
| Click B2 again | Unchecked | Unchecked | Unchecked |
| Click B3 once | Unchecked | Checked | Unchecked |
A mark records the user's selection, not the truth of the label. Checking Read the caption does not establish that the caption was read, reviewed correctly or approved by another person. In a real workflow, define what completion means and what evidence belongs with it. This exercise checks the interface state only and should not be presented as an attendance, compliance or approval record.
Save an observation card and inspect the return visit
Copy this card into your notes. Take the exact spreadsheet address from the browser address bar and record it with the name. Similar filenames can exist, so a name alone is a weak return route. Fill each observed field only after completing that action. Untested is a valid status when you have not yet made a return visit.
Spreadsheet name and exact address: Destination range: B2:B4 Starting state observed: After checking B2: After clearing B2: After checking B3: A2:A4 labels unchanged: untested B2/B3/B4 after reopening: untested Decision: matches / differs / untested
Google documents automatic saving while you work online. That general behaviour is not an observation that your particular spreadsheet has finished saving. Check the connection and the visible save state, then leave the file and reopen the exact address in your card. Inspect whether only B3 remains checked and whether the three labels are unchanged. Record the actual return result, not an assumption about persistence.
For a local copy of the card, open Start → Notepad and create a new document on Windows. On Mac, choose TextEdit → File → New, then Format → Make Plain Text. Paste the card. Use File → Save As on Windows or File → Save on Mac, choose Documents and name it checkbox-check.txt. If that name exists, choose a different name rather than overwriting the earlier note.
Close the local note and reopen it from Documents. This is separate from reopening the spreadsheet. Finding your local card does not prove that the online selections were preserved. Keep both checks visible, even when one remains untested. The useful handover is a small file and an honest explanation of what you checked, not a blanket claim that everything is saved.
When should you stop instead of expanding the checklist?
Stop if the spreadsheet is not editable, the relevant menu is unavailable, or the destination cells are occupied. Do not change permissions, install an extension or connect another service to force this practice through. It assumes an existing working account and a new spreadsheet you can edit. Troubleshooting account access is a different job.
A fifteen-minute session can cover the initial layout, insertion, three state transitions and a return check. That is a suggested allocation, not measured performance. If one stage fails, leave it unresolved rather than marking the whole exercise complete. A partial set of controls and an unchecked return visit are different from the intended finished result.
For a later task, a filter view can help inspect selected records. The separate COUNTIF status exercise concerns counting text status records. This article provides no automatic checkbox count, and the text-status example should not be treated as the same cell setup as a checkbox list.
For shared spreadsheets, review protecting formula cells before letting practice changes touch operational calculations. For connected processes, the Sheets automation guide addresses a broader design. Today's deliverable remains three fictional labels, three correctly located controls and a record showing what changed when you checked, cleared and reopened them.
Frequently asked questions?
How do I add the checkbox controls?
On a computer, select the destination cells and choose Insert → Checkbox. This exercise selects only the empty B2:B4 range.
Does a checked box prove the task was completed?
No. It records the user selection. Completion criteria and supporting evidence must be defined separately.
Do I need a formula for this list?
No. This exercise inserts three controls and checks their states without a formula or automatic counter.
What should I write before testing a return visit?
Record the selection tests you actually performed and leave the return-visit field untested until you reopen and inspect the spreadsheet.
