is there a way to drag a formula without using the mouse? dragging over say 1000+ cells can be tedious. can it be made to 'drag' for a given number of cells, or to just go on indefinitely?


thanks in advance