Question

Alternative option for fill handle​

Answer 1

Answer:

New sheet, put 1 in A1, right click on the fill handle, and drag to whatever let go a box pops up.. select fill series and bingo. use this all the time and there are other options, that will work in many situations fill handle fails... try it and try te others options.

Answer 2

New sheet, put 1 in A1, right click on the fill handle, and drag to whatever let go a box pops up.. select fill series and bingo. use this all the time and there are other options, that will work in many situations fill handle fails... try it and try te others options.

Have a nice day ahead.

Good Morning.