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, follow the steps in this article to copy visible cells only."
Link with the mistake: https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
Nevertheless, I've just tested it right now and that's not true regarding filtered cells (attention, filtered, not manually hidden through the "Hide" button). If you do a simple Copy and Paste (CTRL+C and CTRL+V) of an AutoFiltered list, only the visible cells are pasted. No filtered cells are pasted.
I haven't changed any of my Excel settings. I've shared this information with other people and all of them are reproducing the same behaviour. The diagnosis seems to be confirmed.
I would appreciate the rectification in the official Office support (Microsoft Support). It is all about deleting the words "or filtered" in the second row of the publication.
Link with the mistake: https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
Kind regards.
2 Replies
- This is true. However for cutting and pasting, Excel DOES cut hidden rows, unless you set selection to visible cells only. Very confusing.
- 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
