Once selected, you may copy-paste these cells wherever ... ‘Visible cells only’ option like Excel. Additionally, in Google Sheets, grouped rows/columns behave opposite to filtered rows/columns ...