![i cant find the quick analysis tool in excel 2007 i cant find the quick analysis tool in excel 2007](https://support.content.office.net/en-us/media/d6616a80-ad83-4d68-a0fc-8e2bf7cad4c5.png)
Since other users of the spreadsheet may not notice this (and you may forget yourself) you should never hide cells in Excel.
![i cant find the quick analysis tool in excel 2007 i cant find the quick analysis tool in excel 2007](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/07/Quick-Analysis-Tools-in-Excel.jpg)
The only way to see that cells are hidden is to notice that the row number or column number suddenly jumps (e.g., from row 25 to row 167). The reason is that Excel does not make it clear to the user of the spreadsheet that cells have been hidden, and thus they may go unnoticed. Though many people do it, you should never hide cells in Excel (or spreadsheets either, for that matter). There is also a “1” button in the top left corner to collapse all groups, and a “2” button to expand all groups. If you want to expand them again, press the “+” buttons in the margin, as shown in the screenshot below. Once you’re finished, you can press the “-” buttons in the margin to collapse the rows or columns. You can repeat the steps above as many times as you like, and you can also apply it to columns as well. Select the rows you wish to add grouping to (entire rows, not just individual cells).Here are the steps to follow to group rows:
#I CANT FIND THE QUICK ANALYSIS TOOL IN EXCEL 2007 HOW TO#
The screenshots below will show you how to properly implement grouping in Excel. Suppose we have a schedule in a worksheet that is becoming quite long, and we want to reduce the amount of detail that’s shown. Let’s look at a simple exercise to see how it works. The function is found in the Data section of the Ribbon, then Group.