How to Build Your Own Excel Daily Calendar

By Darrin Koltow

One benefit of building your own Excel daily calendar is having a resource that integrates functionally and visually with your business, which isn't possible with generic calendars. Another advantage is that you'll spend less time learning how to use a calendar that you've created yourself. Building a daily calendar in Excel involves creating column headings that list the time, venue and other components of your daily events and tasks. You'll also need to enter time designations, which can be done using Excel’s Auto Fill feature. Make the calendar’s data easy to read and visually appealing with Excel’s formatting commands.

Open a new workbook and type your calendar‘s title in cell A1 of the current spreadsheet. For example, type “Daily Calendar for <Your Name>”. Press “Tab” repeatedly to move to an empty cell and then type “Date:”.

Select the Title and Date cells, then choose a font size between 14 and 18 from the Font Size control on the Home tab. Click “Arial” or another sans-serif font from the Font control.

Click on cell A2 and then begin typing the calendar’s column headings, pressing “Tab” after each heading. Headings you might wish to use include “Time,” “Event” or “Task,” “Resources,” “Location” or “Venue,” “Priority” and “Notes” among others.

Click the cell under your “Time” column heading and enter “12:00 AM.” Press the "Down Arrow" key and type “12:30 AM.” Select these two cells, and then move your mouse over the lower right corner of the selection. Drag down when the cursor changes to a “+” and Excel will fill the cells you drag over with time values. Release the mouse button when the pop-up text near your mouse cursor displays “11:30 PM.”

Select all column headings and time values, then click the “Format as Tables” button on the Home tab. Excel displays a gallery of table styles.

Click a style you like. Excel displays the prompt "Format as Table." Tick the check box for "My table has headers" and click "OK" to apply the selected format to your calendar.

Press “Ctrl-S” to open the “Save As” dialog. Click the “XLTX” extension from the Save as Type control. Enter “MyDailyCalendar” or a similar filename in the “File name” text box and click “Save” to save your calendar as a template. Close the workbook to complete the template for your calendar.

Click "New" on the File menu and select “My templates” from the Templates pane. Excel displays a list of templates, including your daily calendar template. Double-click the icon for your calendar template to create a new workbook that shows your calendar.

Type today’s date in the cell to the right of the “Date:” cell. Enter task or event data for one or more tasks in the cells under the calendar’s column headings.


Information in this article applies to Excel 2010. It may vary slightly or significantly with other versions or products.