| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy single cell into cell that is merged from two cells?
I have a single cell in one worksheet that I want to copy into another
worksheet where the cell is a merged cell of two cells. When I do this it copies the one cell into both cells of the merged cells. I end up with two of the same thing. I can not unmerge the cells that I am copying in to. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy single cell into cell that is merged from two cells?
Can you select the merged area first and then paste into the formula bar?
Rod wrote: I have a single cell in one worksheet that I want to copy into another worksheet where the cell is a merged cell of two cells. When I do this it copies the one cell into both cells of the merged cells. I end up with two of the same thing. I can not unmerge the cells that I am copying in to. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy single cell into cell that is merged from two cell
Dave,
I am not sure what you mean. Can you explain it more? Point of clarification. I have a range of single cells that I need to paste into a range of merged cells ( two cells merged together to make one). "Dave Peterson" wrote: Can you select the merged area first and then paste into the formula bar? Rod wrote: I have a single cell in one worksheet that I want to copy into another worksheet where the cell is a merged cell of two cells. When I do this it copies the one cell into both cells of the merged cells. I end up with two of the same thing. I can not unmerge the cells that I am copying in to. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy single cell into cell that is merged from two cell
One cell at a time.
Select the cell to copy from. highlight the value/formula in the formula bar rightclick|copy hit escape select the cell to copy to. click inside the formula bar rightclick|paste hit enter. Rod wrote: Dave, I am not sure what you mean. Can you explain it more? Point of clarification. I have a range of single cells that I need to paste into a range of merged cells ( two cells merged together to make one). "Dave Peterson" wrote: Can you select the merged area first and then paste into the formula bar? Rod wrote: I have a single cell in one worksheet that I want to copy into another worksheet where the cell is a merged cell of two cells. When I do this it copies the one cell into both cells of the merged cells. I end up with two of the same thing. I can not unmerge the cells that I am copying in to. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy information from one cell to several different cells | Excel Discussion (Misc queries) | |||
| Truncating a columns worth of cells not just a single cell. | Excel Worksheet Functions | |||
| city, state, zip from a single cell to multiple cells | Excel Discussion (Misc queries) | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
Linear Mode
