H Hamad Apr 3, 2009 #1 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?
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?
S Sheeloo Apr 3, 2009 #2 Before pasting press F5, click on Special and choose the option 'Visible cells only'