When you’re analyzing a huge amount of data, it’s always convenient to use programs like Excel to help you out. By putting your data into an Excel worksheet, you can organize and process all that information as you see fit.
Sometimes, you may just have too much data. And that can get really distracting. The best way to deal with the data you’re not currently using is to hide it. This can help you focus on the important figures that are relevant to your analysis.
In Excel, this option is called Grouping. It can be done both automatically and manually, depending on the structure of your data.
Please note that grouping is different from the “Hide” option. When you hide rows or columns and you want to print the sheet you’re working on, hidden items will not appear on the printout.