On a merged cell part-excluded by autofilter (e.g.B2-6 attached), Ctrl+C fails. Any suggestions for a workaround? I do need the visible rows and no others on the clipboard - to paste outside Excel.

Or any other way to export the visible rows? The only command I have found that works is Print - and I do not fancy attempting reconstruction of the cells from that output.

By the way, as well as failing, it gives this bogus warning:



"Change", note - despite no change.

Attached Files

Ctrl+C fails with bogus Cannot change part of a merged cell warning.xls (15.5 KB, 2 views)

Using Merged Cells Effectively in Excel - Excel Solutions

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks.

Libre Office Calc.

First import to Google Sheets. Result verified by paste to Excel and Word.

I would prefer a solution not relying on internet. Unfortunately import to Libre Office Calc fails, since the result fails to exclude the hidden rows.