After looking at the search data on my site, there one phrase in the top 10 that kept coming up was "checklist". So, by popular demand, we've created a few different printable checklists along with some checklist templates that you can edit in Excel.

Advertisement
Checklists

Check List Templates

House Cleaning Checklist House Cleaning Checklist Template
Excel 2003+, PDF
Prepare for a visit, spring-clean, or create a cleaning schedule.
Spring Cleaning Checklist Spring Cleaning Checklist Template
Excel 2003+, PDF
A room-by-room checklist for seasonal cleaning.
Packing Checklist Packing Checklist Template
Excel 2003+, PDF
Be prepared for your vacation, business travel, or college.
Camping Checklist Camping Checklist Template
Excel 2003+, PDF, ODS, GD
Download a general checklist for your camping trip.
Backpacking ChecklistBackpacking Checklist
Excel 2007+, PDF, GD
Use this backpacking list to help you remember the essentials. Includes packing tips.
Moving Checklist Moving Checklist Template
Excel 2003+, PDF, ODS, GD
Things to do to get ready and things to do after you've moved.
New Baby Checklist New Baby Checklist Template
Excel 2003+, PDF, ODS
Stuff you'll need to have or do after that new baby comes.
Grocery List Grocery List Template
Excel 2003+, PDF, ODS
Print a simple blank grocery list or a categorized grocery list.
This annual calendar was designed to be used as a New Year's Resolution Checklist.
Wedding Checklist Wedding Checklist Template
Excel 2003+, PDF, ODS, GD
Stuff to consider when planning a wedding.
A new look for our original wedding checklist template.
To Do List To Do List Template
Excel 2003+, GD
Great for creating to do lists for projects.

Advertisement

Other List Templates

Wedding Guest List Wedding Guest List Template
Excel 2003+, ODS, GD
Keep track of wedding invites and RSVPs for your wedding dinner and reception.
Make a list of people to invite to your wedding dinner and reception. Track RSVPs and estimate costs.
Contact List Contact List Template
Excel 2003+, ODS, GD
Create a list for gifts, Christmas cards, service company contacts, etc.
Medication List Medication List Template
Excel 2007+
Create and print a list of medications, pills, vitamins, and supplements.
Customer ListCustomer List
Excel 2003+
Add a Customer List worksheet to your invoice, work order, or other worksheet. Includes instructions for how to set up a drop-down list and create lookup formulas.

Advertisement

Creating Checklists in Excel

The main question people have when creating a checklist in Excel is what method to use to create the check box. I've listed the most common methods below, along with an explanation of the uses and pros/cons.

  • Cell Borders - This is perhaps that simplest and fastest way to create a checklist from scratch. Just size the column containing the check boxes so that they appear square. It is easy to customize by copying and pasting items, inserting new items, etc. I use this approach in the wedding and camping checklists.
  • Special Box Character - This is my second favorite approach, which I used for the wedding checklist. The only hard part is remembering how to find the special open 'box' character. The character I like to use is the White Square (□). I usually just open up the Windows Character Map application to browse through the special symbols until I find it, then copy and paste. If you're going retro, you could also use parenthesis as the placeholder for the check mark like this: (  )
  • Parentheses (  ) or Brackets [  ] - This is a very common simple approach for including a checkbox within a text-based file. You'll see this approach used a lot in legal documents and other types of forms. If that's the look you're going for with your checklist, then by all means, go for it.
  • Autoshapes (Drawing Objects) - I don't recommend this approach unless you are going for something fancy, like using fluffy clouds in your check list. Moving a bunch of autoshapes around in the spreadsheet can get messy and annoying.
  • Checkbox Form Object - Use the checkbox form field only if you are wanting to add interactivity to your checklist. The checkbox form field, found in the Forms toolbar, can link to a cell in the spreadsheet without requiring any Visual Basic programming. The linked cell will be a boolean value TRUE or FALSE. Like the drawing objects, working with a large number of checkboxes can get messy.

Sharing Our Checklists

Our checklists and checklist templates are licensed for personal use only. However, to avoid a bunch of emails, I will also say that I am okay with you doing almost anything with these checklists except posting the checklist (or anything you have created using the checklist template) on the internet or selling it. That includes permission to print and distribute as many paper copies of your checklist as you need. Don't remove the copyright or hyperlinks that I've included in the spreadsheet, though.

Thank you.

LIKE THIS PAGE?

Follow Us On ...

       
Master Excel - Spreadsheet Tips Workbook

Browse Template Categories