• 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!

April 27, 2020

How to make a weekly planner using Google Sheets (free online tool)

About a year ago I made a bunch of tutorials on how to make printables using Microsoft Excel. Since then I’ve had quite a few people email me saying they don’t want to pay for Microsoft Excel or they use Numbers for Mac. Well some of the same things you can do in Excel, you can do in a free online tool called Google Sheets!

How to make a weekly planner in 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 tutorials!

Here is my finished planner!

how to make a weekly planner printable in google sheets tips tutorial instructions free online tool alternative to microsoft excel all about planners

Choosing Colors

My favorite feature of Google Sheets is their color tool. In addition to already showing a color menu with various shades of the same color, you can also set custom combinations. It’s great for ombre planners which I like to use for scheduling printables. Rather than selecting each row individually, they have a nifty tool called alternating colors

changing colors in google sheets tutorial how to alternating colors shaded rows color coded ombre theme quick tips tutorial free

You can choose from their default styles (which I did for this planner) OR you can click the header 1, color 1 and color 2 boxes and choose colors from there.

If you want to use it in the future click the + button underneath custom styles to save it.

how to change colors quickly and easily in google sheets free online alternative to microsoft excel instructions video tutorial

Changing fonts

To change the font style (and size if you want to) for all of the text, click the square on the very top left (I’ve circled in red in the image below), then click in the font menu, size menu etc. to make your changes

how to make a weekly planner in google sheets quickly change font size style and colors tips tutorial videos instructions simple

Click the arrow beside the font name and either choose between the fonts shown in the dropdown menu, or choose more fonts

how to choose custom fonts in google sheets customise make a weekly planner using free software alternative to microsoft excel

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

If you only want to change some of the fonts, not all, left click and drag over the boxes you want to change.

You can change the text direction like I did when I made my planner, by clicking the box with the fonts direction you want to change and click the menus circled in the screenshot below.

I like to align the text to the middle of the box – you can do so by clicking the button that has 2 arrows and a line in the middle (circled in the screenshot below).

how to align text and change text direction rotate in google sheets quick tips tutorial

Resizing elements of the design

  1. Left click and drag your mouse along the row numbers on the left highlighting as many rows as you want to resize
  2. Hover your mouse on the line between cells (it should change from grey to blue and an arrow pointing up and down will appear)
  3. Left click on that blue line and drag down to expand, or drag up to reduce the width of all of the highlight rows

changing row heights in google sheets tutorial how to make a weekly planner using free software

You can do the same with the columns by selecting the letters at the top (A, B, C etc.)

Adding checkboxes

Click insert from the top menu and then checkbox

how to add a checkbox in google sheets tips instructions tutorial all about planners weekly planner-min

 

Tips for making printables in Google Sheets

  • If you’re making a 2 page weekly planner, make the first page and then copy it and change the days of the week. Much quicker to create it once and copy then to re-create it from scratch
  • I recommend no smaller than font size 14
  • 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

how to make multiple copies of a spreadsheet in google sheets tips tutorial how to make a weekly planner simple tutorial instructions

You can zoom in and out using the % button I’ve circled in the image below. It goes 50, 75, 100, 125% but you type in if you want a different number e.g. 60%

how to zoom in and out in google sheets

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

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)
  • Has a checkbox tool (quicker to create checkboxes than in Microsoft Excel)
  • 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 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 weekly planner monthly budgeting spreadsheets monthly calendar video tutorials ecourse all about planners

Found this tutorial helpful? Pin it!

how to make a weekly planner printable using google sheets tutorial video instructions all about planners ecourse learn

how to make a weekly planner in Google sheets free online tool alternative to microsoft excel video tutorial step by step instructions

You may also be interested in...

  • Making a DIY printable planner with a flexible layout (52 planners in 52 weeks – week 18)Making a DIY printable planner with a flexible layout (52 planners in 52 weeks – week 18)
  • The Process Behind Making a Printable PlannerThe Process Behind Making a Printable Planner
  • How to use Microsoft Programs online and if you don’t have a PC (i.e. if you have a Mac)How to use Microsoft Programs online and if you don’t have a PC (i.e. if you have a Mac)
  • How to make printables in Microsoft Excel (step by step tutorials)How to make printables in Microsoft Excel (step by step tutorials)
  • How to use pattern overlays in CanvaHow to use pattern overlays in Canva
  • How to use the rulers tool in Photoshop (step by step video tutorial)How to use the rulers tool in Photoshop (step by step video tutorial)

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, Microsoft Excel · Tagged: alternative to microsoft excel, best cheap alternative to excel, best software for makingprintables, free alternative to excel, google sheets review, google sheets versus microsoft excel, google spreadsheets review, how to make a printable using google sheets, how to make a weekly planner tutorial, how to make printables using excel, how to make printables using google sheets, software for making printables, tutorial for making a weekly planner

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

  • Artful Agenda Digital Planner review
  • Peter Pauper Press Essentials Dot Matrix Notebook Review (Including Pen Test)
  • 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

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

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

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