Forum Discussion

Sikandar_Hayat's avatar
Sikandar_Hayat
Copper Contributor
Aug 21, 2019

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...
Excel 365
Jherner's avatar
Jherner
Copper Contributor
Jan 08, 2020

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?

chahine's avatar
chahine
Iron Contributor
Mar 22, 2021
if you are pasting to a filtered data, it will omit

better to use fill in this case

Resources