You mean you want all 4000 cells to have the number 1 in them? If so, enter
the 1 in your first cell, press Ctrl+C (or click Edit/Copy on the menu bar),
click into the Name Box (the blank box to the left of the Formula Bar) and
type in the range you want to copy the value to (say, A2:A4001) and press
the Enter key (this will select the range you typed in) and then press
Ctrl+V (or click Edit/Paste from the menu bar). Finally, press the Escape
key to remove the copy selection indicator and click into any single cell to
remove the cell selection.

--
Rick (MVP - Excel)


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