How to delete hidden rows

F

Fox JW

Hi, I am new to this group and I'm not sure whether this is the right
group for my question. I hope someone can help me solve this problem.
I have a worksheet with 12,000 rows of data and there are about 5,000
hidden rows. I need to save the balance 8,000 rows into another
worksheet. Is there a way to delete all the hidden rows at one go
before I save it into the new worksheets?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top