If you’re okay with a daily block to write in rather than an hourly one, a yearly calendar is more than enough for you to stay on task all year.

  1. Open a blank Excel sheet and create the header row by starting at January in the first cell. Then work your way across the header row, keeping the first column blank, typing in January through December. Bold the whole row when you’re done.

  2. Type out the days of the month (up to 31) in the left column, leaving the first row blank. Bold the whole column when you’re done.

  3. Highlight all rows that include the days of the month. Once all are highlighted, resize one row to a size that will allow you to write in your monthly agenda.

  4. Highlight all columns that include the months of the year. Once all are highlighted, resize one column to a size that will allow you to write in your monthly agenda.

  5. To print your new yearly agenda, highlight all cells of the agenda. Click File > Print. Change orientation to Landscape. Select Page Setup, select the Sheet tab, and enable Gridlines under the Print section. Change Scaling to Fit All Columns on One Page. This will fit the yearly agend to one page.

  6. Your yearly calendar will print one page wide and multiple pages long. You can paste these sheets onto your desk or wall and use it to keep track of your daily tasks.

Creating Your Own Calendar in Excel

The type of calendar you create really depends on how you plan and organize your days. For many people, a single block for each day is more than enough to track your events and tasks. For other people, an hourly schedule provides a better breakdown for a daily schedule.