Copy the value of a cell, no format, into several cells.

H

Harvey Eastman

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.
 
G

Gary''s Student

Select A1 for example and pull down:

Edit > Copy

Select A2 and A3 and pull down:

Edit > PasteSpecial > and check value.
 
G

Gord Dibben

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
 
M

MartinW

Errrr Gord,

I don't think B.S. is an excel term, more like Harvey's opinion
on the matter. ;-)
 
Top