Hello, Just a quick question since I’ve been given a task involving excel and am still learning. Here is where I am:



I’ve exported an inventory list for a stock transfer very simple, one column of SKU numbers and one of the quantity of each item. However all of the rows that have a quantity of zero need to be removed. I could do this by one by one but I feel like there must be a way to automatically remove them once the sheet has been generated.

Is there a way to do this quickly and how? Thanks so much in advance!