• HOME
  • Planning
    • Planner Newbie
      • New to planning? Start here
    • Planning Tips & Inspiration
    • 52 Planning Systems in 52 Weeks
      • My weekly spreads
    • Planner Index
    • 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
    • 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
    • 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
      • How to Make Planner Stickers
      • How to Make Printables in Photoshop
      • How to Make Printables in Microsoft Word
      • How to Make Printables in Microsoft Excel
      • How to make digital planners and notebooks in Microsoft PowerPoint
      • How to Make Labels in Photoshop
      • How to Make Patterns in Photoshop
      • How to Make 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!

December 31, 2020

How to make a monthly calendar printable using Google Sheets (online tool similar to Excel)

I previously posted a tutorial on how to make a weekly planner in Google Sheets. I had some comments on that video saying the audio wasn’t loud enough so I’ll be re-recording that tutorial sometime in the future.

In the meantime I’ve recorded another tutorial for using Google Sheets. This time, how to make a monthly calendar. You can use a similar process to make the weekly planner from my previous tutorial (really the only difference is the number of columns and rows you want your printable to have).

How to make a monthly calendar using Google Sheets

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!

Download the Google Sheets template I made in the video by entering your details below. Existing subscribers can login and download the file here.

More helpful posts about making printables

  • Microsoft Word versus Excel: which is better for making printables
  • How to make a printable chore chart using Microsoft Excel (including video tutorial)
  • How to make a weekly planner using Canva (free online design program)
  • How to make an A5 size, 2 page weekly planner printable in Photoshop (video tutorial)
  • How to make printable graph paper in Photoshop (perfect for habit tracking and bullet journalling!) 

Some of the ways you can use a monthly calendar:

  • Meal planning
  • Bills
  • School or college assignments and exam due dates
  • Most important task for each day
  • Cleaning routine
  • Work schedule
  • Kid’s activities
  • Social media content planning

monthly calendar template google sheets how to make rainbow change colors font style font size tutorial quick easy

Tips for making printables in Google Sheets

  • If you’re making a 2 page monthly planner, make the first page and then copy it and change the days of the week. Much quicker to create it once and copy, than re-create it from scratch
  • I recommend no smaller than font size 14 for the dates and days of the week
  • If you want to use the same template but change it slightly, you can save a copy by right clicking on the tab and choosing duplicate. This way you’ll always have the original to come back to and won’t need to re-create the entire template from scratch
  • Google Sheets auto saves your spreadsheet
  • As Google Sheets is web based, you can login to Google Sheets and access your spreadsheet on multiple devices – computer, iPhone, iPad etc. I recommend designing your printable on your computer (much faster to design with a mouse and keyboard than a touchscreen)
  • CTRL and z on your keyboard to undo

monthly calendar template google sheets how to make rainbow change colors font style font size tutorial

Once you’ve made your template you can make small changes to create new templates

  • Delete some of the rows (e.g. the date rows)
  • Change the column width to create a portrait page orientation calendar instead of landscape
  • Add a column to the left and add week numbers
  • Change colors to either different colors for each row, one color for everything, a different color every second row etc.
  • Change font colors
  • Change font style

Color Coding Recurring Tasks

You can pre-enter text if you have recurring tasks or bills that happen on the same day each month. Press ALT and enter on your keyboard for a new line.

You could color code the entire square…

monthly calendar google sheets template tutorial color coded schedule digital planning free online tool

Or if you have multiple things happening on the same day, use different font colors

printables tutorial google sheets monthly calendar tips color coded school college simple quick easy free online tool

Changing colors

You can choose from the colors already included in Google Sheets’ color menu. If you have a specific color/s you like to use, you can enter the hex code by clicking ‘custom’ in the color menu (refer screenshot below).

google sheets custom color tool how to change colors tips instructions how to make a monthly calendar printable template

This will pop up the color picker tool where you can move the circle around until you find a color you like, or enter the 6 digit hex code of the color you want to use.

