View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I copy information and skip hidden cells?

Select the range
edit|goto|special|visible cells only
edit|copy
off to the other sheet
edit|paste

If you have formulas that you want to keep, I think you'll have to copy|paste
each visible area separately.

unfrgvn82 wrote:

Just looking for some help to copy visible information from one page to
another without including hidden information. Example: Copy rows 1-10
excluding 7,8 which are hidden.


--

Dave Peterson