{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","WaysToClear","Sheet7","Wrap Up"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":18,"comments":1,"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,2068]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Wokandapix / Pixabay"]

{"sheet":"WaysToClear","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Original",".Clear",".ClearComments",".ClearContents",".ClearFormats",".ClearHyperlinks",".ClearNotes",".ClearOutline"]
[null,"Regular",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Red",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Hyperlink",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Left",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Currency",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Outline",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Purple",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Bold Italic Center",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Custom Fill",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Yellow Fill",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Comment",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Red Date","1903-05-18",null,"1903-05-18","1903-05-18",1234,"1903-05-18","1903-05-18","1903-05-18"]
[null,"Strikethrough",1234,null,1234,1234,1234,1234,1234,1234]
[null,"Superscript",1234,null,1234,1234,1234,1234,1234,1234]

{"sheet":"Sheet7","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"Item #","Description","Price"]
[null,"Qty","Item #","Description","Unit Price","Total","B/O",null,1,"Power Excel with MrExcel",39.950000000000003]
[null,null,null,{"$f":"VLOOKUP($C5,$I$4:$K$8,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C5,$I$4:$K$8,3,0)","v":{"$error":"#N/A"}},{"$f":"E5*B5","v":{"$error":"#N/A"}},null,null,2,"MrExcel XL - 40 Greatest Tips",29.95]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"E6*B6","v":{"$error":"#N/A"}},null,null,3,"Excel Gurus Gone Wild",24.95]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,4,"Pivot Table Data Crunching",34.950000000000003]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,5,"M is for (Data) Monkey",29.95]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Wrap Up","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"How to Clear in VBA"]
[null,"There are 7 different methods available"]
[null,".Clear clears everything"]
[null,".ClearComments clears comments"]
[null,".ClearContents keeps the formatting and clears values & formulas"]
[null,".ClearFormats clears the formatting"]
[null,".ClearHyperlinks clears hyperlinks"]
[null,".ClearNotes clears comments (Comments used to be called Notes)"]
[null,".ClearOutline gets rid of group & outline groups"]
[null,".SpecialCells can be used to select only constants or only formulas"]