Deleting Filter Items

[rockyw]

I have a spreadsheet with 10 vendors, I used a filter to only show 4. How can I delete the extra vendors so they are not availible if I send this to someone. Is there a eay way to get rid of the extra vendors? Thanks

 

[Weaver]

best way is to filter for the ones you don't want then delete all the visible rows and remove the filter.

 

[rockyw]

Thank you, that is fast and easy. Sometimes you have to look at something from a differant direction. Have a great weekend.