Spreadsheet: 169130d1342709057-excel-2007-hide-unhide-rows-excel-query-hide-and-unhide
Sheet: Sheet1

 | When I open the excel, I only need the summary values .i.e. the totals to be shown (totals are highlighted in BLUE) & the detailed values should be hidden
 | Accordingly, on a click of a button or key, the details should be shown.
 | Business Class
 | Capacity-seats | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
 | 201-DLA-NSI | 252 | 276 | 240 | 264 | 252 | 276 | 252 | 264 | 276 | 240 | 276 | 264 | 252
 | 202-NSI-DLA | 252 | 276 | 240 | 264 | 252 | 276 | 252 | 264 | 276 | 240 | 276 | 264 | 252
 | 311-DLA-SSG | 156 | 168 | 144 | 156 | 156 | 156 | 156 | 156 | 168 | 144 | 168 | 156 | 156
 | 311-SSG-COO | 156 | 168 | 144 | 156 | 156 | 156 | 156 | 156 | 168 | 144 | 168 | 156 | 156
 | 312-COO-SSG | 156 | 168 | 144 | 156 | 156 | 156 | 156 | 156 | 168 | 144 | 168 | 156 | 156
 | 312-SSG-DLA | 156 | 168 | 144 | 156 | 156 | 156 | 156 | 156 | 168 | 144 | 168 | 156 | 156
 | 211-DLA-NSI | 60 | 48 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 60 | 48 | 48 | 60
 | 211-NSI-MVR | 60 | 48 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 60 | 48 | 48 | 60
 | 211-DLA-MVR | 96 | 108 | 96 | 108 | 96 | 120 | 96 | 108 | 108 | 96 | 108 | 108 | 96
 | 212-MVR-NSI | 156 | 156 | 144 | 156 | 156 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156
 | 212-NSI-DLA | 156 | 156 | 144 | 156 | 156 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156
 | 301-DLA-LBV | 156 | 156 | 144 | 156 | 156 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156
 | 302-LBV-BZV | 156 | 156 | 144 | 156 | 156 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156
 | 351-BZV-LBV | 156 | 156 | 144 | 156 | 156 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156
 | 352-LBV-DLA | 156 | 156 | 144 | 156 | 156 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156
 | 221-DLA-NSI | 216 | 216 | 192 | 216 | 204 | 204 | 216 | 204 | 216 | 204 | 216 | 204 | 216
 | 221-NSI-GOU | 216 | 216 | 192 | 216 | 204 | 204 | 216 | 204 | 216 | 204 | 216 | 204 | 216
 | 222-GOU-NSI | 216 | 216 | 192 | 216 | 204 | 204 | 216 | 204 | 216 | 204 | 216 | 204 | 216
 | 222-NSI-DLA | 216 | 216 | 192 | 216 | 204 | 204 | 216 | 204 | 216 | 204 | 216 | 204 | 216
 | 131-LYS-DLA | 144 | 156 | 144 | 156 | 156 | 156 | 156 | 156 | 168 | 156 | 156 | 156 | 156 |  | Details
 | 132-DLA-NSI | 144 | 156 | 144 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156 | 156 | 156
 | 132-NSI-LYS | 144 | 156 | 144 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156 | 156 | 156
 | 321-DLA-NDJ | 96 | 108 | 96 | 108 | 96 | 120 | 96 | 108 | 108 | 96 | 108 | 108 | 96
 | 322-NDJ-DLA | 96 | 108 | 96 | 108 | 96 | 120 | 96 | 108 | 108 | 96 | 108 | 108 | 96
 | 329-DLA-NSI | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60
 | 329-NSI-NDJ | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60
 | 330-NDJ-DLA | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60
 | 203-DLA-NSI | 156 | 156 | 144 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156 | 156 | 156
 | 204-NSI-DLA | 156 | 156 | 144 | 168 | 144 | 168 | 156 | 156 | 156 | 156 | 156 | 156 | 156
 | 331-DLA-BGF | 144 | 156 | 144 | 168 | 144 | 168 | 156 | 156 | 168 | 144 | 156 | 168 | 144
 | 332-BGF-DLA | 144 | 156 | 144 | 168 | 144 | 168 | 156 | 156 | 168 | 144 | 156 | 168 | 144
 | 341-DLA-FIH | 108 | 168 | 144 | 156 | 156 | 156 | 156 | 156 | 156 | 156 | 168 | 144 | 168
 | 342-FIH-DLA | 108 | 168 | 144 | 156 | 156 | 156 | 156 | 156 | 156 | 156 | 168 | 144 | 168
 | 102-DLA-NSI | 270 | 270 | 240 | 240 | 270 | 270 | 240 | 270 | 270 | 270 | 270 | 240 | 270
 | 102-NSI-CDG | 270 | 270 | 240 | 240 | 270 | 270 | 240 | 270 | 270 | 270 | 270 | 240 | 270
 | 103-CDG-NSI | 240 | 270 | 240 | 270 | 270 | 270 | 240 | 270 | 270 | 240 | 270 | 270 | 270
 | 103-NSI-DLA | 240 | 270 | 240 | 270 | 270 | 270 | 240 | 270 | 270 | 240 | 270 | 270 | 270
 | 122-DLA-CDG | 270 | 270 | 240 | 270 | 270 | 240 | 270 | 270 | 270 | 240 | 270 | 270 | 270
 | 121-CDG-DLA | 270 | 270 | 240 | 270 | 240 | 270 | 270 | 270 | 240 | 270 | 270 | 240 | 270