Select A1 for example and pull down:

Edit Copy

Select A2 and A3 and pull down:

Edit PasteSpecial and check value.
--
Gary's Student


"Harvey Eastman" 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.