Forum Discussion
Copy visible cells only in 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.
When I try to paste the cells after copying them in this way only part of the data will paste. Any idea why I'm unable to copy and paste visible cells without excel omitting part of my data?
- if you are pasting to a filtered data, it will omit
better to use fill in this case
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
