Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

Excel 2010 - Selecting and copying cells from areas with hidden rows is not working

I would like to select and copy  cells in an area where there are hidden rows. However, every time I try to copy I wind up selecting/copying my selected cells AND hidden cells too!
I just want to copy cells that are visible.
How can I do this?
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the cells are hidden by using a filter, ie the hidden cells do not match the filter criteria, copying will only copy the visible cells anyway.
Avatar of brothertruffle880

ASKER

The cells are not filtered, just a number of rows are hidden.