|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 20th, 2009, 06:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting into merged cells
I have a merged cell in which I want to paste text from another cell. Every
time I try get an error message saying that the cellsI have to unmerge the merged cells first, paste, and them remerge. Is there any way to avoid doing this? It is a real pain. 
|
|
#2
November 20th, 2009, 06:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting into merged cells
If you copy only the text from the formula bar of the first cell you can
paste it into the formula bar of the second cell without going throught the unmerge dance. Alternately you could just put a formula in the merged cell referencing the cell you want to copy from. You can than Copy-PasteSpecial-Values in the merged cell. -- If this helps, please remember to click yes. "ann" wrote: I have a merged cell in which I want to paste text from another cell. Every time I try get an error message saying that the cellsI have to unmerge the merged cells first, paste, and them remerge. Is there any way to avoid doing this? It is a real pain.
|
|
#3
November 20th, 2009, 06:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting into merged cells
Yes, merged cells are indeed a pain. Avoid them like the plague. Read the
archives of this group for countless reasons why. -- David Biddulph "ann" wrote in message ... I have a merged cell in which I want to paste text from another cell. Every time I try get an error message saying that the cellsI have to unmerge the merged cells first, paste, and them remerge. Is there any way to avoid doing this? It is a real pain.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
