Press F5 & click on Special, then choose 'Visible Ceels Only'

For a toolbar icon, right click the toolbar and choose Customize
Click the Commands tab and choose Edit in the left panel.
In the right panel scroll down until you see Visible Cells Only
Drag the icon & drop it ON a toolbar

"gonzolio" wrote:

A coworker once showed me a toolbar function that allowed me to choose and
copy only the visible cells from a worksheet with an autofilter. The function
also allowed me to copy only the visible cells from a worksheet that had a
pivot table in it where the subsequent rows were grouped. How do I find this
function in Excel?