View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default 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?