In both Excel and Google Spreadsheet...
- Enter a date in a cell
- With LEFT mouse button, click (and hold) square handle in bottom right corner of cell.
- Drag the selection to cover all cells you wish to be dates.
- 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?