To fill in the numbers, youвЂ™ll only need to know the beginning day, then click and drag to fill in the rest of the rows. To do this, right-click the sheetвЂ™s tab and select Duplicate from the menu. Simply duplicate your January calendar once youвЂ™ve designed it how you want it to look. ItвЂ™s time to repeat for the month of February to December. Repeat the process from February to December. If it's for a client or upcoming project, you'll want to incorporate the necessary launch days here.ДЇor this step, I added in a few fun images, included a few hypothetical calendar events, and played with font sizes. Add design elements to professionalize the look.ДЇinally, you can add in some fun design elements to personalize the look and feel of your calendar. If desired, gray out the Saturday and Sunday columns so that your workdays stand out.Д§.If desired, lightly shade your numbered rows.To do this, use the vertical alignment tool. Select your entire calendar and vertically align all elements so that theyвЂ™re in the center of their cells.

Select the empty rows underneath your numbers and center them using the center text alignment tool.

Here are some additional formatting tips: To do this, I simply dragged the rows down to make those cells bigger. Remember those extra rows in between the numbered rows? I expanded those rows to create boxes underneath the numbers. Reformat your calendar if necessary.Д®verything is starting to look like a calendar, right? At this stage, I reformatted things to clean up the look of my calendar a little. Note: Make sure to end the month on the right number! For January, that would be the 31st. Depending on the day of the week, you may need to follow this process using the second day of the month so you can click and drag horizontally. Place the number 1 on the box right underneath the first day of the month, then click and drag horizontally. Before this step, I took the time to add color to the days row and changed the font to one I liked a little more.ДЇor the numerical values, weвЂ™ll simply identify the first day of the month and click and drag to fill in the rest.

Now we're going to fill in the numerical values. Fill in the numbers.Д®xcellent! You have your days of the week. Remember, if this doesn't work for you, you can always fill in the days manually. Pressing enter should automatically fill in the rest of the week. You're going to copy the formula in Sunday's cell by dragging the selector to the end of your row, (A-G), and pressing enter again. Then, press enter and select your first day. Highlight the number 1 in the formula and replace it with: COLUMN(). What this tells Google is that your number will be replaced by a date or time and the format you're using is weekdays. To fill in days of the week, in the cell where you want your first weekday to be, type: =TEXT(1, 'DDDD'). Sheets has a function that lets you type in formulas to complete certain actions at once. You can do this manually but I decided to use a formula. Next, fill in the days of the week in each column (A-G). Use a formula to fill in the days of the week. Then, I increased the font size and bolded the month. Here, I also center-aligned my text using the tool next to Merge. You can find this button to the right of the Fill tool. I highlighted seven columns (A-G), and clicked Merge to make that cell span across the entire column. I selected the text, January 2022, in Column A, Row 1. What's great about Google Sheets is that it automatically recognizes dates, so typing in a month, followed by the year in YYYY format will tell Google that you're going to be working with dates. For this example, I decided to do January 2022, so I filled that into the first cell. Open a new spreadsheet and choose your month. Repeat the process from February to December.ДЎ.Add design elements to professionalize the look.Use a formula to fill in the days of the week.Open a new spreadsheet and choose your month.

Calendar templates for google docs