{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Sample Dataset","Delete Nth Table Row(1.1)","Delete Nth Table Row(1.2)","Delete First Table Row","Deleting Multiple Table Rows","DeleteTableRowsAfterFiltering ","DeleteEmptyTableRows(5.1)","DeleteEmptyTableRows(5.2)","DeletingTableRowUsingForLoop","DeleteTableRowBasedOnCellValue","DeleteRowsBasedOnUserCriteria","DeleteRowHoldsNegativeCellValue","DeleteRowHoldsPositiveCellValue","Delete Active Row","Sheet1","Sheet2"],"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":"Sample Dataset","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Dataset"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"Delete Nth Table Row(1.1)","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Nth Row of Excel Table Using ListObjects Statement"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"Delete Nth Table Row(1.2)","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Nth Row of Excel Table Using If Statement"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"Delete First Table Row","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting The First Row of Table"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"Deleting Multiple Table Rows","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Multiple Rows of the Table"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"DeleteTableRowsAfterFiltering ","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Table Rows After Filtering"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"DeleteEmptyTableRows(5.1)","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Table Rows If Any Cell is Empty of Specific Column"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"DeleteEmptyTableRows(5.2)","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Table Rows If Any Row is Completely Empty  "]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"DeletingTableRowUsingForLoop","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Table Rows Using For Loop"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"DeleteTableRowBasedOnCellValue","index":9,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Table Rows Based on Cell Value"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"DeleteRowsBasedOnUserCriteria","index":10,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Table Rows Based on Critera Specified By User"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]

{"sheet":"DeleteRowHoldsNegativeCellValue","index":11,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Deleting Table Rows That Contains Negative Cell Value",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Full Name","Job Title","Department","Increment",null,null,"ID","Full Name","Job Title","Department","Increment"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering",0.05,null,null,"E03611","Alice Mehta","Analyst II","Sales",-0.05]
[null,"E02135","John Delgado","Network Administrator","IT",0.1,null,null,"E04464","Cooper Yoon","Engineering Manager","Engineering",0.05]
[null,"E02968","Caroline Santos","Analyst II","Finance",0.05,null,null,"E02135","John Delgado","Network Administrator","IT",0.1]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources",0.03,null,null,"E01684","Jaxson Liang","Field Engineer","Engineering",-0.08]
[null,"E02217","William Phillips","Network Architect","IT",0.08,null,null,"E02968","Caroline Santos","Analyst II","Finance",0.05]
[null,"E01967","John Dang","Director","Sales",0.1,null,null,"E03362","Lily Henderson","HRIS Analyst","Human Resources",0.03]
[null,null,null,null,null,null,null,null,"E01108","Hannah Martinez","Manager","Marketing",-0.02]
[null,null,null,null,null,null,null,null,"E02217","William Phillips","Network Architect","IT",0.08]
[null,null,null,null,null,null,null,null,"E03519","Eliza Zheng","Systems Analyst","IT",-0.04]
[null,null,null,null,null,null,null,null,"E01967","John Dang","Director","Sales",0.1]

{"sheet":"DeleteRowHoldsPositiveCellValue","index":12,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Deleting Table Rows That Contains Positive Cell Value",null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Full Name","Job Title","Department","Increment",null,"ID","Full Name","Job Title","Department","Increment"]
[null,"E03611","Alice Mehta","Analyst II","Sales",-0.05,null,"E03611","Alice Mehta","Analyst II","Sales",-0.05]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering",-0.08,null,"E04464","Cooper Yoon","Engineering Manager","Engineering",0.05]
[null,"E01108","Hannah Martinez","Manager","Marketing",-0.02,null,"E02135","John Delgado","Network Administrator","IT",0.1]
[null,"E03519","Eliza Zheng","Systems Analyst","IT",-0.04,null,"E01684","Jaxson Liang","Field Engineer","Engineering",-0.08]
[null,null,null,null,null,null,null,"E02968","Caroline Santos","Analyst II","Finance",0.05]
[null,null,null,null,null,null,null,"E03362","Lily Henderson","HRIS Analyst","Human Resources",0.03]
[null,null,null,null,null,null,null,"E01108","Hannah Martinez","Manager","Marketing",-0.02]
[null,null,null,null,null,null,null,"E02217","William Phillips","Network Architect","IT",0.08]
[null,null,null,null,null,null,null,"E03519","Eliza Zheng","Systems Analyst","IT",-0.04]
[null,null,null,null,null,null,null,"E01967","John Dang","Director","Sales",0.1]

{"sheet":"Delete Active Row","index":13,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Active Row with Excel VBA"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]

{"sheet":"Sheet1","index":14,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Same Row On Another Worksheet with Excel VBA"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]

{"sheet":"Sheet2","index":15,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Same Row On Another Worksheet with Excel VBA"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E04464","Cooper Yoon","Engineering Manager","Engineering"]
[null,"E02135","John Delgado","Network Administrator","IT"]
[null,"E01684","Jaxson Liang","Field Engineer","Engineering"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Systems Analyst","IT"]
[null,"E01967","John Dang","Director","Sales"]