{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Sheet1","1.1","1.2","1.3","1.4","1.5","1.6","1.7","1.7(1)","1.8","VBA","Shortcut","Scroll","Column"],"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":"Sheet1","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Dataset"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.1","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Based on Text Match"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.2","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Based on Number Match"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.3","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Based on Multiple Conditions"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.4","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Based on Any Blank Cell in a Row"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.5","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Based on Drop-down Selection "]
[]
[null,"ID","First Name","Last Name","State","Salary",null,"Drop-Down List"]
[null,101,"April","Beren","NY",2200,null,105]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.6","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlight Duplicate Rows"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]
[null,104,"Shane ","Lee","WI",1800]

{"sheet":"1.7","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlight Alternate Odd Rows"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.7(1)","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Highlight Alternate Even Rows"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"1.8","index":9,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Highlight Active Row Using Conditional Formatting"]
[]
[null,"ID","First Name","Last Name","Department","State","Salary"]
[null,101,"April","Beren","Sales","NY",2200]
[null,102,"Christian","Bale","Finance","CA",2100]
[null,103,"Natasha ","Austin","Marketing","MI",2500]
[null,104,"Shane ","Lee","IT","WI",1800]
[null,105,"Alfred","Moyes","Operations","OH",1700]
[null,106,"Gregory","Luis","Finance","FL",1900]
[null,107,"Jerry","Seinfeld","Sales","GA",2000]
[null,108,"Richard","Hockley","Marketing","NY",2600]

{"sheet":"VBA","index":10,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlight Active Row"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"Shortcut","index":11,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlight Active Row Using Shortcut"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"Scroll","index":12,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlight Active Row while Scrolling"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]

{"sheet":"Column","index":13,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlight Active Row and Column"]
[]
[null,"ID","First Name","Last Name","State","Salary"]
[null,101,"April","Beren","NY",2200]
[null,102,"Christian","Bale","CA",2100]
[null,103,"Natasha ","Austin","MI",2500]
[null,104,"Shane ","Lee","WI",1800]
[null,105,"Alfred","Moyes","OH",1700]
[null,106,"Gregory",null,"FL",1900]
[null,107,"Jerry","Seinfeld","GA",2000]
[null,108,"Richard","Hockley","NY",2600]