Copy and Paste Visible Cells
Copy & Paste Visible Cells When Filtering You can copy and paste visible cells by highlighting the cells and then going F5 --> Special --> Visible cells Only Then click copy and paste the cells in rows that are not filtered