Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy the value of a cell, no format, into several cells.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy the value of a cell, no format, into several cells.
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy the value of a cell, no format, into several cells.
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy the value of a cell, no format, into several cells.
Errrr Gord,
I don't think B.S. is an excel term, more like Harvey's opinion on the matter. ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format painter wont copy mixed font colors from one cell to next | Excel Discussion (Misc queries) | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
how do i copy the format of a cell from one worksheet to another | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) |