How to Use SUMIFS to Analyse Data Like a Pro
If you’re still using SUM and IF separately to crunch numbers in Excel, it’s time to level up. SUMIFS is one of Excel’s most powerful functions for analysing data — and it’s surprisingly eas...
Read MoreChecklists are everywhere — from project management to grocery shopping. But did you know Excel can handle fully interactive checklists with in-cell checkboxes, formatting, and even progress tracking?
Step 1: Set Up Your Checklist Items
Start by typing your checklist items into a column — for example, column B. Each row should be a task or item you want to track. In column A (next to each item), we’ll insert a checkbox that can be ticked off.
Step 2: Add In-Cell Checkboxes
To add checkboxes:
- Go to the Developer tab (if it’s not visible, enable it via File → Options → Customize Ribbon).
- Click Insert → choose the Form Control Checkbox.
- Click beside the first task in column B.
- Copy the checkbox down for the rest of the items using copy/paste.
Each checkbox is independent, but we can link them to adjacent cells for formula use.
Step 3: Link Checkboxes to Cells
Right-click each checkbox and choose Format Control. On the Control tab, set the Cell Link to the cell in column C (or any unused column). This will show TRUE when checked and FALSE when unchecked.
Now Excel knows which tasks are ticked.
Step 4: Add Conditional Formatting (Optional but Fun)
To cross out completed tasks or grey them out, use conditional formatting:
- Select your checklist item cells (e.g., B2:B20).
- Go to Home → Conditional Formatting → New Rule.
- Choose “Use a formula to determine which cells to format”.
- Enter a formula like
=C2=TRUE. - Set a strikethrough font or grey fill colour.
When a box is ticked, the item will format automatically. It’s a simple visual win.
Step 5: Bonus – Add Progress Tracking
Want to get fancy? Create a progress bar showing how many tasks are done.
Use a formula like:
=COUNTIF(C2:C20, TRUE)/COUNTA(B2:B20)Format the result as a percentage and pair it with a bar chart or use a conditional format data bar for a progress effect. Your checklist now shows actual completion metrics!
Final Thoughts
Excel isn’t just for numbers — it’s a flexible platform that lets you build interactive tools with minimal effort. Whether you are managing tasks, monitoring goals, or just want to tick off daily routines, an Excel checklist with in-cell checkboxes is a great solution.
Want a downloadable template to get started? Contact us and we’ll send one your way!
