• HOME
  • Planning
    • Planner Newbie
      • New to planning? Start here
    • Planning Tips & Inspiration
    • 52 Planning Systems in 52 Weeks
      • My weekly spreads
    • Planner Reviews
      • Horizontal Weekly
      • Horizontal 1 Page Weekly + Notes
      • Vertical Weekly
      • Hourly Planners
      • Categories Weekly
      • Daily Planners
      • Discbound Planners
      • Teacher Planners
      • Planner Roundups
      • Happy Planner (MAMBI)
      • Budget Planners
      • Undated Daily Planners
      • Undated Weekly
    • Planner Index
    • Planner Comparisons
    • Bullet Journal
      • Bullet Journal Reviews
      • Bullet Journal Spreads
      • Bullet Journal Tips
    • Planner pens
    • Highlighters
    • Planner Stickers
    • Digital Planning
    • Household Binder
    • Stationery Shopping
    • Rachael’s Favorites
    • Blogging & Online Business
  • Graphic Design
    • Photoshop Tutorials
    • Affinity Publisher
    • Microsoft Word
    • Microsoft Excel
    • Canva
    • Silhouette Studio
    • PicMonkey
  • SHOP
    • Shop at Etsy
    • Online Store
    • Graphic Design Resources
    • ECOURSES
    • Ebooks
      • 54 Mistakes Etsy Sellers Make (And How to Fix Them)
      • 1200 Blog Post Ideas
        • 1200 Blog Post Ideas (Exclusive Download Content)
      • 200 Blog Post Title Prompts (For Any Type of Blog)
        • 200 Blog Post Title Prompts (Exclusive Download Content)
    • Feedback & Testimonials
    • Planner Supplies (my sister’s shop!)
    • Shop my favorite planner supplies on Amazon
  • Learn
    • ECOURSES
      • Free Graphic Design Video Tutorials Library
      • Printables in Affinity Publisher
      • How to Make Planner Stickers
      • How to Make Printables in Photoshop
      • Printables in Microsoft Word
      • Printables in Microsoft Excel
      • Digital planners and notebooks in Microsoft PowerPoint
      • How to Make Labels in Photoshop
      • Make Patterns in Photoshop
      • Party Printables
      • How to Write Product Descriptions
    • Ebooks
      • 54 Mistakes Etsy Sellers Make (And How to Fix Them)
      • 200 Blog Post Title Prompts (For Any Type of Blog)
      • 1200 Blog Post Ideas
  • FREE
    • FREE Printables
    • Free Printables Library – Subscribers Login
  • Travel
    • Travel Planning
    • Europe
    • Australia & New Zealand
  • About
    • Browse All Posts
    • FAQ
      • What is a Printable? What happens when I purchase a printable from you?
      • Printing Tips
      • Printable Planner Stickers
      • Downloading Files
      • How to Open Zipped File Folders
      • What does EDITABLE mean?
      • Monogram Etiquette

All About Planners

Printable planners to organize your home, business and life!

July 29, 2019

How to make a printable chore chart using Microsoft Excel (including video tutorial)

If you’ve never made printables before then Microsoft Excel is a simple, quick & easy to use software to start with.

In the video below I show how to make a children’s chore chart but you could turn it into a weekly habit tracker, add routine tasks etc.

I use Microsoft Excel for this tutorial but you can also use WPS Office 2019 (which is like a free version of Excel).

To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon).

Subscribe to my YouTube channel for more planner videos & tutorials

Design Tips:

  • You can start the chore chart on Sunday or Monday – it’s up to you
  • Make sure you increase the row height so that it’s big enough for stickers, your child to tick the box etc.
  • I recommend using no less than font size 16 for planning printables. For this chore chart, I used font size 24 for the main text and 48 for the title text
  • You can change colors by clicking the arrow beside the paint bucket icon. If you don’t like those colors click ‘More colors’ and choose a custom color
  • Change the font size, style and color for the entire printable at the same time by clicking the triangle on the top left corner
  • You can add a list below the chore chart with the value of each chore like in the example below
  • There are so many free fonts available these days, see this post for a tutorial on how to download fonts (and my favorite font websites)
  • If you want to add graphics / clipart / images go to insert > pictures and locate the file on your computer. There is plenty of cute and affordable clipart on Etsy

More tutorials for making printables are in my ecourse (click here)

Finished chore chart:

printable chore chart boy childrens responsibility tasks routine habits to do

Weekly Habit Tracker

If you want to create a habit tracker for yourself you can do so with a few quick changes to the template we made in the tutorial:

  • Font style, size & color
  • You may wish to add shaded lines
  • If you’re going to print and add to your planner, I’d decrease the row height
  • You could pre-fill the tracker with your routine tasks so you don’t have to hand-write them after printing
  • You could add a goal and / or actual column like in the example below

