If you use a different date format, go to File > Spreadsheet settings and change the locale to your own. Checking that you have the cell for the correct day of the week, type the date in the format /. Adding Dates to a Custom Google Sheets Calendar You can continue dragging as far as you want if you want to create an entire month or even year of dates. In this example, we’ll have our days of the week arranged vertically. Select the cell you’ve just typed in, then press and hold down the small square in the bottom right-hand corner of the cell.ĭrag the cursor horizontally or vertically to fill additional cells with days of the week. You’ll need to insert the days of the week to begin-choose the starting cell for your calendar, and type a day you want to start with. To start, open a blank Google Sheets document. Adding Days to a Custom Google Sheets Calendar If this is the case, you’ll need to create your calendar from scratch. Select Google Sheets and hover over the > symbol.įrom the pop-up menu, select From a template.Ĭhoose one of the calendar templates-a new sheet will be created containing your chosen calendar design.Īny document you create from a template can be edited to suit your needs, but you might be looking to create a calendar with a design that differs from the available templates. Once you’re signed in, click the New button on the left to create a new document.
To do this, head to the Google Drive website-you’ll need to sign in if you haven’t already.
The simplest way to create a quick and easy calendar in Google Sheets is to use one of the ready-made templates available to users. If you want to make a calendar in Google Sheets, here’s what you’ll need to do. You can use it online or print it off to use as a pen-and-paper desktop calendar. Creating your own calendar gives you far more control over exactly how your calendar looks and functions. If you want to create your own calendar, you can do this using Google Sheets.
0 kommentar(er)
