Quickly Hide Rows In Excel - Easy Way To Save Time!

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:

Related Videos:
The SUBTOTAL Function Explained for Excel Tables Total Row:
How to Create Subtotal Formulas in All Columns of an Excel Table:
#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

[nursofiahzamri]

you don't know how much you've helped me. Big Thank you!!!

[monkncook]

Discovered your channel through google. I love how you explain things. Thank you. Subscribed.

[lordcharfield]

You just saved my life! Thanks very very much! Subscribed 👍🏼🇬🇧🇺🇸

[valensrwema]

Amazing features 👏 👌 🙌
Thanks @ Jon Excel Campus

[anzal]

You're a lifesaver, been thinking on the best and fastest way to make a copy paste template that doesn't require much time, i think this would be the best rather than using some complicated stuffs like macros and pivots

[lauradeatonklauke]

Thank you for that clear explanation! I am NOT an excel expert but I understood and applied the skills you presented easily. Wow!!

[spuneet]

Both of them are currently using in daily tasks, thanks

[pinghb]

This is fantastic. Well explained. Thank you!

[esco]

Nice quick video. I have never been comfortable with groups, now I want to attempt using them.

[wayneedmondson]

Hi Jon.. nice summary of grouping. I use the keyboard shortcuts daily.. very handy. Thanks for sharing these tips. Thumbs up!!

[danielh]

This video is very helpful. Thank you very much!

[nagendraprathap]

Thanks for sharing this Sir, very useful information, in practice working,

[mariaogando]

I don’t even know how to thank you ☺️ ❤

[dianeyu]

Thank you for this tutorial, Jon! Excellent explanation that was easy to follow and understand. Now, I can "group" my data easily and efficiently!

[hussainfawzer]

This is total time saver
Thank you very much

[darrylmorgan]

GROUP And OUTLINES Can Be Quite Confusing At First But Become Easier With Practice..Great Tutorial/Explanation Thank You Jon :)

[nbjamspice]

Thanks. This is awesome and right on time for this project that I'm working on.

[jimfitch]

Great tutorial, Jon, on features that I’ve been aware, but almost never use b/c I didn’t know how to use them. Thank you.

[CarlosEliezerHernandezPintor]

You are amazing, thanks for sharing your knowledge!

[saemakhatun]

Absolutely outstanding tutorial! Thanks a lot for your kind co-operation.