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