Selecting visible cell only

To select visible cells only first select the range and then press

Alt + ;

You can then copy and paste only paste the visible cells.

Any visible formulas are converted to values.