Delete a list

[woodymoe]

I want to delete a list of products that are scattered through the rows of the sheet. is there a way to do that without going to each one manually?

 

[My Aswer Is This]

Where is this list of products.

Or tell me Apple Cake Pie Bread.

And when you say delete you mean clear the value from the cell correct?