View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Hainsworth David Hainsworth is offline
external usenet poster
 
Posts: 1
Default Can I automatically hide a column with zero values in Excel

I have a large spreadsheet which will be populated based on the selection
from a drop down list box. The values populated will contain alot of zero
values which I have blanked out using the tools/options functionality but I
would like to automatically hide the column if all values within a range in
that column are zero. Can this be done using advanced filter ? if so how ...
any other suggestions ?