Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 2 down vote favorite

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

marked as duplicate by Al Everett, 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 4 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
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

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