Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, you can learn how to group rows and columns in Excel so that you can quickly hide and unhide rows or columns. You’ll also discover the Auto Outline feature that Excel has to anticipate which rows or columns should be grouped.

These features make it easier for users to read and navigate your summary reports.

Download the Excel file and read the post on our website:
https://www.excelcampus.com/tips/groups-outlines.

Related Videos:
The SUBTOTAL Function Explained for Excel Tables Total Row:
https://www.youtube.com/watch?v=0bdhy0ty7Mc
How to Create Subtotal Formulas in All Columns of an Excel Table:
https://www.youtube.com/watch?v=pOMaQiKZfMg
#MsExcel #ExcelCampus
00:00 Introduction
00:15 Apply Groups
01:45 Collapse Group
03:05 Auto Outline
04:00 Formula Groups
05:13 Auto Outline
06:05 Subtotal