How to Use Checkboxes and In-Cell Lists for Interactive Project Tracking in Excel (Microsoft 365)

If you are using Excel solely for basic data entry, you are missing out on modern interactive capabilities available in Microsoft 365. Two standout features—Checkboxes and In-Cell Lists—make it much simpler to build dynamic status dashboards, track completion rates, and manage categorical values directly within cells.

Below is a breakdown of how to implement both features in real business scenarios.

1. Interactive Checkboxes & Task Trackers

When managing a project template or task list, you can replace plain text inputs with functional checkboxes.

- Inserting Checkboxes: Select the target range in your task table and insert a checkbox from the ribbon.

- Creating a Dynamic Status Column: A checked box returns TRUE, while an unchecked box returns FALSE. You can leverage this directly using a standard IF statement (for example, in cell F3 referencing checkbox cell D3):

=IF(D3, "Completed", "Pending")

Copy this formula down using Ctrl + D. Toggling the checkbox will instantly flip the status between Completed and Pending.

- Calculating Real-Time Completion Percentages: To display an overall completion rate across all tasks:

1. Add a summary cell at the top of your sheet.

2. Use COUNTIF alongside COUNTA:

=COUNTIF(D3:D20, TRUE) / COUNTA(D3:D20)

3. Format the cell as Percentage (%).

Whenever a task is checked off, your completion metric updates automatically, giving teams and stakeholders immediate visibility into project progress.

2. In-Cell Lists for Skill and Tag Management

Instead of creating messy text strings or sprawling columns to capture multiple skills or tags per employee:

- Select the relevant cell under your dataset.

- Go to Insert > List.

- Enter your values (such as Power BI, SQL, Python).

- Hit Enter.

Hovering over the cell reveals the clean, consolidated list directly in place, keeping your dataset structured and readable.