View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how do i paste after filtering in excel?

That's never worked for me to paste over just the visible cells.

I don't think it works in any version of excel.

Pierre wrote:
<<snipped

After filtering, selectyour desired range with the mouse, edit, go to,
special, visible cells only, copy. Select your destination. paste.

You can also drag your "select visible cells" icon from the customize
menu, and place it on a toolbar.

Pierre


--

Dave Peterson