You can either print and tick off each day, or if you want to leave it saved on your computer, color the cells when you’ve completed the task using the paint bucket / fill color tool.

weekly habit tracker printable tutorial how to make in excel example

More tutorials for making printables are in my ecourse (click here)

Printing the Chore Chart

  • I recommend printing using landscape page orientation
  • Be sure to check print preview to make sure nothing is cut off (go to file > print)
  • Most printers will add a thin white border on all sides so keep this in mind
  • You can remove the white border by selecting ‘borderless’ in your printer menu (note that cheap printers may not have this option) – see this post for helpful screenshots
  • You can change the page margins in the print menu or the page layout menu in Excel (see screenshot below)
  • See this post for printing tips

how to make printables in excel page margin menu how to prepare printables for printing

If you liked this tutorial there are plenty more in my ecourse! (click here)

how to make printables in excel weekly planner monthly budgeting spreadsheets monthly calendar video tutorials ecourse all about planners

Click here to enrol in the course!

Found this post helpful? Pin it!

how to make a printable chore chart childrens responsibility chart microsoft excel tutorial video

You may also be interested in...

  • How to make printables in Microsoft Excel (step by step tutorials)How to make printables in Microsoft Excel (step by step tutorials)
  • 7 Daily planner layout ideas for your bullet journal that DON’T include a timed schedule7 Daily planner layout ideas for your bullet journal that DON’T include a timed schedule
  • Microsoft Word versus Microsoft Excel: Which is better for making printables?Microsoft Word versus Microsoft Excel: Which is better for making printables?
  • 30 Minimalist Bullet Journal Weekly Spreads (set up the week in 10 minutes or less)30 Minimalist Bullet Journal Weekly Spreads (set up the week in 10 minutes or less)
  • Bullet Journal Layouts: 26 Non-typical 2 page weekly spreads to tryBullet Journal Layouts: 26 Non-typical 2 page weekly spreads to try
  • Planning Inspiration: 15 habit tracker tips & ideas to tryPlanning Inspiration: 15 habit tracker tips & ideas to try

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Posted In: How To - Tutorials, Planning Tips & Inspiration · Tagged: alternatives to the leuchtturm, bullet journal printables, easy printable tutorial, excel chore chart, excel for beginners, excel planner tutorial, excel printable chore chart, excel tips, habit tracker printable, habit tracker tutorial, how to make a chore chart, how to make a chore chart in excel, how to make a daily planner in excel, how to make a habit tracker, how to make a habit tracker in excel, how to make a monthly planner in excel, how to make a spreadsheet in excel, how to make a weekly planner in excel, how to make chore charts in excel, how to make printable chore chart, how to make printables in excel, how to make printables in microsoft excel, planner tutorial how making printables in excel, printable chore chart, printable habit tracker, printable kids habit tracker, printable responsibility chart, tutorial for making a habit tracker

Welcome

Welcome to All About Planners! I’m Rachael, a 20-something Aussie addicted to graphic design and all things planning. On the blog you’ll find more than 1,000 posts about all things planning including planner reviews, tips, favorite supplies and some of my past weekly spreads.

Subscribe and join 60,000+ others on the quest to find planner peace!

Follow Me

  • Instagram
  • Pinterest
  • YouTube

Search

Subscribe

free printables library sign up all about planners blog image graphic subscribe

Shop At Etsy

The photos and content on this site are the property of All About Planners. They are not allowed to be used without permission from All About Planners.

Categories

Recent Posts

  • How I make my travel photobooks using Blurb (Detailed Tutorial and Review)
  • My 4th Plum Paper Planners Haul! (weekly and daily planners, financial planner, goals planner)
  • 10 Strategies for tackling your to do list
  • How I Planned a 6 week European Holiday (Plus download my detailed Itinerary)
  • Time and ToDo Planner Review (Unique weekly layout)

Disclaimer

All About Planners is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

Popular Posts

  • 50 Tips for writing a better to do list that will make you more productive
  • 130+ functional ideas to use blank notes pages of your planner or an empty notebook
  • How I use Excel to Organize a Home Renovation (budget, spending, program, paint colors, contacts, quotes)
  • How I use Excel to organize all my travel plans (research, itinerary, hotel, tours, bookings, packing list etc.)
  • How I use Excel for organizing recipes, meal planning, food inventory and grocery lists

Printables

  • Learn How to Make Printables
  • How to Make Planner Stickers
  • Resources & Tools I Recommend

Follow Me

  • Instagram
  • Pinterest
  • YouTube
Privacy

Copyright © 2022 All About Planners · Theme by 17th Avenue