How to make a calendar in Google Sheets


Whether you want an online calendar to share with others, or just want a physical calendar that you can print and use at the office, you have three options for creating a calendar in Google Sheets. Let us begin.

Use a Google Sheets calendar template

Google Sheets offers an annual calendar template that updates to the current year. If you see templates at the top of your Google Sheet home page, select “Template Gallery.”

Google Sheets Template Gallery

If you don’t see recent templates, click the plus sign at the bottom right and select “Choose Template”.

Google Sheets Option choose template

Go to the Personal section of the templates and select “Yearly Calendar”.

Sheet annual calendar template

The template opens in your workbook with the full year on the first tab and each individual month on the remaining tabs. This gives you a nice snapshot of the entire year but with the ability to see each month on its own.

Annual calendar in Google Sheets

You can refer to the Customize your calendar tab if you want to change the theme.

Customize the template

Use a third-party template

You can search for “Google Sheets Calendar Templates” using your favorite search engine or take a look at the sites below. Each of these offers more than one template option, so be sure to check them out!

Vertex42 – You will see a variety of free templates for Microsoft Excel. Therefore, look for the Google Sheets (GS) symbol in the description to indicate that your app is compatible. Select a calendar to see all the details and use it with Google Sheets.

Vertex42 Calendar Template

Spreadsheet Class: You’ll find regular and lined calendar templates for free. Click the link for the calendar you want, and then follow the process to use the template.

Spreadsheet Class Calendar Template

Smartsheet – You can take advantage of free Google Sheets calendar templates without signing up for a Smartsheet account. Choose between portrait or landscape or opt for a specific type of calendar like a weekly planner or marketing calendar.

Smartsheet Calendar Template

Create a calendar from scratch

Depending on whether you want a monthly, yearly, or even weekly calendar, the steps will obviously vary. For the most common type, here’s how to make a monthly calendar.

Open a blank workbook in Google Sheets and give it a name. Then select the first cell on the sheet, A1, and enter the month.

Enter the month

Select the next cell, A2, and enter the day of the week you want to start, which is usually Sunday or Monday, depending on your preference. We will use Sunday for our example.

Enter the day

Use the fill handle to drag the first day of the week into the cells on the right until you reach the last day. For our example, this is Saturday. This fills every day for you.

fill the days

Enter the number 1 for the first day of the month in the correct column for the day of the week. Since we are using January 2022, this is a Saturday.

Enter a single number date

Skip a row to format the calendar later. Insert at least two numbers for the first two days of the week (we used 2 and 3) and then drag to the right using the fill handle to fill in the rest of the numbers for that week. Follow the same process for the remaining weeks of the month.

Fill in the numbers for the dates.

Next, you’ll use those empty rows to create larger cells, just like you would see with a monthly wall calendar. Select each empty row by holding down Ctrl on Windows or Command on Mac as you click each one.

Select the empty rows

Drag one of the rows down until you see the size you want for the cells and release. All empty rows will be adjusted to that exact size.

Expand empty rows

Customize your calendar

Now you can customize your calendar to give it a nice look. While you can do this any way you like, here are the changes we’ll be making.

Combine and center the month: Select the cell that contains the month, drag the cells to the end of the calendar on the right, and click the Merge button on the toolbar to select “Merge Horizontally”. Then use the Alignment button on the toolbar to choose the center option.

Merge month cells

Center the days of the week: Select the cells containing the days of the week and use the Alignment button on the toolbar to choose the center option.

Center day cells

Fill in the rows with numbers: Select the cells that contain the numbers and use the Fill Color button on the toolbar to apply a color.

Color the rows of numbered dates

Format the font of the month and days: Select the cell that contains the month and change the font size, color, and style using the toolbar buttons. Then do the same for the days of the week. This makes the month and days stand out.

Format the fonts

When you’re done creating your calendar, you can add events, birthdays, holidays, or whatever you like by inserting text in the square for that day. You can even insert an image into a cell.

January calendar in Google Sheets

RELATED: How to insert an image into a cell in Google Sheets

Add the remaining months

Create a duplicate of the sheet by clicking the arrow on that tab and selecting “Duplicate.”

Duplicate a sheet

Then go to the duplicates tab and update the calendar for the next month, changing the name of the month and the location of the dates in the days of the week. Do the same with the remaining months of the year.

February calendar in Google Sheets

You can also change the sheet names to months for quick access to the month you want. Just double-click the sheet name, add a new one, and press Enter or Return.

Rename sheets

Now is the time to share your calendar with any of your collaborators. Or, if you were planning on having a physical calendar to use on your wall or desk, print out the spreadsheet.

RELATED: How to print a spreadsheet or workbook in Google Sheets