Is there a simple procedure to hide rows if a condition is met

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning 1 of 4 values if conditions are met 4
How do I auto hide a row if a condition isnt met? 1
Conditional Formatting of a Row 2
Hide Rows If Condition True 2
hide row on spreadsheet 3
How do i hide rows if a condition is met 1
Conditional Formatting Shading For Visible Rows Only 3
Auto Hide Blank Rows 1

Top