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

D

Dave Peterson

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I auto hide a row if a condition isnt met? 1
Custom Views + hidden columns does seem to work 0
Hide and Unhide Function 4
Macro to hide colums with value of zero or blank 3
How to lhide - lock columns (with a passord) BUT without preventin 1
Displaying column and row names 3
How can i hide a row or delete 4
Can you Create an Autofilter that goes over 2 columns at the same 1

Top