Just as you did when creating a Table, you can customize the spreadsheet however you choose.Ĭlick on and use the different options in the menu above. For example, an editorial calendar could look something like this: Then you can go ahead and start filling in the elements. When in your Google Drive, select Google Sheets to open a blank spreadsheet. Another way to create your own calendar is by using a spreadsheet instead of a blank word document. You can also change the font, size, and color so that it’s easier to visually distinguish between certain days, weeks, or aspects. For instance, you could bold, underline, or italicize specific days, such as when there’s a deadline or important event. You can then tinker with your calendar to however you like. Finally, repeat those steps for the remaining 11 months. This will expand the bottom row of cells. This is done by clicking the black, horizontal line at the bottom of the calendar down. Keep in mind that you’ll have to resize your calendar so that the information you add fits. Now you can start adding in the proper information into the boxes. Just make sure that the correct dates correspond with the right day of the week. After you’ve entered the days of the week, start filling in the dates. Now you can go ahead and start adding the days of the week. Of course, depending on the month, you may need seven rows instead of six, such as if the first of the month starts on Thursday, Friday, or Saturday. Move your cursor until your table is seven cubes at the top and down at least six spaces. Underneath the name of the month, head over to Insert and click on Table. Rename from Untitled document to whatever specific calendar you’re creating, such as “Content Calendar” or “Tim’s Work Schedule.” If you don’t rename the piece - anyone can get into your content. To get started, open up a new Google Doc. Your first option would be to create a calendar completely from scratch. Create Your Own Google Docs Calendar - here’s how. Paper calendars are also helpful if you want to limit notifications, prevent hacking, and easily record additional details. You could even print the calendar out so that there’s a visual reminder. The doc can then be shared with employees, business partners, or your family with just once click of button. Creating a calendar to Google Docs is a way the calendar can meet your exact needs. In 2020, the good news is that you can easily create a calendar into a Google Doc. This could be an editorial calendar, work schedule for you and your team, a monthly budget, or even a three year calendar for your business plan. But there are times when you need to create a specific type of calendar. You can then use SUM to add up your two COUNTIF values, subtracting that figure from the number of cells in your range calculated using the ROWS and COLUMNS functions.Using an online calendar, like Google Calendar or Outlook, is perfect for reminding you of deadlines, birthdays, or appointments. To search for blank cells or cells containing text, type =COUNTIF(range,"*") in a third empty cell. Once again, replace range with the appropriate cell range for your data. In a second empty cell, type =COUNTIF(range,">=0") to count the number of cells with a numerical value. To start, open your Google Sheets spreadsheet, click on an empty cell and type =ROWS(range)*COLUMNS(range), replacing the range value with your cell range. You can then add the results from these calculations and subtract them from the number of cells in your data range. You’ll need to know the number of cells in your range first. To find that out, you can use the ROWS and COLUMNS functions. The example above has three blank cells (B4, C4, and D4) within the range A3 to H24, with the COUNTIF function in cell A1 returning the same number of blank cells.Ī workaround to this problem is to use COUNTIF to count the number of cells with a numerical value, then to use a second COUNTIF formula to count the number of cells containing text or empty text strings. Type =COUNTIF(range,""), replacing range with your chosen cell range. To use COUNTIF, open your Google Sheets spreadsheet and click on a blank cell.
#GOOGLE DOCS BLANK SHEET HOW TO#
RELATED: How to Use the COUNTIF Formula in Microsoft Excel Because you want to count empty cells, you can use a blank text string as your criteria. While COUNTBLANK returns the number of blank cells, you can also use COUNTIF or COUNTIFS to achieve the same result.ĬOUNTIF counts the number of cells that meet the criteria you define within the formula itself. This range contains four blank cells (B4, C4, D4, and E4), which is the same figure COUNTBLANK reports in cell A1. In the example above, cells from A3 to H24 are used within the range. For instance, if you wanted to count the number of blank cells between columns A and C, you’d type =COUNTBLANK(A:C).