The article says By default, Excel copies hidden or filtered cells in addition to visible cells. but when I copy filtered or hidden not included by default. Is there any setting for this in Excel 365?
"If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. 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. For example, you can choose to copy only the summary data from an outlined worksheet."
My question was since Filtered is taking care of only copy pasting visible cells only then why to follow these steps? But this article saying different. Give a try on filtered and you will see only visible data copied. thanks
Hey MICROSOFT! Why the reverse-logic? Why wouldn't you have made the default behavior to operate on only visible cells? Then if for some bizarre reason I wanted to also work with hidden cells, then I could go to that Special place and SELECT HIDDEN CELLS.?? This counter-intuitive behavior always trips me up. I tell my students that for copies/cuts to just sort instead of filter to bypass this dangerous behavior.