Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
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.
Excel Checklist (Table of Contents)
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 task, 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 frame 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 kind of problems in the past you can learn the ways of creating checklists in excel. In this article, I will explain 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 the ways of using checkboxes. Checkboxes represent the selection and deselection visually.
The checkbox is available under the Developer tab. If you do not see the developer tab enable it. Once the developer tab is enabled it you can see the checkbox as shown in the below image.
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.
Copy this list in excel. Go to Developer tab then Select Check Box and Draw in B2 Cell.
Now drag the checkbox against all the task list.
Now we have the checkbox for all the tasks.
Right click on the first checkbox and select Format Control in excel.
Under Format Control go to Control and select Checked and give cell reference to C2 cell.
Now, this checkbox is linked to the cell C2. If the checkbox is ticked it will show TRUE as the result in C2 or else it will show FALSE as the result in C2 cell.
Similarly, repeat the same task but keep changing the cell reference to the respective cell. For example, for 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.
Now as the tasks keep completed keep ticking the respective task boxes to update your task list.
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.
Step 2: Go to Home and select Conditional Formatting then New Rule.
Step 3: Under New Rule mention the formula as =$C2=”TRUE”
Step 4: Now click on Format.
Step 5: Under Format then Go to Fill and Select the color to highlight the completed task.
Step 6: Click on OK to complete the procedure. Now if the checkbox I 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.
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 template 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
Step 3: Now you will see all the conditional formatting list. Select the rule and click on Edit Rule.
Step 4: Now click on Format and under format select Font and select Strikethrough.
Step 5: Click on OK. All the tasks which are completed will be strikethrough.
Step 6: Finally hide column C to make the checklist template more beautiful.
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.
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 –