ExcelBanter - AutoHide

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - AutoHide (https://www.excelbanter.com/excel-discussion-misc-queries/73460-autohide.html)

ernie

AutoHide

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

AutoHide

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

All times are GMT +1. The time now is 07:32 AM.