Enter your first date in the initial cell in the column. Drag the right edge of the column header to the right to widen the column if you chose a date format that includes the day of the week. Place your cursor over the lower right corner of the cell that contains your initial date entry.
When your cursor changes to a black plus sign, drag downward on this fill handle till you reach the bottom of the area you plan to fill with data. Click on the unlabeled Auto Fill button that appears below and to the right of the last cell over which you dragged the fill handle.
Select the cell which you want to insert the comment.2.
File→Options→Advanced→Data→“Disable automatic grouping of Data/Time columns in Pivot Tables”.
This means that the next time you create a new Date table in the same workbook, the table will include any customisations.
However these changes don’t seem to be applied in Date tables created in new workbooks – maybe this will also change before RTM?
You can select options after you've applied Auto Fill to populate cells with date information. Click on the column header to select the location for your date information.
In the Home tab on the Excel ribbon, click on the arrow at the bottom right corner of the Number section.