You can quickly reduce your selected range to only the visible cells with a shortcut, the go to menu, or the quick acess toolbar. Selecting only visible cells allows you to exclude hidden or filtered data from your selection, making your data management tasks more efficient For more information, go to select cells, ranges, rows, or columns on a worksheet
How To Select Only Visible Cells In Excel — TojiKon.Net
To cancel a selection of cells, click any cell in the worksheet
Select home > find & select, and pick go to special
Select visible cells only > ok Select copy (or press ctrl+c)
