Excel shortcuts

9 Quick and Easy Ways to Hide Rows in Excel

Are you looking for ways to hide rows in Excel? Whether you want to hide empty rows, hide duplicates, or hide rows based on cell values, there are a few different ways you can do it. In this article, we'll show you 9 quick and easy ways to hide rows in Excel.

1. Hide Empty Rows

If you want to hide rows that are empty, you can do so by selecting the rows you want to hide and then going to the Home tab > Cells group > Format > Hide & Unhide > Hide Rows.

2. Hide Duplicate Rows

If you want to hide rows that contain duplicate values, you can do so by selecting the rows you want to hide and then going to the Data tab > Data Tools group > Remove Duplicates. In the Remove Duplicates dialog box, select the column or columns that contain the duplicate values and click OK.

3. Hide Rows Based on Cell Values

If you want to hide rows based on cell values, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > Highlight Cell Rules > A Date Occurring.

In the Highlight Cell Rules dialog box, select the type of rule you want to use and then enter the criteria for the rule. For example, if you want to hide rows that contain a date that is less than today's date, you would select the "Less than" rule and then enter "=TODAY()" in the Format values where this formula is true text box. Click OK to apply the rule.

4. Hide Rows Based on a Formula

If you want to hide rows based on a formula, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > New Rule.

In the New Formatting Rule dialog box, select the "Use a formula to determine which cells to format" option and then enter the formula you want to use in the Format values where this formula is true text box. For example, if you want to hide rows that contain a value that is less than 100, you would enter the following formula: =$A1<100. Click Format to select the format you want to apply to the cells and then click OK.

5. Hide Rows Based on a Cell Value

If you want to hide rows based on a cell value, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > Highlight Cell Rules > A Date Occurring.

In the Highlight Cell Rules dialog box, select the type of rule you want to use and then enter the criteria for the rule. For example, if you want to hide rows that contain a date that is less than today's date, you would select the "Less than" rule and then enter "=TODAY()" in the Format values where this formula is true text box. Click OK to apply the rule.

6. Hide Rows Based on a Formula

If you want to hide rows based on a formula, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > New Rule.

In the New Formatting Rule dialog box, select the "Use a formula to determine which cells to format" option and then enter the formula you want to use in the Format values where this formula is true text box. For example, if you want to hide rows that contain a value that is less than 100, you would enter the following formula: =$A1<100. Click Format to select the format you want to apply to the cells and then click OK.

7. Hide Rows Based on a Cell Value

If you want to hide rows based on a cell value, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > Highlight Cell Rules > A Date Occurring.

In the Highlight Cell Rules dialog box, select the type of rule you want to use and then enter the criteria for the rule. For example, if you want to hide rows that contain a date that is less than today's date, you would select the "Less than" rule and then enter "=TODAY()" in the Format values where this formula is true text box. Click OK to apply the rule.

8. Hide Rows Based on a Formula

If you want to hide rows based on a formula, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > New Rule.

In the New Formatting Rule dialog box, select the "Use a formula to determine which cells to format" option and then enter the formula you want to use in the Format values where this formula is true text box. For example, if you want to hide rows that contain a value that is less than 100, you would enter the following formula: =$A1<100. Click Format to select the format you want to apply to the cells and then click OK.

9. Hide Rows Based on a Cell Value

If you want to hide rows based on a cell value, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > Highlight Cell Rules > A Date Occurring.

In the Highlight Cell Rules dialog box, select the type of rule you want to use and then enter the criteria for the rule. For example, if you want to hide rows that contain a date that is less than today's date, you would select the "Less than" rule and then enter "=TODAY()" in the Format values where this formula is true text box. Click OK to apply the rule.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.