I suggest you use the keyboard. Click on the cell you want to copy and hit
Ctrl-C. Then click on the first cell you want to copy to, hold down the
shift key, and hit page down or the down arrow until you've selected down to
row 2000. Then hit Ctrl-V to paste. Or instead of paging down while holding
the shift key, mark the last cell in the range somehow ("x") and use
shift-end-down to select the range to copy to.
Will

"Dennis1188" wrote:

I would like to copy a cell formula by left clicking the bottom right corner
, hold and drag down 2000 rows.

Excel quickly counts past 2000 rows and I go up and down till I get it right.
Is there a way to left click, hold and maybe enter the row number??