Forum Discussion
Copy visible cells only in 365?
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...
we need to ask excel to ignore the hidden cells explicitly.
the following steps to copy the visible cells are given below:
1.select data as usual. But do not copy it yet.
2.Type F5 or Ctrl+G which opens the go to special dialog.
3.Click special button. This provides options to select specific cells depending upon the criterion you choose.
4.Choose visible cells only & click OK.
5.Copy the data now. Notice that only visible areas are copied.
6.Now when you paste, it will work as expected.
Hi,
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