Forum Discussion
osmanmkc
Sep 12, 2021Copper Contributor
Delete multiple lines
Hi there! I use excel for the auctions I organize on the internet. Each line contains the features of a product. When an auction ends, I manually delete the sold products one by one and repost th...
osmanmkc
Sep 12, 2021Copper Contributor
No, that's not what I was asking. This is my job. What I'm asking is how can I speed up the selection process. I have an excel file with 3000 lines and I want to delete 500 lines with specific line numbers from it, how can I speed up this process instead of selecting them one by one?
HansVogelaar
Sep 12, 2021MVP
If you use an empty column in which you enter something, for example an "x" if the row is to be deleted, you can filter the data to display only the rows with an "x", delete the filtered rows in one go, then remove the filter.
Or do you have another way to specify which rows to delete?
- DevendraJainSep 14, 2021Iron ContributorYes if there any criteria on the basis of which you delete rows then we can automate that criteria