I've got a rather large spreadsheet that I need to filter some rows out of. In the spreadsheet, all rows whose M-Column doesn't equal "on" must be removed. I applied a filter, and re-saved the document, but that kept the unwanted rows – how can I permanently delete these rows instead?
A | B | ... | M ------------------------------- Jonathan | Sampson | ... | on Jeff | Atwood | ... | Joel | Spolsky | ... | on
So in this example, I would want to completely remove Jeff Atwood's record.
Best Answer