Copy same cell formula in many rows...
 

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??

Copy same cell formula in many rows...
 

To get to row 2000, type A2000 in the name box (just above the column
headings, & to the left of the formula bar).
--
David Biddulph

"roadkill" wrote in message
...
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??