How to copy only visible cells in Excel after filtering

Apply the filter, then select the columns and rows you want to copy. Include the header only if you want it in the result. Choose Visible cells only before copying so the selection excludes cells hidden by the filter or by hidden rows and columns.

Click the top-left cell of a blank destination and paste. For example, if your selection has visible records for Ada and Lina with Mateo hidden between them, the copied records should appear on consecutive rows. Check the names or IDs in the result before sharing it.

Visible cells only controls what you copy from the source. A regular paste fills consecutive cells at the destination and can reach hidden rows or columns there. Use a new worksheet for the extract if you need to keep the original filtered table intact.

Excel for the web can copy visible cells from a filtered Excel table. A regular range with hidden or filtered cells can still bring those cells along. If you need to preserve the range as it is, open the workbook in desktop Excel for Windows and use Go To Special there.