how copy formula and only paste into 20,000 cells

D

dlb1228

i have a formula and want to copy it into only 20,000 cells instead of the
entire 65,000 is there a way to select a range
 
G

Gord Dibben

With formula in A1 type A1:A20000 in name box then hit ENTER.

Then hit CTRL + d


Gord Dibben MS Excel MVP
 
Top