Click Data > Filter, see screenshot: 2. Then click the drop down button at the right corner of the cell in the selected list, and uncheck the Blanks option under the drop down menu. See screenshot: 3. And then click OK, all the non-blank cells have been filtered out as following screenshot shown: