{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Format Cells","QAT","Formula Cells","Locking_VBA","Manually Using $ ","Shortcut key"],"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":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Sales Rep","Order ID","Items","States","Sales"]
[null,"Robert",101,"AC","Ohio",3000]
[null,"Smith",102,"TV","Utah",1000]
[null,"Liz",103,"Monitor","Nevada",1500]
[null,"Maria",104,"Fan","Ohio",350]
[null,"Hernandez",105,"TV","Ohio",1500]
[null,"Harris",106,"AC","Nevada",1500]
[null,"Steve",107,"TV","Utah",1000]
[null,"Michael",108,"Monitor","Ohio",1500]
[null,"William",109,"AC","Nevada",4000]
[null,"David",110,"TV","Texas",2000]
[null,"Linda",111,"Monitor","Hawaii",2000]

{"sheet":"Format Cells","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Locking Cells Using the Format Cells Option"]
[]
[null,"Sales Rep","Order ID","Items","States","Sales"]
[null,"Robert",101,"AC","Ohio",3000]
[null,"Smith",102,"TV","Utah",1000]
[null,"Liz",103,"Monitor","Nevada",1500]
[null,"Maria",104,"Fan","Ohio",350]
[null,"Hernandez",105,"TV","Ohio",1500]
[null,"Harris",106,"AC","Nevada",1500]
[null,"Steve",107,"TV","Utah",1000]
[null,"Michael",108,"Monitor","Ohio",1500]
[null,"William",109,"AC","Nevada",4000]
[null,"David",110,"TV","Texas",2000]
[null,"Linda",111,"Monitor","Hawaii",2000]

{"sheet":"QAT","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Adding a Button from Quick Access Toolbar"]
[]
[null,"Sales Rep","Order ID","Items","States","Sales"]
[null,"Robert",101,"AC","Ohio",3000]
[null,"Smith",102,"TV","Utah",1000]
[null,"Liz",103,"Monitor","Nevada",1500]
[null,"Maria",104,"Fan","Ohio",350]
[null,"Hernandez",105,"TV","Ohio",1500]
[null,"Harris",106,"AC","Nevada",1500]
[null,"Steve",107,"TV","Utah",1000]
[null,"Michael",108,"Monitor","Ohio",1500]
[null,"William",109,"AC","Nevada",4000]
[null,"David",110,"TV","Texas",2000]
[null,"Linda",111,"Monitor","Hawaii",2000]

{"sheet":"Formula Cells","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Locking Cells Having Formulas"]
[]
[null,"Sales Rep","Order ID","Price","Quantity","Sales"]
[null,"Robert",101,30,20,{"$f":"D5*E5","v":600}]
[null,"Smith",102,20,25,{"$f":"D6*E6","v":500}]
[null,"Liz",103,50,100,5000]
[null,"Maria",104,40,15,600]
[null,"Hernandez",105,40,25,1000]
[null,"Harris",106,30,15,450]
[null,"Steve",107,60,20,1200]
[null,"Michael",108,30,20,600]
[null,"William",109,50,25,1250]
[null,"David",110,60,30,1800]
[null,"Linda",111,30,15,450]

{"sheet":"Locking_VBA","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Locking Cells Using VBA Code"]
[]
[null,"Sales Rep","Order ID","Items","States","Sales"]
[null,"Robert",101,"AC","Ohio",3000]
[null,"Smith",102,"TV","Utah",1000]
[null,"Liz",103,"Monitor","Nevada",1500]
[null,"Maria",104,"Fan","Ohio",350]
[null,"Hernandez",105,"TV","Ohio",1500]
[null,"Harris",106,"AC","Nevada",1500]
[null,"Steve",107,"TV","Utah",1000]
[null,"Michael",108,"Monitor","Ohio",1500]
[null,"William",109,"AC","Nevada",4000]
[null,"David",110,"TV","Texas",2000]
[null,"Linda",111,"Monitor","Hawaii",2000]

{"sheet":"Manually Using $ ","index":5,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Manually Locking Multiple Cells"]
[]
[null,"Order ID","Items","States","Sales",null,"Order ID","Sales"]
[null,101,"AC","Ohio",3000,null,101,{"$f":"VLOOKUP(G5,$B$5:$E$15,4,FALSE)","v":3000}]
[null,102,"TV","Utah",1000,null,106,{"$f":"VLOOKUP(G6,$B$5:$E$15,4,FALSE)","v":1500}]
[null,103,"Monitor","Nevada",1500,null,111,{"$f":"VLOOKUP(G7,$B$5:$E$15,4,FALSE)","v":2000}]
[null,104,"Fan","Ohio",350]
[null,105,"TV","Ohio",1500]
[null,106,"AC","Nevada",1500]
[null,107,"TV","Utah",1000]
[null,108,"Monitor","Ohio",1500]
[null,109,"AC","Nevada",4000]
[null,110,"TV","Texas",2000]
[null,111,"Monitor","Hawaii",2000]

{"sheet":"Shortcut key","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Using the Keyboard Shortcut F4 Key"]
[]
[null,"Sales Rep","Order ID","Items","States","Sales",null,"Sales Rep","Sales"]
[null,"Robert",101,"AC","Ohio",3000,null,"David",{"$f":"VLOOKUP(H5,$B$5:$F$15,5,FALSE)","v":2000}]
[null,"Smith",102,"TV","Utah",1000,null,"Liz",{"$f":"VLOOKUP(H6,$B$5:$F$15,5,FALSE)","v":1500}]
[null,"Liz",103,"Monitor","Nevada",1500,null,"Steve",1000]
[null,"Maria",104,"Fan","Ohio",350]
[null,"Hernandez",105,"TV","Ohio",1500]
[null,"Harris",106,"AC","Nevada",1500]
[null,"Steve",107,"TV","Utah",1000]
[null,"Michael",108,"Monitor","Ohio",1500]
[null,"William",109,"AC","Nevada",4000]
[null,"David",110,"TV","Texas",2000]
[null,"Linda",111,"Monitor","Hawaii",2000]