{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data Set","Select_Entire _Column ","Go To Special","Table","Filter","Contiguous_Cell","Select_All_Cells","Conditional_Formatting","SEARCH_Function","Excel_VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Data Set","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select All Cells with Data in a Column"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Select_Entire _Column ","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Select Entire Column"]
[]
[null,"Name","Age"]
[null,"Jessica",20]
[null,"Henderson",22]
[null,"Mitchel"]
[null,null,25]
[null,"John",28]
[]
[]
[null,null,null,null,null,null,null,null," "]

{"sheet":"Go To Special","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select All Cells with Go To Special"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Table","index":3,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select All Cells with Table"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Filter","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select All Data Cells Using Filter"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Contiguous_Cell","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select Contiguous Data Cells"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,"John",25]
[null,null,28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Select_All_Cells","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Select All Cells of Dataset"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Conditional_Formatting","index":7,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Conditional Formatting to Select Cells with Data"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"SEARCH_Function","index":8,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Excel SEARCH Function to Indicate Data Cells"]
[]
[null,"Name","Age","Status"]
[null,"Jessica",20,{"$f":"SEARCH(\"*\",B5:B9)","v":1}]
[null,"Henderson",22,1]
[null,"Mitchel",null,1]
[null,null,25,{"$error":"#VALUE!"}]
[null,"John",28,1]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Excel_VBA","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Excel VBA to Select All Data Cells"]
[]
[null,"Name","Age","Salary"]
[null,"Jessica",20,1000]
[null,"Henderson",22,1250]
[null,"Mitchel",null,1200]
[null,null,25]
[null,"John",28,2000]
[]
[]
[null,null,null,null,null,null,null,null,null," "]