If you filter data, complete rows are hidden if values in a number of columns You should not meet up with the filtering criteria. You may filter on numeric or text values, or filter by color for cells that have color formatting applied to their background or text. AutoFilter in https://autofilter86418.pointblog.net/the-smart-trick-of-auto-filter-that-no-one-is-discussing-77921401