Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

outline groups

Woman happily looking at her laptop after learning how to hide rows in Excel based on cell value

Hide Rows in Excel Based on Cell Value (Without VBA)

By Excel University | February 28, 2023 |

Being able to hide rows based on cell value in Excel is a handy skill for anyone who needs to organize a large spreadsheet. Imagine you have a huge list of data, but only some of the rows are relevant to you at the moment. When you hide rows based on cell value, you can…

Read More

Outline Groups

By Jeff Lenning | June 27, 2013 |

Let me ask you a question.  How do you hide a row or a column? Since this is Excel we are talking about, there are several methods to accomplish this goal. Common Approaches One common approach is to select the row or column, and then select the Hide command, either from the Format Ribbon icon…

Read More