WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Checklist in Excel

Checklist in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

By Jeevan A Y

Checklist is the checkbox in excel which is used to represent whether a given task is completed or not, normally the value returned by checklist is either true or false but we can improvise with the results, when the checklist is tick marked the result is true and when it is blank the result is false, checklist can be inserted from the insert option in the developer’s tab.

What is a Checklist in Excel?

In excel, we can create a checklist template and keep us up to date with all the tasks needs to do for a particular project or event.

We all plan our tasks, events, etc. We usually memorize or note down somewhere to check the list of tasks needs to be completed or list of task that is completed.

When we are planning for an event, marriage, work that includes many steps, or a project to carry out at different time frames, we need many tasks to be completed on time. Remembering all those tasks r list of tasks is not a walk in the park; maintaining all the excel checklist isn’t that easy in a piece of paper.

If you have experienced such kinds of problems in the past, you can learn the ways of creating checklists in excel. In this article, I will introduce you to the interactive excel checklist template.

How to Create a Checklist in Excel Using CheckBoxes?

The most common way of creating an excel checklist template is using CheckBoxes in Excel. In our earlier article, I have elaborated on the ways of using checkboxes. Checkboxes represent the selection and deselection visually.

You can download this Checklist Excel Template here – Checklist Excel Template

The checkbox is available under the Developer tab. If you do not see the Developer tab, enable it. Once the developer tab is enabled, you can see the checkbox, as shown in the below image.

Check list in Excel

Example #1

I will explain to you the simple excel checklist template for your competitive exam. Below are the tasks you need to carry out before the exam.

Check list in Excel Example 1

Copy this list in excel. Go to the Developer tab, then Select CheckBox and Draw in B2 Cell.

Check list in Excel Example 1-1

Now drag the checkbox against all the task lists.

Check list in Excel Example 1-2

Now we have the checkbox for all the tasks.

Right-click on the first checkbox and select Format Control in excel.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Check list in Excel Example 1-3

Under Format Control, go to Control and select Checked and give cell reference to C2 cell.

Check list in Excel Example 1-4

Now, this checkbox is linked to the cell C2. If the checkbox is ticked, it will show TRUE as a result in C2, or else it will show FALSE as a result in C2 cell.

Check list in Excel Example 1-5

Similarly, repeat the same task but keep changing the cell reference to the respective cell. For example, for the next checkbox, I will give cell reference as C3, for next, I will give cell reference as C4, and so on.

Finally, all my checkboxes settings will be done, and it should look like the below one, as shown in the image.

Check list in Excel Example 1-6

Now, as the tasks keep completed, keep ticking the respective task boxes to update your task list template.

Example #2 – How to Make Your Checklist More Attractive?

The above checklist list template looks ordinary. We can make this a beauty by applying conditional formatting to it.

Step 1: Select all the tasks.

Beautify Your Task List step 1

Step 2: Go to Home and select Conditional Formatting, then New Rule.

Beautify Your Task List step 2

Step 3: Under New Rule, mention the formula as =$C2= “TRUE”

Beautify Your Task List step 3

Step 4: Now click on Format.

Beautify Your Task List step 4

Step 5: Under Format, then Go to Fill and Select the color to highlight the completed task.

Beautify Your Task List step 5

Step 6: Click on OK to complete the procedure. Now, if the checkbox is ticked, we will get a result as TRUE in column C, or else we will get the result as FALSE.

Conditional Formatting looks for all the TRUE values. If any TRUE value is found in column C, it will highlight the excel checklist area with Green Color.

Beautify Your Task List step 6

Example #3 – Strikethrough all the Completed Excel Check List

We can make the report more beautiful by going one extra mile in conditional formatting. We can strikethrough all the completed checklist templates with conditional formatting.

In general perception, strikethrough means something which is already completed or over. So we will apply the same logic here as well.

Step 1: Select the checklist data range

Step 2: Go to Conditional Formatting and click Manage Rules

Strikethrough Check List step 1

Step 3: Now, you will see all the conditional formatting lists. Select the rule and click on Edit Rule.

Strikethrough Check List step 2

Step 4: Now click on Format and select Font and select Strikethrough.

Strikethrough Check List step 3

Step 5: Click on OK. All the tasks which are completed will be strikethrough.

Strikethrough Check List step 4

Step 6: Finally, hide column C to make the checklist template more beautiful.

Strikethrough Check List step 5

Things to Remember about Checklist in Excel

  • Choose light color under conditional formatting to highlight.
  • Strikethrough will be the sign of something already completed.
  • You can create a dropdown list of Completed & Not Completed instead of time-consuming CheckBoxes.

Recommended Articles

This has been a guide to Checklist in Excel. Here we discuss how to Create a Checklist in Excel using Checkbox along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • Excel Rows & Columns Differences
  • Strikethrough Text in Excel
  • Sum by Color in Excel
  • Excel Developer Tab
  • Insert Multiple Excel Rows
  • How to Sort by Color in Excel
  • Vlookup Alternatives
  • Using AutoFit in Excel
113 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Category iconExcel Tutorials,  Excel, VBA & Power BI

Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Checklist Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More