ExcelBanter - How can i auto hide and display row or collum for zero value

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

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

- - How can i auto hide and display row or collum for zero value (https://www.excelbanter.com/excel-discussion-misc-queries/259621-how-can-i-auto-hide-display-row-collum-zero-value.html)

Peggie

How can i auto hide and display row or collum for zero value

Dave Peterson

How can i auto hide and display row or collum for zero value

You may be able to apply Data|Filter|Autofilter (xl2003 menus) to hide rows with
0's in a certain column.

Excel doesn't have the same feature for columns. The closest I know is to group
the columns and hide them manually--or just hide the columns
(format|column|Hide) manually.

Peggie wrote:

--

Dave Peterson

All times are GMT +1. The time now is 12:41 PM.