{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Title","Data","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2089]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: skeeze / pixabay"]

{"sheet":"Data","index":1,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,0,0,2],[6,10,6,12]]}
["This is why I hate Merged Cells!",null,null,null,null,"Center Across Selection is Better"]
["Phrase","Qty","Revenue",null,null,"Phrase","Qty","Revenue"]
["only ^ on",200,17800,null,null,"only ^ on",200,17800,null,null,123,null,null,null,123]
["don't # them",400,35600,null,null,"don't # them",400,35600,null,null,123,null,null,null,123]
["before % i'm",500,44500,null,null,"before % i'm",500,44500,null,null,123,null,null,null,123]
["having # for",200,17800,null,null,"having # for",200,17800,null,null,123,null,null,null,123]
["most ! those",300,26700,null,null,"most ! those",300,26700,null,null,"Merged Cell",null,null,null,"Center Across Selection"]
["such # until",100,8900,null,null,"such # until",100,8900,null,null,123,null,null,null,123]
["by ? he's",300,26700,null,null,"by ? he's",300,26700,null,null,123,null,null,null,123]
["for # further",300,26700,null,null,"for # further",300,26700,null,null,123,null,null,null,123]
["they'd ~ for",400,35600,null,null,"they'd ~ for",400,35600,null,null,123,null,null,null,123]
["Row 12",400,{"$f":"C11+10","v":35610},null,null,null,null,null,null,null,123,null,null,null,123]
["Row 13",400,{"$f":"C12+10","v":35620},null,null,null,null,null,null,null,123,null,null,null,123]
["Row 14",400,35630,null,null,null,null,null,null,null,123,null,null,null,123]
["Row 15",400,35640,null,null,null,null,null,null,null,123,null,null,null,123]
["Row 16",400,35650,null,null,null,null,null,null,null,123,null,null,null,123]
["Row 17",400,35660,null,null,null,null,null,null,null,null,null,null,null,123]
["Row 18",400,35670]
["Row 19",400,35680]
["Row 20",400,35690]
["Row 21",400,35700]
["Row 22",400,35710]
["Row 23",400,35720]
["Row 24",400,35730]
["Row 25",400,35740]
["Row 26",400,35750]
["Row 27",400,35760]
["Row 28",400,35770]
["Row 29",400,35780]
["Row 30",400,35790]
["Row 31",400,35800]
["Row 32",400,35810]
["Row 33",400,35820]
["Row 34",400,35830]
["Row 35",400,35840]
["Row 36",400,35850]
["Row 37",400,35860]
["Row 38",400,35870]
["Row 39",400,35880]
["Row 40",400,35890]
["Row 41",400,35900]
["Row 42",400,35910]
["Row 43",400,35920]
["Row 44",400,35930]
["Row 45",400,35940]
["Row 46",400,35950]
["Row 47",400,35960]
["Row 48",400,35970]
["Row 49",400,35980]
["Row 50",400,35990]
["Row 51",400,36000]
["Row 52",400,36010]
["Row 53",400,36020]
["Row 54",400,36030]
["Row 55",400,36040]
["Row 56",400,36050]
["Row 57",400,36060]
["Row 58",400,36070]
["Row 59",400,36080]
["Row 60",400,36090]
["Row 61",400,36100]
["Row 62",400,36110]
["Row 63",400,36120]
["Row 64",400,36130]
["Row 65",400,36140]
["Row 66",400,36150]
["Row 67",400,36160]
["Row 68",400,36170]
["Row 69",400,36180]
["Row 70",400,36190]
["Row 71",400,36200]
["Row 72",400,36210]
["Row 73",400,36220]
["Row 74",400,36230]
["Row 75",400,36240]
["Row 76",400,36250]
["Row 77",400,{"$f":"C76+10","v":36260}]
["Row 78",400,36270]
["Row 79",400,36280]
["Row 80",400,36290]
["Row 81",400,36300]
["Row 82",400,36310]
["Row 83",400,36320]
["Row 84",400,36330]

{"sheet":"Wrap Up","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Merged Cells are evil."]
[null,"My one rant about a merged cell is that the selected range gets larger when you touch a merged cell"]
[null,"I was always frustrated because I couldn't make the selection narrower again."]
[null,"Steve from Huntsville: keep holding down shift key, click in the cell just below the merged cell."]
[null,"Or - keep holding down the shift key and press Down, Left, Left"]
[null,"This assumes that the merged cell is at the top, not in the middle of your range."]
[null,"If the merged cell is in the middle, you can not narrow the selection - use Center Across Selection instead."]