I recently learned this nice shortcut from another SU user.

Select all cells as you usually do and then press

2. Alt+Shift+, » Select only visible cells within your selection
3. Ctrl+C » Copy
4. Ctrl+V » Paste

I recently learned this nice shortcut from another SU user.

Select all cells as you usually do and then press

1. Alt+; » Select only visible cells within your (or Alt+Shift+, depending on keyboard layout)
2. Ctrl+C » Copy
3. Ctrl+V » Paste