Forum Discussion
We can't do that to a merged cell.
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 The simple answer is "Do NOT use merged cells!".
Undo merge cells on the first two rows and you can probably do whatever you want with column J. If you need to have the headers centred above columns, use the alignment Centre Across Selection setting. It will produce the same visual effect as merging cells without the nasty side effects.
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
