Now you want to copy and paste just the visible data but discovered to your horror when you pasted to another location, it included the hidden rows!īy default, Excel copies hidden or filtered cells in addition to visible cells.
You have used one of several methods to hide some rows for filtered data, or created a table which auto applies filter icons for each column. Copy and Paste Visible Cells Only (filtered data)