0 of 135 lessons complete (0%)
Tips and Tricks- Intermediate

Don’t hide rows- group them rather

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.