How to create a calendar in cell

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 control 1
download a template excel Calendar into a work sheet? 1
calendar 2
Formula and Text in One Cell 4
Pop Up Calendar - Excel 2002 1

Back
Top