google sheets tutorial how to change colors custom color tool how to make printables all about planners

how to make a monthly calendar in google sheets video tutorial tips step by step instructions all about planners change color easy to use no previous design experience

I like my planner to start on Monday, not Sunday. However now that you know how to make your own you can choose! If you need more space on weekends you can make those columns bigger than the weekdays.

I prefer to leave all boxes white but you could shade the empty boxes and add the dates for the past month and next month if you prefer.

how to make a monthly calendar printable google sheets free online tool software

You can change the border colors by left clicking and dragging your mouse over the boxes you want to change the border color. Then go to the border menu, choose your color and select ‘all borders’

how to change border color in google sheets tutorial for making printables all about planners monthly calendar

Text Alignment & Fonts

To change the positioning of your text, click the vertical and horizontal align buttons. You can use the same buttons to align text to the middle of a row.

how to justify text in google sheets centre align tips multiple rows and columns change font style and size how to make a monthly calendar printable

You can type text on the side using the text rotation tool (refer screenshot below)

how to rotate text in google sheets how to type text on the side make a monthly calendar printable in google sheets

If you’ve done a separate row for the numbers like I did in the tutorial, you can merge the cells together by left clicking and dragging to select the cells you want to merge. Then go to the merge menu and choose ‘merge vertically’

merge tool in google sheets how to type text on the side simple quick easy tutorial how to make a monthly calendar

If you don’t like the fonts in Google Sheets you can choose a custom font by selecting ‘More Fonts’

how to change font style in google sheets tutorial for making a printable monthly calendar diy custom planner

And search the name of the font you want to use

changing font style in google sheets tutorials tips for making a free weekly planner

Create a copy of your template

You can make a copy of your template by right clicking on the tab and selecting ‘duplicate’. I like to keep a master template.. just in case

monthly calendar video tutorial template google sheets simple quick easy minimalist all about planners

If you want to make calendars for each month of the year, look at an annual overview calendar and you’ll notice that some months have the 1st day of the month starting on the same day. E.g. September 2021 starts on Wednesday and so does December 2021.

Portrait or landscape page orientation

You can use the same template and just change the column widths to switch between portrait or landscape page orientation.

Printing your planner

You can either print directly from Google Sheets by going to File > Print

Or you can download the template to PDF by going to File > Download > PDF document

how to print to pdf from google sheets or export to excel tutorial for making printables

For printing tips, see these posts:

  • How to print any printable at any page size
  • 7 Ways to make colors POP when printing using an Inkjet printer 
  • Don’t own a printer? Here are 5 companies that will print and ship printables to your door
  • How to get rid of a white border when printing printable (borderless, no bleed, no scaling step by step video tutorial)
  • How to Choose a Printer (Including the best printer for printing printables and planner stickers) 
  • Best Paper for Printing Printables
  • How to clean your printer (prevent smudging, streaks and make the colors POP!) 
  • How to print any printable in black and white (greyscale) using your home printer 
  • How to easily print printables double sided (duplex printing tutorial)

Using the planner you’ve made in Google Sheets

Since Google Sheets is a free online tool, you can access it from multiple devices – your computer, iPad, tablet, phone etc. Any changes you make will be saved when you move between devices. So if you make a change on your iPad, you’ll see that change when you open that same file on your computer.

Download the template made in this tutorial

Download the Google Sheets template I made in the video by entering your details below. Existing subscribers can login and download the file here.

 

The easiest way for me to share this template is for me to export the Google Sheets template as a Microsoft Excel spreadsheet. You can import it into Google Sheets by clicking the plus sign from the Google Sheets home screen which will open up a new blank Google Sheets file.

Go to File > Import

how to import a microsoft excel spreadsheet into google sheets

Locate the file from the downloads folder of your computer

how to import a microsoft excel spreadsheet into google sheets 2

Then choose ‘create new spreadsheet’

