[Excel] Copy visible cell only

1. Select cells/range
2. Click Home > Find & Select > and pick Go To Special
3. Click Visible cells only > OK
4. Then, copy & paste cells/range as normal

Source:
https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e