Excel's Magic Calendar

[djl0525]

For over a decade I've missed two things in Excel. (Okay, I've really missed more than two, but this post is about the two that are on my mind at this moment.) One, a ruler like in Word and PowerPoint. And two, a Make Calendar button that lets you select a list of events, dates in the one column, text in the other column, and when you click the magic button it displays the list in a calendar layout. I see they added the ruler in 2007. Yipee! I'm still looking the magic Make Calendar button??? (I'm not looking for a blank calendar... I've seen the templates.) I want to turn my list into a calendar.

What are your favorite ways to calendarize Excel data?

--DJ

 

[i0mega]

I missed them two, I didnt know a ruler existed, where is it?

 

[djl0525]

It's on the View tab.

DJ

 

[SandiMays]

You can use a pop-up calendar addin:

http://www.youneedabudget.com/2006/excel-pop-up-calendar-add-in/

or the 2009 Excel Calendar template:

http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html

 

[Domski]

Re the Calendar, my suggestion would be to use Outlook.

Dom

 

[djl0525]

What does Outlook have to do with an Excel calendar?

DJ

 

[Domski]

What does Outlook have to do with an Excel calendar?

DJ

Outlook has built in calendar functionality and, while I've not done it myself, I know it's possible to import an Excel list into an Outlook calendar.

Dom

 

[i0mega]

It's on the View tab.

DJ

Found it, useful, thank you

 

[djl0525]

You can use a pop-up calendar addin:

http://www.youneedabudget.com/2006/excel-pop-up-calendar-add-in/

or the 2009 Excel Calendar template:

http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html

The pop-up calendar is nothing more than date picker. And the template is a blank calendar. They're useful, neither of them displays a list to a calendar layout.

Thanks -- DJ

 

[Tom3]

I am looking for the exact same thing - any luck? I imported data from an Excel file into an Outlook Calendar and it worked, but there's not a lot of functionality associated with it. Need a solution bad!!!