View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MU
 
Posts: n/a
Default Excel: copy and paste only shown not hidden cells into new sheet

I have a worksheet in which I hide information when I don't want to use it,
and make custom views. Now, I would like to take this a step further. How
can I copy this custom view and paste it into a new worksheet without all of
the hidden rows and columns coming with it?