{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Copy Command","Context Menu","Drag and Drop","Shortcut","Hidden Rows","Other Rows","Formula","Multiple Rows","Another Sheet","Another Sheet Copy"],"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee List"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]

{"sheet":"Copy Command","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Copy Command on Ribbon"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,669,"Julie","Sales"]

{"sheet":"Context Menu","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing Context Menu"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,669,"Julie","Sales"]

{"sheet":"Drag and Drop","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying Drag and Drop Method"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,669,"Julie","Sales"]

{"sheet":"Shortcut","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adopting Keyboard Shortcut"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,669,"Julie","Sales"]

{"sheet":"Hidden Rows","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Without Hidden Rows"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]

{"sheet":"Other Rows","index":6,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Every Other Rows"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,{"$f":"B4","v":"ID"},{"$f":"C4","v":"Name"},"Department"]
[]
[null,{"$f":"B6","v":668},"Jon","IT"]
[]
[null,{"$f":"B8","v":670},"Marilyn","Marketing"]
[]
[null,{"$f":"B10","v":672},"Adrian","IT"]
[]
[null,{"$f":"B12","v":674},"Arica","Marketing"]

{"sheet":"Formula","index":7,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Rows with Formula"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,"ID","Name","Department"]
[null,{"$f":"VLOOKUP(B5:B12,B$5:$D$12,1,FALSE)","v":667},{"$f":"VLOOKUP(C5:C12,C$5:$D$12,1,FALSE)","v":"Steven "},{"$f":"VLOOKUP(D5:D12,D$5:$D$12,1,FALSE)","v":"Sales"}]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]

{"sheet":"Multiple Rows","index":8,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Multiple Rows"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]
[]
[null,"ID","Name","Department"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,673,"Janet","IT"]

{"sheet":"Another Sheet","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Rows to Another Sheet"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]

{"sheet":"Another Sheet Copy","index":10,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Rows to Another Sheet"]
[]
[null,"ID","Name","Department"]
[null,667,"Steven ","Sales"]
[null,668,"Jon","IT"]
[null,669,"Julie","Sales"]
[null,670,"Marilyn","Marketing"]
[null,671,"Wanda","Sales"]
[null,672,"Adrian","IT"]
[null,673,"Janet","IT"]
[null,674,"Arica","Marketing"]