How to create a calendar in cell

G

Guest

I want to be able to insert a calendar into a cell so that the date can be
entered from a drop down box
 
S

scottymelloty

type in a list of dates you want in a column anywhere on the sheet

click in the cell you want the drop down box

click on DATA then Validation

Click on allow and select list Click in Source Box and highlight th
list of dates you typed in and press enter, it should now all b
available in a drop down bo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a drop box in Excel to show a calendar? 1
How do I insert a calendar box, in excel? 2
Drop Down Calendar in Excel with a Default Value 1
calendar 2
Calendar control 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Calendar in Excel 4
Formula and Text in One Cell 4

Top