Forum Discussion
Copy and paste on shown cells excluding filtered cells
Hello Everyone,
I have big data set. I am trying to copy filtered (visible) cells, not the entire data set and paste it in a separate column of only visible cells. When pasted, it pastes on filtered/hidden cells as well so the structure of the data is lost.
I am on office 2019. I have a PC
1 Reply
- While pasting Excel ignores filter and pastes in all the rows.
Can't do anything about it.
You need to find a way around it.
Can you please share the file?
I will try once.
