How do I copy information and skip hidden cells?

U

unfrgvn82

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

Dave Peterson

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

MarkN

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