2019 Calendars from Excel


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

If you’re looking for 2019 calendar options, open up Microsoft Excel.  Excel has a wide range of calendar templates to choose from.

Go to File | New and type ‘calendar’ into the search box.  There’s a proverbial embarrassment of riches.

2019 calendars from excel microsoft excel 25221 - 2019 Calendars from Excel

Pick a year

All the Excel templates apply to any year.  Enter the year you want and Excel will figure out the calendar accordingly.  Most templates default to the current year using =Year(Today()).  Change that by altering the formula to a specific year eg =2019 .  Other templates have a ‘spinner’ to select the year.

2019 calendars from excel microsoft excel 25222 - 2019 Calendars from Excel

Pick a theme

The quick way to change the look is Page Layout | Themes.  Choose a Theme, Color or Font from the lists.

2019 calendars from excel microsoft excel 25223 - 2019 Calendars from Excel

If at first you don’t succeed …

Or that’s the theory.  The very first calendar we tried didn’t work!

We don’t look for bugs in Office, they find us!

‘Calendar Creator (any year’) sounds great … a one-page year calendar.

2019 calendars from excel microsoft excel 25226 - 2019 Calendars from Excel

But opening it doesn’t get very far.  The calculated year (2018) or 2019 gets January right but not beyond that.

2019 calendars from excel microsoft excel 25225 - 2019 Calendars from Excel

Try the Microsoft supplied calendars but double-check they are right.  Do a few checks that:

  • the 1st of the month falls on the correct day of the week.
  • February has the correct number of days. 28 days in 2019 & 2021, 29 days in 2020.

2019 Annual/Yearly

There are  annual or yearly templates available.

2019 calendars from excel microsoft excel 25227 - 2019 Calendars from Excel

2019 calendars from excel microsoft excel 25228 - 2019 Calendars from Excel

  • Calendar creator (any year). Give it a try, you might have more luck than we did.
  • Any year expense calendar. Month to a page. Despite the name, can be used for any purpose.
  • Calendar (any year, horizontal). Four months to a page.
  • Business calendar (any year, Sunday to Saturday). Six months to a page with space on right for notes.
  • Playful calendar for any year
  • Any year calendar with holidays
  • Family calendar (any year, Sunday to Saturday)
  • Seasonal family calendar (any year Monday to Sunday). Month to a page with space for an image.

Any of these calendars can be revamped to suit your need.  Just because it’s called ‘Seasonal’. ‘Family’ or even ‘Playful’ doesn’t mean you can’t switch some images and colors to suit a corporate or non-family purpose.

Seasonal? Family? Calendar.

It’s called a Seasonal Family Calendar but can be easily adapted to any purpose. If you want a month to a page calendar with a different image on each page, this is the choice for you.

2019 calendars from excel microsoft excel 25229 - 2019 Calendars from Excel

There’s a selector at top right to change the year.

2019 calendars from excel microsoft excel 25230 - 2019 Calendars from Excel

Change images by clicking in that area then press Shift+F10 followed by a right-click to reach ‘Change Picture’.  The image and notes box are inside a text box.

subs profile e1563205311409 - 2019 Calendars from Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address