Don’t hide rows- group them rather

Please sign up for the course before starting the lesson.

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.

Group Ungroup Rows Columns

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.

Group Ungroup Rows Columns

To see the full course contents click here.

Back to: Intermediate Excel Course > Tips and Tricks- Intermediate