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.

Possible Duplicate:
How to extend series of dates in Google Docs?

Is there a way to create a column of date easily with google speadsheets like with Excel ?

In Excel, enter a date, hold right click button + shift and move the mouse to create dates

Thanks,

share|improve this question
add comment

marked as duplicate by Al E., Alex, phwd Sep 11 '12 at 3:59

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

up vote 10 down vote accepted

In both Excel and Google Spreadsheet...

  1. Enter a date in a cell
  2. With LEFT mouse button, click (and hold) square handle in bottom right corner of cell.
  3. Drag the selection to cover all cells you wish to be dates.
  4. Release mouse button.

However, Google Spreadsheet will fill the selection with the same date, unlike Excel that fills a sequence of consecutive dates.

To make a sequence of dates in Google Spreadsheet, complete the first two cells manually and select these two cells to drag over the required range of cells. Google Spreadsheet then continues the sequence.


In Excel, enter a date, hold right click button + shift and move the mouse to create dates

This does not work for me in Excel?

share|improve this answer
    
When I do this in spreadsheet, I have the same date in all cell –  Kris-I Sep 4 '12 at 9:57
1  
Ah, you wish to create a sequence of dates... 2012-09-04, 2012-09-05, etc... Then you need to manually create the first two entries and select these two entries before dragging the selection. –  w3d Sep 4 '12 at 10:12
    
This only works if the locale (File->Settings) of the document is correct AND all your dates are in the correct format. Google assumes American date formats, rather than the format used by the rest of the planet. –  Rob Lang Jan 30 at 10:56
add comment

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