Delete rows in filter view

G

Guest

Have a spreadsheet that contains empty cells. Want to delete all empty cells
at one time (if possible). Have filtered column to show only empty cells.
If I delete the filtered cells, all cells are deleted.

Is there anyway to quickly delete empty rows in a worksheet? My w/s is
rather large. Thanks.

Dakota
 
G

Guest

Rather than filtering, sort the data based on that column so that all the
rows to delete are grouped together - and then delete
 

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

Similar Threads

Select rows which satisfy 2 criteria 16
Deleting rows 1
Hpw do I delete multiple empty rows found between filled rows? 1
Copy/paste data across filtered rows 1
delete rows with empty cells throughout the data 4
Delete Rows using Wildcard 2
hidden rows problem 7
Delete Rows using If and Wildcard 2

Top