how to import a spreadsheet in google sheets tutorial for making a printable all about planners

Now you can use the spreadsheet in your own Google Sheets account.

Pros of Google Sheets

  • Free
  • Online tool you can access from anywhere, you just need a Google account (if you use Gmail, it’s the same login)
  • Can easily duplicate a template once you’ve made it, to make a lot of printables in a short amount of time
  • Quick
  • Simple & easy to use
  • Great color tools menu (can use whatever color you like!)
  • Can do much the same things that you can do in Microsoft Excel

Cons of Google Sheets

  • Similar tools to Microsoft Excel but Google Sheets’ menu is a bit clunky to use with many sub-menu’s
  • The tools menu is compressed and there are less images – I find it takes longer to find the tool I’m looking for
  • Takes longer to draw / add shapes than in Excel
  • Difficult to make your printables look unique
  • My favorite keyboard shortcuts CTRL and + which I use to zoom in and out in MIcrosoft Excel, doesn’t work in Google Sheets

Ready to upgrade to Microsoft Excel? Enrol in my ecourse – all of the details are here.

how to make printables in excel ecourse tutorial horizontal weekly vertical 2 page categories hourly vertical

Found this post helpful? Pin it!

google sheets monthly calendar templates fully customisable how to make your own planner diy planner color coded

google sheets fully customisable monthly calendar template printable how to your own printables video tutorial monday week start sunday you choose portrait landscape page orientation

how to make a printable monthly calendar in google sheets video tutorial color coded free online tool similar to microsoft excel all about planners tutorial

 

You may also be interested in...

  • How to make an A5 size, 2 page weekly planner printable in Photoshop (video tutorial)How to make an A5 size, 2 page weekly planner printable in Photoshop (video tutorial)
  • How to Make Printables in Photoshop (step by step video tutorials)How to Make Printables in Photoshop (step by step video tutorials)
  • How to make planner printables (advice from a planner addict that’s made over 4000 printables)How to make planner printables (advice from a planner addict that’s made over 4000 printables)
  • How to make a planner bookmark (DIY Page Markers Tutorial)How to make a planner bookmark (DIY Page Markers Tutorial)
  • The ‘Create your own planner kit’ (108 printable pages to create your perfect planner!)The ‘Create your own planner kit’ (108 printable pages to create your perfect planner!)
  • How to resize any printable for any size bullet journalHow to resize any printable for any size bullet journal

Share this:

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

Posted In: Digital Planning, Graphic Design, How To - Tutorials, Microsoft Excel · Tagged: all about planners, all about planners printable, diy planner, google sheets calendar, google sheets calendar template, google sheets planner, google sheets printables tutorial, google sheets tutorial, google sheets tutorials, how to create your own planner, how to create your own printables, how to make a monthly calendar, how to make a monthly calendar in google sheets, how to make a printable in google sheets, how to make printables, how to make printables free online, monthly calendar printable, monthly calendar printable template, monthly calendar template, monthly calendar tutorial, printable monthly calendar, printable monthly calendar template, printable tutorial, rainbow monthly calendar

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

  • ARC Punch versus Happy Planner versus the Levenger 1-2-3 Punch: Which is better?
  • Clever Fox Planner Pro Weekly Review
  • Simple Christmas themed weekly spread with washi tape and stencils
  • 10 Useful printables to add to your planner or bullet journal
  • Bullet journal stencils weekly spread in the Archer and Olive Notebook

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

  • Setting up a new planner: 70 Tasks to add
  • 130+ functional ideas to use blank notes pages of your planner or an empty notebook
  • Planner Organization: How to color-code your planner so you’ll actually use it effectively
  • 100 things to put in your habit tracker of your planner or bullet journal (plus free printable habit tracker)
  • 10 Useful printables to add to your planner or bullet journal

Printables

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

Subscribe to access the free Printables library

Follow Me

  • Instagram
  • Pinterest
  • YouTube
Privacy

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