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

Try highlighting the area and using Ctrl ; (the keyboard shortcut to select
visible cells only). Copy and paste as normal and you should just get the
visible cells.
--
Thanks,
MarkN


"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.