View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.setup
Mc/ Mc/ is offline
external usenet poster
 
Posts: 5
Default Finding a value and then suppressing ALL rows WITHOUT the found va

Another method of hiding the desired columns without the need to hide them
manually on each occasion would be to manually hide them once, then define
that as a Custom View. I would customize a tool bar or the Menu bar and
place the Custom View icon there. Subsequently, all that would be needed
would be to auto filter the desire rows, then select the Custom View name
from the tool bar icon.