MS Excel has feature where one can drag a cell and fill the series/formula to other cell. The feature I found to be quite useful. For example you can put a date 01/01/2013 in a cell and drag it to fill the rest of the days as in the year.
However I observed that on installing MS Excel 2007 the option was not present and was disabled by default. Its not clear why such an useful functionality is disabled by default. Anyway if one needs to enable it follow the following step
Select the Customize option from the Quick-Access bar which is normally located above the ribbon alongside the Excel Button on the left hand-top of Excel (Normally you will have shortcut for save-undo-redo in the Quick Access Bar).
Select Customize -> More Commands -> Advanced -> Check “Enable fill handle and cell-drag and drop”
That’s all you need to do to enable this useful feature. Previous option of MS-Excel have this option under Tools -> Option