Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a simple procedure to hide rows if a condition is met
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a simple procedure to hide rows if a condition is met
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide rows where cell condition is not met | Excel Worksheet Functions | |||
How do I hide a combo_box on a condition? | Excel Worksheet Functions | |||
How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
special type of rows to columns procedure | New Users to Excel | |||
Is there a simple procedure to set my macros in Excel 2003 to be . | New Users to Excel |