✦Template Printable Ideas Insights

How to Create a Checklist in Excel with Tick Boxes

By

Imagine you're planning a complex project or managing a lengthy to-do list. Excel's interactive and robust environment allows you to create customizable checklists to keep you organized and on track. In this guide, we will walk you through the process of creating a checklist in Excel with tick boxes, making your tasks not only manageable but also engaging.

Before we dive in, ensure you have Microsoft Excel installed on your computer. For this tutorial, we'll use the desktop version, but the concepts can also be applied to Excel Online. Let's get started!

Setting Up Your Worksheet

Begin by opening a new or existing Excel workbook. For a clean workspace,select the 'Blank workbook' template when opening Excel. The blank sheet provides a pristine canvas to design your checklist.

a screenshot of a cell phone with the text vacation checklist highlighted in red
a screenshot of a cell phone with the text vacation checklist highlighted in red
an excel spreadsheet showing the number and type of items available for each item
an excel spreadsheet showing the number and type of items available for each item
How to Tick Mark in Excel : Tick Mark or Check Box in Excel Cell | Tick or Check Mark in Excel Cell
How to Tick Mark in Excel : Tick Mark or Check Box in Excel Cell | Tick or Check Mark in Excel Cell

If you're using an existing workbook, click on the '+' icon at the bottom-left to add a new sheet. For an uncluttered workspace, you can even deselect the visibility of other sheets by right-clicking on their tabs and choosing 'Hide Sheet'.

Entering Tasks and Descriptions

Checklists typically consist of tasks or items, so let's start by naming these. In Row 1 (the header row), place your cursor in Column A's first cell (A1) and type 'Task'. In the adjacent cell (B1), type 'Description'. You can title these columns as per your preference, but these names suffice for now.

How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to Create, Align, and Use a Check Box for a To-Do List in Excel 2007 and 2010
How to Create, Align, and Use a Check Box for a To-Do List in Excel 2007 and 2010
How to Insert Check Mark in Excel (the Simplest Way)
How to Insert Check Mark in Excel (the Simplest Way)

Next, enter your tasks in the first column (A2:A10). The number of tasks can vary according to your needs, but including around 10 tasks will keep the tutorial manageable. For descriptions, enter relevant information in the second column (B2:B10). This description field is optional and can also be left blank.

Creating Tick Boxes

Now, let's add those handy tick boxes or checkboxes that make checklists so satisfying to complete. In Cell C1, click on the 'Home' tab in the ribbon. Then, click on the 'Format as Table' button. Select 'My table has headers' and click 'OK'.

The 'Format as Table' function automatically applies some formatting and adds check boxes. In cell C2, a small checkbox icon should appear. To change the size of the checkbox, click on 'Home' > 'Format' > 'Size' > 'Width'. Set the width to your desired size, ensuring the box remains visible and usable.

Create Edgy To-Do or Checklists with Check boxes in Excel + Shortfall calculator - PakAccountants.com
Create Edgy To-Do or Checklists with Check boxes in Excel + Shortfall calculator - PakAccountants.com
How to Insert a Checkbox in Excel In 3 Simple Steps
How to Insert a Checkbox in Excel In 3 Simple Steps
Little-known Excel hack to tick mark tasks once finished
Little-known Excel hack to tick mark tasks once finished
Add Cool Features to Your To Do Lists in Excel
Add Cool Features to Your To Do Lists in Excel
How to Create, Align, and Use a Check Box for a To-Do List in Excel 2007 and 2010
How to Create, Align, and Use a Check Box for a To-Do List in Excel 2007 and 2010
Insert a Checkbox in a Cell in Excel
Insert a Checkbox in a Cell in Excel

Customizing Your Checklist

With the basics in place, let's explore some ways to personalize your checklist and tailor it to your needs.

Adjusting Column Width: To accommodate longer task descriptions, click on the line between 'Description' headers in Columns A and B. Drag the line to the desired width. Repeat this process to adjust other column widths according to your needs.

Toggling Completable Items

By default, Excel's checkboxes aren't 'completable'- meaning they don't switch to a filled-in state when clicked. To make them functional, right-click on any checkbox (ex. C2), select 'Format Control', and then 'Conditional Formatting'. Set the rule as follows:

How to Use Excel Checkboxes | Interactive Checklists & Reports
How to Use Excel Checkboxes | Interactive Checklists & Reports
an excel spreadsheet with the text shift p and tick mark highlighted in yellow
an excel spreadsheet with the text shift p and tick mark highlighted in yellow
Excel Task List Template for Easy To-Do Management
Excel Task List Template for Easy To-Do Management
  • Hope of value = Cell Value
  • hedral value = Cell Value
  • kaille instruction = TRUE

Click 'OK', and now your checkboxes should turn solid when clicked.

Applying User-Defined Styles

If you want to differentiate completed and incomplete tasks, you can apply conditional formatting. To do this, select the range 'C1:C10', go to 'Home' > 'Conditional Formatting' > 'New Rule'. Choose 'Use a formula to determine which cells to format' and enter '<=C2=TRUE'. Select the format fill color as Green (or any color you prefer) and click 'OK'. This will highlight completed tasks in green.

Task Prioritization

Now that your checklist is functional, let's give it an extra touch by introducing task prioritization.

A simple way to prioritize tasks is to insert a 'Priority' column. In Row 1, enter 'Priority' in Cell D1. Depending on your preference, use 'High', 'Medium', and 'Low' or numerical values for ranking tasks. For this tutorial, let's use the former. Adjust the width of the new column to make room for these extra entries.

Sorting by Priority

To display tasks based on priority, click on any cell in the table, go to the 'Home' tab, and click 'Sort & Filter'. In the 'Sort' panel, select 'Priority' for both 'Sort by' and 'Then by' fields. Ensure 'Smallest to Largest' is selected for the first sort, and 'No Sort' is selected for the second sort. Click 'OK'.

Congratulations! Your Excel checklist with tick boxes, priorities, and custom styles is now ready to serve its purpose - making your tasks manageable and satisfying to complete. As you tick off each entry, watch your progress march diligently down the spreadsheet. Happy planning!