I like to apply data|filter|autofilter

Then show the blanks or non-blanks (using that dropdown arrow)

ernie wrote:

Is there anyway to make a row or column autohide if it contains data or
autohide if it doesnt have data?
--
help a friend help you

--

Dave Peterson