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

[@nursofiahzamri7600]

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

[@spuneet156]

Both of them are currently using in daily tasks, thanks

[@ExcelCampus]

Awesome! 👍

[@nagendraprathap9697]

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

[@ExcelCampus]

Thanks Nagendra! 🙂

[@pinghb1367]

This is fantastic. Well explained. Thank you!

[@lordcharfield4529]

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

[@nealbunn419]

This is a game changer. Thanks!! ❤😊

[@ExcelCampus]

Glad you like it! 😀

[@danielh9269]

This video is very helpful. Thank you very much!

[@monkncook]

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

[@valensrwema]

Amazing features 👏 👌 🙌 Thanks @ Jon Excel Campus

[@peterjames8046]

Thanks and very useful

[@ExcelCampus]

Thanks Peter! 🙂

[@nbjamspice]

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

[@ExcelCampus]

I'm happy to hear it. Thanks! 🙌

[@nbjamspice]

@@ExcelCampus do you have tutorials on COUNTIFS? I'm having trouble with copying the formula from one column to another, I am creating metrics for each month for 32 different groups. The formula changes when I paste into the first cell of the column and I have to redo each time? I know there must be a easier way.

[@florinemartis4624]

Very informative and useful

[@ExcelCampus]

Thanks Florine! 🙂

[@junaopako]

Nice and very useful. Thanks mate 🤸🙋

[@ExcelCampus]

Thanks so much! 🙂

[@anzal5807]

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

[@orpat007]

Just what I was looking for! Nice!

[@hussainfawzer]

This is total time saver Thank you very much

[@lauradeatonklauke3494]

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

[@MyChannel706]

Excellent video again!

[@esco76]

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

[@dianeyu6430]

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

[@QuanNguyen-lz3nd]

Thanks so much for you info!

[@shoppersdream]

Nice, thanks!

[@wayneedmondson1065]

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

[@Vroemmm007]

Great tutorial again Jon! Thanks!

[@babupalek]

Thank you sir.. 🙏

[@ExcelCampus]

Thanks Babu! 🙂

[@alexdelotchdavis4481]

THANK YOU!!!

[@Coder-fz4gg]

Thanks, this helped me.

[@mariaogando878]

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

[@CarlosEliezerHernandezPintor]

You are amazing, thanks for sharing your knowledge!

[@ngun6592]

Great tutorial, thank you

[@darrylmorgan]

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

[@ExcelCampus]

I agree. Thanks Darryl! 🙌

[@themotoristhub]

Great tutorial.

[@omprakashojha9698]

Great lesson. Thank you!

[@saemakhatun2130]

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

[@thanupong4168]

Good Teacher

[@tweetyhanh9444]

Thank you.

[@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.

[@elisakasmik7629]

Very good! Txs

[@nicoledelamerced6844]

Thank you for this !

[@johnroberts5225]

Thanks man

[@gloriagalvin6157]

Thanks!

[@jeanacatangal7300]

Awesome! New subscriber here

[@carywilson6435]

Helpful. Kicking it up a notch: can you custom format the subtotal rows|coumns?

[@jaykeck1060]

Quick question Jon. I am creating a spreadsheet and need a section of rows to have different columns then other sections of groups of rows. For example, the first 5 rows will have 2 columns and the next 5 rows will have 5 columns. Then the next X number of rows with have their own number of needed columns. Appreciate any pointers on how to do that.

[@mohitjagad]

Hi Jon, thanks for sharing👍👍.. Auto outline is actually new thing for me. I have one question, 'Is there any keyboard shortcut to expand / condense the group ?'

[@ExcelCampus]

Thanks Mohit! Great question! Yes, there are few ways to go about it. 1. You can use the keyboard shortcuts to hide/unhide rows & columns. Ctrl+9 to Hide Rows Ctrl+0 (zero) to Hide Columns Ctrl+Shift+( to Unhide Rows Ctrl+Shift+) to Unhide Columns - If this doesn't work for you try Alt,O,C,U (old Excel 2003 shortcut that still works). You can also modify a Windows setting to prevent the conflict with this shortcut. See #4 on this post for more info: www.excelcampus.com/keyboard-shortcuts/row-and-column-shortcuts/ 2. You can use the Show Detail and Hide Detail buttons on the Data tab of the ribbon. Keyboard shortcuts on Windows are:Alt, A, J to Show DetailAlt, A, H to Hide Detail 3. You can add any of the buttons above to the Quick Access Toolbar to create faster Alt+Number shortcuts. See this post for details: www.excelcampus.com/keyboard-shortcuts/excel-quick-access-toolbar-qat-keyboard-shortcuts/ With ALL of the shortcuts above you will need to have cells within the groups selected first to collapse or expand them. You can also hit Ctrl+A first to select all cells on the sheet, then press the expand/collapse shortcuts. I forgot to mention these shortcuts in this video and I'll do a follow-up video that explains them in more detail. Thanks! 🙌

[@mohitjagad]

@@ExcelCampus Thanks Jon for your reply and sharing above shortcuts. I will definitely try out these.. Also it would be great to watch your video explaining it in detail.. 🙌🥂

[@vineeshramesh]

Thanks

[@dariusstonkus8944]

Hey Jon this is very nice, ill start with this. However, What i'm thinking of having is a client referral system where I want to able to see the 'parent client' and then subsequent referals from the the refered clients . Almost like a Ancestry tree. I hope I make sense here.

[@komjb1890]

Awesome

[@ExcelCampus]

Thanks Kom! 🙂

[@dchemail271]

is there a way to group across multiple rows, i.e. (Row 1 is the same as row 5, 10,23, etc)?

[@janocastaneda]

Thank you for to do remember it. A question when I group 3x4 and save as *.csv file and check it on notepad I see many many commas add at last on row columns . some mistake but I dont find it. Please some comments.

[@tomgriffin4331]

Once rows are grouped, is it possible to apply a filter but keep the grouped rows together?

[@mounika7645]

Nice video. I have an excel where I need to add data in collapsible list and the updated data should be on the top and previous data should be moved to the next collapsible data..Any suggestions ?

[@vijaykulkarni672]

Great.. Can we apply this to Pivot table as well?

[@jshigeno1168]

Hi Jon, thanks for the great video! Is it possible to change the level of a grouping? For example, I have three first-level groupings (A, B, C), one 2nd-level grouping (A.1), and three 3rd-level groupings (A.1.i, B.0.i, C.0.i), there doesn't seem to be a way to "assign" B&C's third level with with A's third level -- they expand/collapse with A's 2nd level. Thanks for your help!

[@Mohamed.GadAllah]

Is it possible to use Auto Outline with Tables?

[@afsanemahdavi2689]

Is it possible to write an adds-in with macros and publish that as an app in Microsoft store? I watches other videos of you related to adds-in , you used javascript and asp.

[@davidgtriana]

Is there any way to hide those additional bars?

[@egahmogane8805]

Hi, can you help me out here. Im want to hide cell data and type new data on the very same cell. The catch here is to still have the color scale from the hidden data still showing in the new typed data. Hope i explained we . Thnks Egah

[@jimmysanders1375]

Is there a way to get rid of group outline but keep the grouping?

[@Robbysato]

The plus and minus on the left side doesn’t pop up for me when I push group.

[@venkateshns2003]

How to make it work on a protected sheet?

[@lilypadDEMA]

what about solver I did not find any about it