Thread: How hide all Columns based on specific cell data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dilip Ghosh Dilip Ghosh is offline
external usenet poster
  
Posts: 1
Default How hide all Columns based on specific cell data
I want to hide all the columns of a Spreadsheet based on specific data on a cell.
For example, if B1=0 and E1=0, hide column B and E.
Can anyone help about the easiest way to do it in Excel ?




Reply With QuoteReply With Quote