Hi, I have recently upgraded from excel 2003 to excel 2010. When I use the autofill feature it simply does not work. In the file, options, advanced, edit setting the autofill options are checked, however when you drag the fill handle it only copies the original number and does not allow you to right click and fill with series etc, all the options are greyed out!!!
If you double click the fill handle in 2003/2007 you would fill the series, now it just does in cell editing.
can anyone please shed some light on what could possibly be wrong.
Bookmarks