On Jun 15, 9:16 am, Len wrote:
Auto-numbering fails

After data filtering, it seems that auto-numbering in column A is not
working when I select range A2 to A13 and double click the Fill Handle
at cell A13 , e.g..

Column A B
Row
2 1 AA
10 2 BB
13 3 CC
39 SS
116 SS
119 WW
225 OO
230 DD
305 CC

In this case, how to solve the above scenario with Excel function and
give the result with auto-numbering as follows : -

Column A B
Row
2 1 AA
10 2 BB
13 3 CC
39 4 SS
116 5 SS
119 6 WW
225 7 OO
230 8 DD
305 9 CC

Please help, thanks

Regards
Len

I'm a little confused by your data above, if you actually mean those
numbers as different rows or as data. If those are row numbers spread
from 2 to 305, a simple Fill may be impossible. But if you are really
just trying a simple Fill from cells A2 to A13, then....

Instead of the double-click method which requires Excel to guess what
you want, highlight just the first two entries (1 and 2 in your
example), and click-drag the fill handle down to where you want. This
should work better, as long as the numbering desired is simple like
1...2...3...4. Using the Fill Series... command in the Edit should
also work more consistently, although it's slower to use.