{"id":462402,"date":"2022-06-13T22:00:00","date_gmt":"2022-06-13T19:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-calendar-in-google-sheets\/"},"modified":"2022-06-13T22:00:00","modified_gmt":"2022-06-13T19:00:00","slug":"how-to-make-a-calendar-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/","title":{"rendered":"#How to Make a Calendar in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a4a26dbc9dc9\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a4a26dbc9dc9\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/#%E2%80%9CHow_to_Make_a_Calendar_in_Google_Sheets%E2%80%9D\" >&#8220;How to Make a Calendar in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/#Use_a_Google_Sheets_Calendar_Template\" >Use a Google Sheets Calendar Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/#Use_a_Third-Party_Template\" >Use a Third-Party Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/#Create_a_Calendar_From_Scratch\" >Create a Calendar From Scratch<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/#Customize_Your_Calendar\" >Customize Your Calendar<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-calendar-in-google-sheets\/#Add_the_Remaining_Months\" >Add the Remaining Months<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Make_a_Calendar_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Make a Calendar in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-804314\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/GoogleSheetsMyMonthlyCalendar.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets monthly calendar\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Whether you want an online calendar to share with others, or you just want a physical calendar you can print and use in the office, you have three options for creating a calendar in Google Sheets. Let\u2019s get started.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_a_Google_Sheets_Calendar_Template\"><\/span>Use a Google Sheets Calendar Template<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google Sheets offers an Annual Calendar template that updates to the current year. If you see templates at the top of your main Google Sheet page, select \u201cTemplate Gallery.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804265\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/TemplateGallery-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets Template Gallery\" width=\"650\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you don\u2019t see recent templates, click the plus sign on the bottom right and pick \u201cChoose Template.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804266\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/ChooseTemplate-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets Choose Template option\" width=\"230\" height=\"135\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Move to the Personal section of the templates and select \u201cAnnual Calendar.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804271\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/AnnualCalendarTemplate-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Annual Calendar template in Sheets\" width=\"650\" height=\"342\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The template opens in your workbook with the entire year on the first tab and each individual month on the remaining tabs. This gives you a nice snapshot of the whole year but with the ability to see every month on its own<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804269\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/UseAnnualCalendar-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Annual Calendar in Google Sheets\" width=\"650\" height=\"478\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can look at the Customize Your Calendar tab if you\u2019d like to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/745376\/how-to-use-and-customize-a-theme-in-google-sheets\/\">change the theme.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804270\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/CustomizeAnnualCalendar-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Customize the template\" width=\"538\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_a_Third-Party_Template\"><\/span>Use a Third-Party Template<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can search for \u201cGoogle Sheets Calendar Templates\u201d <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/114176\/how-to-easily-create-search-plugins-add-any-search-engine-to-your-browser\/\">using your favorite search engine or take a look at the sites below. These each offer more than one template option, so be sure to check them out!<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/redirect.viglink.com\/?key=204a528a336ede4177fff0d84a044482&amp;u=https%3A%2F%2Fwww.vertex42.com%2Fcalendars%2F\">Vertex42<\/a>: You\u2019ll see a variety of free templates for Microsoft Excel. So, look for the Google Sheets symbol (GS) in the de<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">script<\/a>ion to indicate your application is supported. Select a calendar to see full details and use it with Google Sheets.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804272\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/Vertex42CalendarTemplate-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Vertex42 calendar template\" width=\"650\" height=\"437\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.spreadsheetclass.com\/google-sheets-calendar-templates\/\">Spreadsheet Class<\/a>: You\u2019ll find Normal and Lined calendar templates for free. Click the link for the calendar you want and then follow the process to use the template.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804273\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/SpreadsheetClassCalendarTemplate-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Spreadsheet Class calendar template\" width=\"650\" height=\"385\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.smartsheet.com\/free-google-calendar-templates\">Smartsheet<\/a>: You can take advantage of free Google Sheets calendar templates without signing up for a Smartsheet account. Pick from portrait or landscape or opt for a specific type of calendar like a weekly planner or marketing calendar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804274\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/SmartsheetCalendarTemplate-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Smartsheet calendar template\" width=\"650\" height=\"478\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_Calendar_From_Scratch\"><\/span>Create a Calendar From Scratch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Depending on whether you want a monthly, yearly, or even a weekly calendar, the steps will obviously vary. For the most common type, here\u2019s how to make a monthly calendar.<\/p>\n<p>Open a blank workbook in Google Sheets and give it a name. Then, select the first cell in the sheet, A1, and enter the month.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804279\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/Month-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the month\" width=\"387\" height=\"193\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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\u2019ll use Sunday for our example.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804278\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/Day-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the day\" width=\"245\" height=\"112\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Use the fill handle to drag the first day of the week to the cells on the right until you reach the last day. For our example, this is Saturday. This fills in all the days for you.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804277\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/FillDays-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Fill the days\" width=\"650\" height=\"94\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Enter the number 1 for the first day of the month in the correct column for the day of the week. Since we\u2019re using January 2022, this is on a Saturday.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804282\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/Number-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter a single number date\" width=\"650\" height=\"92\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Skip a row to format the calendar later. Insert at least two numbers for the first two days of the week (we use 2 and 3) and then drag to the right using the fill handle to fill the rest of the numbers for that week. Follow the same process for the remaining weeks in the month.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804281\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/FillNumbers-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Fill the numbers for the dates\" width=\"650\" height=\"149\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, you\u2019ll use those empty rows to create larger cells, just like you see with a monthly wall calendar. Select each empty row by holding Ctrl on Windows or Command on Mac as you click each one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804285\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/SelectEmptyRows-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the empty rows\" width=\"650\" height=\"287\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Drag one of the rows down until you see the size you want for the cells and release. All empty rows will adjust to that exact size.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804284\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/EnlargeEmptyRows-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enlarge the empty rows\" width=\"628\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Customize_Your_Calendar\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Customize Your Calendar<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now you can customize your calendar to give it a nice appearance. While you can do this any way you like, here are the changes we\u2019ll make.<\/p>\n<p><b>Merge and Center the Month<\/b>: Select the cell containing the month, drag through the cells to the end of the calendar on the right, and click <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/446147\/how-to-merge-cells-in-google-sheets\/\">the Merge button in the toolbar to pick \u201cMerge Horizontally.\u201d Then, use the Alignment button in the toolbar to pick the center option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804289\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/MergeMonth-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Merge the month cells\" width=\"650\" height=\"115\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><b>Center the Weekdays<\/b>: Select the cells containing the days of the week and use the Alignment button in the toolbar to choose the center option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804288\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/CenterDays-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Center the day cells\" width=\"650\" height=\"110\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><b>Fill the Number Rows<\/b>: Select the cells containing the numbers and use the Fill Color button in the toolbar to apply a color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804290\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/ColorRows-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Color the numbered date rows\" width=\"650\" height=\"468\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><b>Format the Month and Days Font<\/b>: Select the cell containing the month and change the font size, color, and style with the buttons in the toolbar. Then, do the same for the days of the week. This makes the month and days stand out.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804287\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/FormatFont-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format the fonts\" width=\"650\" height=\"156\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish creating your calendar, you can add events, birthdays, holidays, or whatever you like by inserting text into the square for that day. You can even insert an image into a cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804291\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/January-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"January calendar in Google Sheets\" width=\"607\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Insert an Image in a Cell in Google Sheets<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Add_the_Remaining_Months\"><\/span>Add the Remaining Months<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Create a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/744858\/how-to-copy-or-move-a-spreadsheet-in-google-sheets\/\">duplicate of the sheet by clicking the arrow on that tab and picking \u201cDuplicate.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804292\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/DuplicateSheet-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Duplicate a sheet\" width=\"282\" height=\"396\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then go to the duplicate tab and update the calendar for the next month, changing the month name, and where the dates land on the days of the week. Do the same for the remaining months in the year.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804294\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/February-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"February calendar in Google Sheets\" width=\"650\" height=\"460\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also change the sheet names to the months for quick access to the month you want. Simply double-click the sheet name, add a new one, and press Enter or Return.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-804293\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/RenameSheet-GoogleSheetsMakeCalendar.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Rename the sheets\" width=\"307\" height=\"52\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>It\u2019s now time to share your calendar with any of your collaborators. Or, if you were planning to have a physical calendar for use on the wall or your desk,\u00a0print the spreadsheet.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Print a Spreadsheet or Workbook in Google Sheets<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/804259\/how-to-make-a-calendar-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Make a Calendar in Google Sheets&#8221; Whether you want an online calendar to share with others, or you just want a physical calendar you can print and use in the office, you have three options for creating a calendar in Google Sheets. Let\u2019s get started. Use a Google Sheets Calendar Template Google Sheets&#8230;<\/p>\n","protected":false},"author":1,"featured_media":462403,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/05\/GoogleSheetsMyMonthlyCalendar.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-462402","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/462402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=462402"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/462402\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/462403"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=462402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=462402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=462402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}