Thread: How can i auto hide and display row or collum for zero value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote