Drop-down almanac

[Jose]

Ho do I add an almanac to cells to make it easier to pick a date?

 

[Jim Thomlinson]

On the control toolbar there is a Hammer and Wrench icon. Click on taht and
you will get a listing of controls. Find the Date & Time Picker control and
add it to your spreadsheet. If you right click the control you can add a
linked cell where the date will be placed. You need to ensure the spreadsheet
is not in Design mode to use the control. Click on the Traingle and Ruler
icon to toggle in and out of design mode...

 

[Bob I]

You mean Calendar?

 

[Gord Dibben]

See Ron de Bruin's site for creating a pop-up Calendar.

http://www.rondebruin.nl/calendar.htm


Gord Dibben MS Excel MVP

 

[Jose]

Yes, I meant calendar.
Thanks I'll try the suggestions.