Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying merged cells
Does anyone know how to stop a group of merged cells from unmerging when you
copy the range? For example, say you have a column of individually merged cells and within that column you have a group of three cells that you want to copy down only one cell. Every time I do this two of the three cells unmerge. Is there a setting to stop this? Much thanks for your time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying merged cells
I may be misunderstanding what you are doing, but 2003 cells on my computer
stay merged when I copy and paste. More infor please with an example "Marc" wrote: Does anyone know how to stop a group of merged cells from unmerging when you copy the range? For example, say you have a column of individually merged cells and within that column you have a group of three cells that you want to copy down only one cell. Every time I do this two of the three cells unmerge. Is there a setting to stop this? Much thanks for your time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying merged cells
Try this:
- merge cells A1 & B1 - copy this cell down to make a column around 10 rows long - now, select cells AB3, AB4 & AB5 - copy these three cells down to rows 4, 5 & 6 as a group - on my computer, at this point the new rows 5 & 6 unmerge - very, very frustrating This only happens when you try to copy more than one merged cell at a time "bj" wrote: I may be misunderstanding what you are doing, but 2003 cells on my computer stay merged when I copy and paste. More infor please with an example "Marc" wrote: Does anyone know how to stop a group of merged cells from unmerging when you copy the range? For example, say you have a column of individually merged cells and within that column you have a group of three cells that you want to copy down only one cell. Every time I do this two of the three cells unmerge. Is there a setting to stop this? Much thanks for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells are Merged. How to know where to where??? | New Users to Excel | |||
Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Merged Cells | Excel Discussion (Misc queries) | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |