Use Free or Create Calendar Template in Google Sheet for 2020/2021

  • Reading time:3 mins read
  • Post category:Templates
  • Post comments:0 Comments

Calendar are superb tools to keep track of important upcoming scheduled tasks, planning monthly/weekly activities or giving your clients a roadmap of deliverables.

But do you need to work with spreadsheet applications like Google sheets to create and manage a calendar, when you have ton of other applications like Google Calendar, Microsoft Calendar etc.

Actually, why not. Exceptions always exist for good reason, and with Spreadsheets there are no bounds of customization which you cannot do otherwise.

In this article, we’ll understand how to use free Calendar Templates available within Google Sheet. Also, we’ll learn to create monthly/yearly calendar templates from scratch.

So, lets begin.

Free Resources

Feel Free to directly copy the templates used in this tutorial from below links:-

  1. 2021 Template from Google Sheets
  2. 2020 Template from Google Sheets
  3. Custom 2021 Template – Monthly View

Using Free Calendar Templates for 2021/2020

Google Sheets provides us with free ready-made Calendar Templates which are very easy to use. Simply follow the below steps.

  1. Open Google Sheets
  2. Open Template Gallery
  3. Find 2021 Free Template
  4. Select and Open 2021 Free Template

Below Visual Representation will help you understand the steps better.

1. Open Google Sheets. A page like below should open.

Google Sheets Home Page

2. Click on “Template Gallery” present in top right corner.

3. A whole list of free templates opens should open-up. Something like below:-

Template Gallery Google Sheet

4. Now scroll down to the “Personal” Section. As clearly visible we have 2021, 2020, 2019 free templates available for use.

Personal Section -Template Gallery Google Sheet

5. Select 2021. Below sheet should open up.

2021 Calendar Template Google Sheet

We have the calendar template now ready. Good thing is that not only we have a compresses yearly view, but also month-wise template handy in rest of the sheets.

Calendar Template Google Sheet 2021

Creating a Calendar Template for 2021 in Google Sheets

While the previous section should suffice for 90% of users, some of you may still want to create a new template(monthly/yearly) from scratch. So let’s begin.

Steps to create a Calendar in Google Sheets:-

  1. Open an Empty Google Sheet
  2. Create the Header names(Month and Days of week)
  3. Format Header as necessary
  4. Mark Dates(1,2,3,4…) in the calendar setup leaving alternate row blank
  5. Make necessary formatting changes
  6. Repeat steps 1-6 for other months.

So, that was a short summary. Lets go through each individual steps in more detail

1. Open a Blank Google Sheet like below.

Empty sheet Google Sheet

2. Delete Columns J to Z as they wont be needed

3. Now Type Jan’21 in B1.(Press F2 to enter Cell Edit Mode). Then make necessary Formatting Changes. (Merge -> Center Align -> Vertical Align -> Bold -> Color fill)

Creating a Monthly Calendar Template - Google Sheet

4. Below that, Type Monday in B3 and then select and drag right upto H3.

Creating a Monthly Calendar Template - Google Sheet

5. Now Start filling in the dates, leaving a row vacant in between

Creating a Monthly Calendar Template - Google Sheet

4. Once Done. Lets make some basic formatting enhancements. Starting with increasing the row height of vacant rows.

Creating a Monthly Calendar Template - Google Sheet

5. Now we’ll center align the entire setup, make text bold and add borders for better clarity.

Creating a Monthly Calendar Template - Google Sheet

In a similar fashion we can also create for Feb’21, Mar’21 and so on.

These templates can now be easily used to manage personal/professional schedules. Example below:-

Creating a Monthly Calendar Template - Google Sheet

That’s it on this topic. If you still have any questions, then drop a comment below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply