It can be done.

Copy A1 and select A2:A123 and Paste

What is the B.S. message Excel hands you?

Whenever one gets an error message, it is helpful for us to know what it is.
Otherwise we are just guessing at your problem.


Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 15:17:02 -0700, Harvey Eastman <Harvey
wrote:

There has to be a way to copy the value of a cell (no formatting) into
several cells at once. The error Excel gives when I try to do this is B.S.
So how do you do it??? I am using Excel 2000.