Without knowing more about your data and scenarios, I'd suggest looking into
the AutoFilter option. That may do what you want.

Select your entire range of data
From the Data Menu, choose "Filter" then "AutoFilter"
The header row of each of your columns should now contain a small arrow button
These buttons will allow you to filter (or hide) rows based on certain
criteria

If that's not what you're looking for, then post back with more specific
info and examples of what you need.

HTH,
Elkar


"fishingengineer" wrote:

I am creating a spreadsheet to analyze different scenario. Based on specific
conditions, different set of calculations might have to be made and the
others although they may run can not be visible. Is there a simple
if...then...hide or thaw method?