I have an excel spreadsheet with names and addresses. How do I delete rows containing Queens or other data?
March 12th, 2009
nick t asked:
I have created an excel spreadsheet with multiple rows and columns of customers. The first column is name, second house number, third town, fourth state and fifth is the zip code. There are 50,000 listings. I want to search all rows that contain “Staten Island”. Is there a way or a program to auto search and delete rows containing this data? I cant afford to do it manually as it would take hours.
Alyson
I have created an excel spreadsheet with multiple rows and columns of customers. The first column is name, second house number, third town, fourth state and fifth is the zip code. There are 50,000 listings. I want to search all rows that contain “Staten Island”. Is there a way or a program to auto search and delete rows containing this data? I cant afford to do it manually as it would take hours.
Alyson
Genius Programers
March 14, 2009
Simply go to Data Menu on Menu Bar than select Filter and Click on Auto filter.
A Drop Down Combo will appear on Each Column Select Data on which you filter data.
Select All Data and Press.
But you should Backup you sheet. You may be wrong.
LadyBug
March 15, 2009
For each header of the header of the last row not just the last row number and select ascendingthis will then right click on the row then right click and select delete rows be sure.
For each header row then right click and delete is good start but thats good thing you will make your menu bar and.