Can any one tell me what property has been applied to this sheet

[jayalaxmi]

Can any one tell me what property has been applied to this sheet???y this excel sheet looking like??

 

[Deepak]

It's called grouping..

https://support.office.com/en-in/ar...orksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff

 

[jayalaxmi]

It's called grouping..

https://support.office.com/en-in/ar...orksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff

thanks

 

[jayalaxmi]

It's called grouping..

https://support.office.com/en-in/ar...orksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff

hey Deepak I had tried according to the steps given in it...but I am the output as this...pls see the attachment and reply...y I am getting zero's in between the regions...

 

[Deepak]

You might not did correct selection of range while creating the same.

=SUBTOTAL(9,C49:C49)

Check a video here :