Forum Discussion
Excel outline that displays the entire row when expanded
I need to show entire rows (not summary calculations) in an outline that is defined by one column. In this dummied-up example, on the left is a list of precincts and the voters in those precincts. On the right is what I want. When I expand a precinct, I want to see the entire name of each voter in that precinct. In the real file, there are hundreds of precincts, hundreds of thousands of voters, and dozens of columns, so the solution can't require precinct-by-precinct manual operations. Is there a way to do this in Excel?
ivotTables are great for taking large datasets and creating in-depth detail summaries.
Filter data in a range or table
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Filter by using advanced criteria
If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
NikolinoDE Thanks, Nikolino, but I'm not trying to filter the data. I want to group it but show all columns of each row (like my example on the right). I can't find a way to make Pivot Tables (or Grouping/Outlining) do that.
