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.”
If you don’t see recent templates, click the plus sign at the bottom right and select “Choose Template”.
Go to the Personal section of the templates and select “Yearly Calendar”.
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.
You can refer to the Customize your calendar tab if you want to change the theme.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.”
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.
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.
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