In Excel, when you copy visible cells, hidden rows are included by default — annoying, I know.
The fix: Select your range, then press Alt+; (Windows) or Cmd+Shift+Z (Mac). This selects only visible cells. Then copy (Ctrl+C) and paste normally.
Alternatively: Home tab → Find & Select → Go To Special → Visible cells only. Then copy.
This works for filtered data too — only the rows you actually see will be copied.