Forum Discussion
Sikandar_Hayat
Aug 21, 2019Copper Contributor
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...
Deleted
Aug 21, 2019we 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.
Sikandar_Hayat
Aug 24, 2019Copper Contributor
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