Copy A1.

In the names box (left of the formula bar), type A5000
Hold the Shift key down and hit Enter
Paste

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Suppose I put a formula into A1, and I want to "copy down" through
A5000. What is the easiest way to do that?

(By the way, A5000 is just an example. I might want A10000 or more.)

I know that I could drag the cell down through A5000. But that is
tedious and error-prone. It is easy to overshoot A5000.

I know that I could copy A1, click on A2, scroll down to A5000 and
shift-click the cell to highlight the range A2:A5000, then paste. But
that, too, is tedious.

I would be content to copy A1, click on A2, then "go to" (ctl-G) A5000
and shift-click the cell in order to highlight the range A2:A5000, then
paste. But that does not seem to work. (I am using Office Excel 2003.)