Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Is it possible to insert a datepicker in every cell of a column in Google Spreadsheet so that anyone can click (with a single click) on that cell and get a datepicker calendar to select a date?

share|improve this question
add comment

3 Answers

Right-click the selection you want to have the date picker show up for (i.e. single cell, entire row, entire column) and then open data validation. Set criteria to A valid date and click Save. Now just double-click the cell!

Edit: I missed the single-click requirement.

share|improve this answer
This worked and should be set as the answer! –  Michael Giovanni Pumo Jan 12 at 18:01
add comment

if I remember correctly you can just set the cells format to date and that will have the same effect

I don't think there is a solution that will meet your exact requirements however you could use some conditional formatting to "cheat" the effect for example

have a default date of 01/01/0001 i.e a date what will never be entered by a user

then conditional format the cells to be font colour the same as the background of the cell.

This way when a user double clicks the cell it will show the date picker but will look like a blank cell until they do so, of course you will have to make sure your other formulas ignore the default date.

share|improve this answer
ya i already did it as you said..but i am not getting the datepicker when i click on cell..instead of that, i have to enter date manually after that if i clik on that cell then datepicker appears. –  user12181 Jul 19 '11 at 4:31
@user12181 see my revision –  Matt Jul 20 '11 at 7:29
add comment

If you pre-populate the cell with a random date, double clicking will bring up the date picker;


Hope this helps

share|improve this answer
i already went through that link...but i am not pre populating the cell with random date. –  user12181 Jul 17 '11 at 18:10
but what if the field is not prepopulated. I need something like that whole column shows the datepicker when a cell is selected. –  coding_idiot Oct 31 '12 at 19:51
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.