Since Monday morning, Ive begun having a problem with the fill series function.

No matter what I do - holding down shift or control keys while dragging, just dragging using fill handle - I cant get the numbers in a column to advance.

If I want to advance the numbers, I have to type in each number by hand, which can get time-consuming.

Also, while last week dragging with the fill handle resulted in an Autofill box, this week all I get is the Quick Analysis tool box.

Ive tried restarting the program, turning off QA, and turning the Enable Fill Handle off and back on.

Hold down Ctrl and when the bottom right of the cell turns to a black cross drag it down.

My ding-bat mistake was that I had forgotten that I had filtered the worksheet on another column.

If sheet you are experiencing the issue on currently has a filter applied, you wont be able to use the Fill Series feature.

I dont have enough reputation on this site to post a link to the site I credit for the answer, but you can Google: repairmsexcel resolve-excel-fill-handle-not-working-issue.

So in order to enable or re-enable autofill series or numbers by clicking on the bottom corner right of the cell and dragging it downacross, remove whatever filter there is at the top of its table.

I ended up finding this thread, and forum, via a google search.

If your question is resolved, mark it SOLVED using the thread tools 3.

Click on the star if you think someone helped you Regards Ford.

Excel For Mac 2008 Fill Handle