Hide/Unhide Columns & Rows FAST in Microsoft Excel | Groups & Subtotals | TutelaGeek

preview_player
Показать описание
Today we are taking a look into Groups and subtotals in Microsoft Excel. A quick way to hide and unhide Rows and Columns in Microsoft Excel.

Follow me on:

00:00 Intro
00:45 Why Groups are useful.
01:12 How to to add and use Groups in Columns.
01:58 Add Groups using a shortcut.
02:15 Add Sub-Groups
02:43 Hide & Unhide Columns Collectively
02:59 Add Groups in Rows
03:31 Remove Groups 3 Ways
04:18 Create Subtotals using Groups
05:39 Quickly show only the Subtotals' Results 2 Ways
06:06 Remove Subtotals

This Video is not Sponsored
Рекомендации по теме
Комментарии
Автор

How have I not heard about this before? Such a cool function. Thank you for sharing

katemem
Автор

Great video, very useful functionality!

thoughtscent