Hide rows based on cell value in Excel 2007

To hide rows based on cell value in Excel 2007 follow these steps:

1. Prepare your data including a header row.
2. In the Home tab, Editing group, click Sort and Filter then select Filter from the menu.
3. Your data will now look like this:

In this example we want to hide rows where the sales are greater than or equal to 2000. I.e. we will only show rows where the sales are less than 2000.

1. Click on the filter arrow next to Sales.
2. Point to Number Filters and select Less Than.



3. The Custom AutoFilter window will open.



4. Enter 2000 in the Combo box to the right and click OK.
5. Now all rows with values greater than or equal to 2000 will be hidden. Here is the final result:

Note:

If your data is text then you will see Text Filters instead of Number Filters in the menu.

Related posts:

1. How to hide rows based on a cell value
2. How to delete duplicate rows from a range in Excel 2007
3. Conditional formatting in Excel 2007 (based on value of the current cell )
4. Average cells based on multiple criteria in Excel 2007
5. How to validate a cell based on the value of another cell