How to Make a Checklist in Excel
Excel can hold a checklist with real, tickable checkboxes. How you add them depends on your version: recent Microsoft 365 builds have a one-click Checkbox button, while older versions need the Developer tab. This guide covers both methods, then shows a quicker route.
In a hurry? Build your checklist free in under a minute.
Real checkboxes, 300+ templates and PDF download. No sign-up needed.
How to make a checklist in Microsoft Excel
Method 1: The quick way (Excel 365, 2024 or newer)
Best if your Excel has the modern Checkbox button on the Insert tab.
- 1
List your tasks
Type one task per row down a column, for example column B.
- 2
Select the checkbox cells
Highlight the cells in column A, next to your tasks.
- 3
Insert checkboxes
On the Insert tab, click "Checkbox". A tickable box appears in every selected cell.
- 4
Tick them off
Click a box to toggle it. The cell value switches between TRUE and FALSE behind the scenes.
Method 2: The classic way (older Excel versions)
Use this if your Insert tab has no Checkbox button.
- 1
Turn on the Developer tab
Go to File then Options then Customize Ribbon and tick "Developer".
- 2
Insert a form control
On the Developer tab, click Insert, then choose the Checkbox under "Form Controls".
- 3
Draw the checkbox
Click inside a cell to place it, then delete the default "Check Box 1" label text.
- 4
Copy it down
Select the cell and drag the fill handle, or copy and paste, to add a checkbox to every row.
- 5
Link and format (optional)
Right-click a box, choose Format Control, and link it to its cell so you can count completed items or strike them through with conditional formatting.
Where Excel slows you down
- Older versions need the hidden Developer tab, and the checkboxes are form controls that float over cells, so they slip out of place when you sort or resize rows.
- Excel is built for numbers and grids, not task lists. Reordering an item means cut-and-paste work.
- There are no checklist templates aimed at everyday users.
- A spreadsheet is a heavy, cluttered format to print or hand to someone for a simple to-do list.
The verdict: Modern Excel has a one-click Checkbox button, but older versions still need the Developer tab and floating controls that drift when you edit rows.
The faster way: build it in GeneChecklist
Here is the same checklist, without the menus, hidden tabs or formatting. Three steps, any device.
- 1
Open the free builder
Go to the checklist builder. There is no download, no sign-up and no hidden menu to switch on. It loads as a blank checklist, ready for you to type.
- 2
Add your items, or let AI do it
Type a task and press Enter for the next line. In a hurry? Describe what the list is for, such as "weekend camping trip with two kids", and AI writes the items for you. Or start from one of 300+ ready-made checklists.
- 3
Organise, then save, print or share
Drag items to reorder them, group them into sections, and tick them off against a live progress bar. Download a clean PDF, print it, or send a share link, all from the same screen.
Excel vs. GeneChecklist
| Excel | GeneChecklist | |
|---|---|---|
| Time to a usable checklist | 10-20 minutes | Under a minute |
| Checkboxes | One click in Excel 365; Developer tab in older versions | Built in: tap to tick, with a live progress bar |
| Ready-made templates | None for everyday checklists | 300+ professionally written checklists |
| AI list generation | Not available | Describe your list and AI writes the items |
| Phone and desktop | Checkboxes can shift when rows are sorted or resized | Any browser, nothing to install |
| Print and PDF | Prints with gridlines and spreadsheet clutter | One-click, print-ready PDF |
| Cost | Needs Microsoft 365 or Excel | Free to build, print and download as PDF |
You can have both
Need the data in a spreadsheet too? Build the checklist here, then a Pro plan exports it as a CSV file that opens straight in Excel.
Frequently asked questions
How do I insert a checkbox in Excel?
In Excel 365 (2024 or newer), select your cells and click Insert then Checkbox. In older versions, turn on the Developer tab, then use Insert then Form Controls then Checkbox.
Why can I not find the Checkbox button in Excel?
The one-click Checkbox button only exists in recent Microsoft 365 builds. On older versions you must enable the Developer tab and use a form control instead.
How do I make a checklist box in Excel cross out when checked?
Link each checkbox to its cell, then add a conditional formatting rule that applies strikethrough when the cell value is TRUE.
Is Excel good for a simple checklist?
It works, but it is overkill. Excel is built for calculations and grids. For a plain task list, a checklist builder is faster and prints far cleaner.
Ready-made checklists to start from
Skip the blank page. Open any of these, customise it, and download a PDF.
More checklist guides
Stop wrestling with the wrong tool
GeneChecklist is built for one thing: checklists. Real checkboxes, AI help, 300+ templates and instant PDF. Free, and no account needed to start.