Forum Discussion
Solved
We can't do that to a merged cell.
Hi, I am trying to copy a file that filtered in column J and merged some cells. The windows has shown a error "We can't do that to a merged cell" This message appears when one the following ...
littlevillage What exactly do you want to do? Apparently, you can not copy a column that is filtered and intersects with merged cells. Don't know why, but you just can't do it. Select a range that does NOT intersect with merged cells or un-merge the cells and use 'center across selection' if you really want the visual effect of merging cells.
littlevillage What exactly do you want to do? Apparently, you can not copy a column that is filtered and intersects with merged cells. Don't know why, but you just can't do it. Select a range that does NOT intersect with merged cells or un-merge the cells and use 'center across selection' if you really want the visual effect of merging cells.
yes, I have understood. Thanks for your assistance