In the name box, that space immediately above the column A header, type in
the range you want to fill then hit Enter. for example, in the name box type
A1:A4000 then hit Enter.

That will select the range with cell A1 being the active cell. Type the
number then, instead of hitting Enter, hold down the CTRL key then hit
Enter.

--
Biff
Microsoft Excel MVP


"Kerri" wrote in message
...
Say I want to copy the number one to 4,000 plus lines, how do I do that
quickly?