Forum Discussion
Wrong official information "Copy visible cells only"
Dear community, The official Office support (Microsoft Support) officially says "By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, foll...
That is true, plus the default behaviour of copy-paste is kind of a poor design choice:
copy only takes into account displayed cells in the source
but paste takes into account both displayed and hidden cells in the destination
And for ages MS doesn't seem to care about a proper workaround enabling paste only onto displayed cells
copy only takes into account displayed cells in the source
but paste takes into account both displayed and hidden cells in the destination
And for ages MS doesn't seem to care about a proper workaround enabling paste only onto displayed cells