{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Highlight Blank Cells","Using SpecialCells Method","Using Selection","Using For Each Loop","Empty Strings as Blank","Use of Command Button","Using WorksheetFunction"],"not_rendered":{"charts":0,"images":1,"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":"Highlight Blank Cells","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Highlight Blank Cells"]
[]
[null,"Product","Sales(January)","Sales(February)","Sales(March)"]
[null,"Laptop",45000,55000,56000]
[null,"Washing Machine",32000,34000]
[null,"Watch",10000,null,15000]
[null,"Television",40000,37000,39500]
[null,"Dishwasher",25000,null,26400]
[null,"Microwave Oven",null,10000,12000]

{"sheet":"Using SpecialCells Method","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using SpecialCells Method",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Product","Sales(January)","Sales(February)","Sales(March)",null,null,null,null,null,"Product","Sales(January)","Sales(February)","Sales(March)"]
[null,"Laptop",45000,55000,56000,null,null,null,null,null,"Laptop",45000,55000,56000]
[null,"Washing Machine",32000,34000,null,null,null,null,null,null,"Washing Machine",32000,34000]
[null,"Watch",10000,null,15000,null,null,null,null,null,"Watch",10000,null,15000]
[null,"Television",40000,37000,39500,null,null,null,null,null,"Television",40000,37000,39500]
[null,"Dishwasher",25000,null,26400,null,null,null,null,null,"Dishwasher",25000,null,26400]
[null,"Microwave Oven",null,10000,12000,null,null,null,null,null,"Microwave Oven",null,10000,12000]

{"sheet":"Using Selection","index":2,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using Selection",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Product","Sales(January)","Sales(February)","Sales(March)",null,null,null,null,null,"Product","Sales(January)","Sales(February)","Sales(March)"]
[null,"Laptop",45000,55000,56000,null,null,null,null,null,"Laptop",45000,55000,56000]
[null,"Washing Machine",32000,34000,null,null,null,null,null,null,"Washing Machine",32000,34000]
[null,"Watch",10000,null,15000,null,null,null,null,null,"Watch",10000,null,15000]
[null,"Television",40000,37000,39500,null,null,null,null,null,"Television",40000,37000,39500]
[null,"Dishwasher",25000,null,26400,null,null,null,null,null,"Dishwasher",25000,null,26400]
[null,"Microwave Oven",null,10000,12000,null,null,null,null,null,"Microwave Oven",null,10000,12000]

{"sheet":"Using For Each Loop","index":3,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using For Each Loop",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Product","Sales(January)","Sales(February)","Sales(March)",null,null,null,null,null,"Product","Sales(January)","Sales(February)","Sales(March)"]
[null,"Laptop",45000,55000,56000,null,null,null,null,null,"Laptop",45000,55000,56000]
[null,"Washing Machine",32000,34000,null,null,null,null,null,null,"Washing Machine",32000,34000]
[null,"Watch",10000,null,15000,null,null,null,null,null,"Watch",10000,null,15000]
[null,"Television",40000,37000,39500,null,null,null,null,null,"Television",40000,37000,39500]
[null,"Dishwasher",25000,null,26400,null,null,null,null,null,"Dishwasher",25000,null,26400]
[null,"Microwave Oven",null,10000,12000,null,null,null,null,null,"Microwave Oven",null,10000,12000]

{"sheet":"Empty Strings as Blank","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Highlight Empty Strings as Blank",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Product","Sales(January)","Sales(February)","Sales(March)",null,null,null,null,null,"Product","Sales(January)","Sales(February)","Sales(March)"]
[null,"Laptop",45000,55000,56000,null,null,null,null,null,"Laptop",45000,55000,56000]
[null,"Washing Machine",32000,34000,null,null,null,null,null,null,"Washing Machine",32000,34000]
[null,"Watch",10000,null,15000,null,null,null,null,null,"Watch",10000,null,15000]
[null,"Television",40000,37000,39500,null,null,null,null,null,"Television",40000,37000,39500]
[null,"Dishwasher",25000,null,26400,null,null,null,null,null,"Dishwasher",25000,null,26400]
[null,"Microwave Oven",null,10000,12000,null,null,null,null,null,"Microwave Oven",null,10000,12000]

{"sheet":"Use of Command Button","index":5,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of Command Button",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Product","Sales(January)","Sales(February)","Sales(March)",null,null,null,null,null,"Product","Sales(January)","Sales(February)","Sales(March)"]
[null,"Laptop",45000,55000,56000,null,null,null,null,null,"Laptop",45000,55000,56000]
[null,"Washing Machine",32000,34000,null,null,null,null,null,null,"Washing Machine",32000,34000]
[null,"Watch",10000,null,15000,null,null,null,null,null,"Watch",10000,null,15000]
[null,"Television",40000,37000,39500,null,null,null,null,null,"Television",40000,37000,39500]
[null,"Dishwasher",25000,null,26400,null,null,null,null,null,"Dishwasher",25000,null,26400]
[null,"Microwave Oven",null,10000,12000,null,null,null,null,null,"Microwave Oven",null,10000,12000]

{"sheet":"Using WorksheetFunction","index":6,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Product","Sales(January)","Sales(February)","Sales(March)",null,null,null,null,null,"Product","Sales(January)","Sales(February)","Sales(March)"]
["Laptop",45000,55000,56000,null,null,null,null,null,"Laptop",45000,55000,56000]
["Washing Machine",32000,34000,null,null,null,null,null,null,"Washing Machine",32000,34000]
["Watch",10000,null,15000,null,null,null,null,null,"Watch",10000,null,15000]
["Television",40000,37000,39500,null,null,null,null,null,"Television",40000,37000,39500]
["Dishwasher",25000,null,26400,null,null,null,null,null,"Dishwasher",25000,null,26400]
["Microwave Oven",null,10000,12000,null,null,null,null,null,"Microwave Oven",null,10000,12000]