• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Delete selected rows from Excel

I have number of spread sheets and I want to delete records from them.

Example :
I have following data in spreadsheet:

Name                                                  Id
GenePoint                                  001E0000002eoqCIAQ
United Oil & Gas, UK                 
United Oil & Gas, Singapore         
Edge Communications                  001E0000002eoqFIAQ

what i want to do is : i want to delete records which don't have ID. i.e United Oil & Gas, UK                 
United Oil & Gas, Singapore . also i dont want to delete header fields that is Name and id.
how can i do it ??
3 Solutions
Rory ArchibaldCommented:
You could just sort the date on the ID column and then delete all the blank ID rows from the bottom?
sort your spreadsheet by the id then select those rows as they will be in sequence of each other. then delete the rows.
Afterwards you can re-sort which ever way you need it.
Rob HensonIT & Database AssistantCommented:
If you don't want to affect the existing sort order you can use the AutoFilter option.

Select all the data, including headers, and Select the AutoFilter from the Data menu.

Use the dropdown on the ID column to select Blanks. This will hide all rows with an ID. Highlight the visible rows and do what you would normally do to delete rows. An error message will come up about deleting Entire Row, click OK.

Blank rows now gone and no data visible. Use the dropdown on the ID column to Show All.

Job Done. If you want rid of the drop downs, deselect the AutoFilter option form the Data menu.

Rob H
Rob HensonIT & Database AssistantCommented:
Alternatively, use the AutoFilter to show NonBlanks and copy the result elsewhere. Only visible rows will be copied but formulae driven cells will be converted to value.

Rob H
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now