To paste copied data in filtered/visible cells only
Before pasting press F5, click on Special and choose the option 'Visible
cells only'
"Hamad" wrote:
Is there a way to paste copied data only in the visible/filtered cells in a
worksheet and not also in the hidden cells. as MS Excel 2007 usually does it?
|