Group Excel Rows (or Columns)- Drilldown with + or - buttons

Описание: 00:00 Hide versus Group- Risk of hiding rows and columns
00:20 How to group rows (+ on side) in Excel to achieve the same thing
00:50 Reason grouping with the +/- on side it less risky
01:08 Another benefit- nested groupings that open independently (not possible with hide)
01:36 Quickly change view from on screen to print version
02:08 Group columns rather then hiding- useful for months with year subtotals
02:20 Change the +/- group symbol to be top of rows not bottom

How to group rows or columns in Excel 2013 so that you can easily open or close them and give the appearance of drill down capabilities. Safer than hiding rows or columns. See why on    • Don't hide rows/ columns in Excel! Double ...  .