Most people quickly learn to hide rows and columns in Excel. However, this has a risk and a safer way to achieve the same thing is to rather include the convenient plus and minus signs to the left. This also allows you to create nested groupings which can make your spreadsheet look like there is a drill down capability.
A major benefit with grouping is that you can nest the groupings. Below if we highlight rows 15 to 22 and group them, a 3rd level appears. You can now open a report at, for example, gross profit level and then drill down into Sales and Cost of Sales levels and further into the underlying products.
To see the full course contents click here.