{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Dataset","Text","Numeric","All Text","All Numeric","Zero","Row No","Neg Value","Po. Value","Odd","Even","> 90","< 60","Criteria","User-Input","Change Cell Value"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Based on Cell Value with VBA"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Text","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Column Based on Cell Text Value with VBA"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Numeric","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Column Based on Cell Numeric Value"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"All Text","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Where Cells Contain Texts"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"All Numeric","index":4,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Where Cells Contain Number"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Zero","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns for Zero (0) Cell Value"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",0,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Row No","index":6,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Defining Row Number to Hide Columns"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Neg Value","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Based on Cell’s Negative Value"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",-12,"F","2022-09-20",66]

{"sheet":"Po. Value","index":8,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,4,1],[3,2,3,4]]}
[]
[null,"Hiding Columns Based on Cell’s Positive Value"]
[]
[null,"States","Temperature in Celsius"]
[null,null,"January","February","March"]
[null,"New Jersey",-3.9,-5.6,-0.6]
[null,"Michigan",-1.1000000000000001,-0.5,-6.7]
[null,"New York",-3.2,-5.6,10]
[null,"North Dakota",-5,-2.2000000000000002,-4.4000000000000004]
[null,"Ohio",-2.8,-4.4000000000000004,11.1]
[null,"Montana",-3.1,-3.9,9]
[null,"Utah",-3.3,-6.7,11.7]
[null,"Illinois",-3.5,-2.2000000000000002,7.8]
[null,"California",-2.2000000000000002,-5.6,18.3]
[null,"Iowa",-3.2,-2.2000000000000002,9.4]

{"sheet":"Odd","index":9,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Where Cells Contain Odd Numbers"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",70]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",74]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Even","index":10,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Where Cells Contain Even Numbers"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",99,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",31,"F","2022-09-20",66]

{"sheet":"> 90","index":11,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Where Cell Value Is Greater Than a Specific Condition"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",75]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",78]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"< 60","index":12,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns Where Cell Value Is Less Than a Specific Condition"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]

{"sheet":"Criteria","index":13,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7],[10,1,10,5]]}
[]
[null,"Hiding Columns Based on Inserted Condition in Cell"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]
[]
[null,"Criteria to Hide Column",null,null,null,null,"Biology"]

{"sheet":"User-Input","index":14,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7],[10,1,10,5]]}
[]
[null,"Hiding Columns Based on User Input"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena","Physics",65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",-12,"F","2022-09-20",66]
[]
[null,"Enter 1 to Hide Column B & C,\nEnter 2 to Hide Column D & E,\nEnter 3 to Hide Column F & G,\nEnter 4 to Hide Column H",null,null,null,null,2]

{"sheet":"Change Cell Value","index":15,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Hiding Columns If Cell Value Is Changed"]
[]
[null,"First Name","Last Name","Department","Marks","Grade","DOB","Retake Marks"]
[null,"John","Cena",0,65,"A","2019-04-13",69]
[null,"Roman","Reigns","Chemistry",87,"A+","2020-02-21",88]
[null,"Finn","Balor","Biology",55,"B","2020-12-31",82]
[null,"Seth","Rollins","Mathematics",100,"A+","2021-11-10",75]
[null,"Dean","Ambrose","Literature",30,"F","2022-09-20",66]