I'm attempting to use Autofill in Excel 2002 to extend a range of consecutive dates. I have used Autofill many times before in other versions of Excel but have recently upgraded to Office XP.
The problem is that when I select say, the last five dates in the range I want to extend, then drag the fill handle down the column, all Excel wants to do is repeat the list, not extend it. If I right-click the fill handle and drag down the column, the menu that pops up only has "Copy Cells" as an option, all of the Autofill selections are greyed out.
Thanks in advance for any help you can offer.