{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Find-Del (Partial)","Find-Del (Exact)","Filter","Filter + 2 matching","Filter with criteria","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete Rows in Excel with Specific Text"]
[]
[null,"Name","Location","Sales"]
[null,"John ","New York",500]
[null,"Alan","Chicago",600]
[null,"Marty","Los Angeles",700]
[null,"Alan Marsh","San Diego",450]
[null,"Lana","Texas",600]
[null,"Wayne","Dallas",750]
[null,"Kavin","California",250]
[null,"Johnson","Texas",540]
[null,"Rudolph","Texas",445]
[null,"Martin","Washington DC",800]
[null,"Luther","Texas",470]

{"sheet":"Find-Del (Partial)","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Find and Delete",null,null,null,"Try Yourself"]
[]
[null,"Name","Location","Sales",null,"Name","Location","Sales"]
[null,"John","New York",500,null,"John ","New York",500]
[null,"Marty","Los Angeles",700,null,"Alan","Chicago",600]
[null,"Lana","Texas",600,null,"Marty","Los Angeles",700]
[null,"Wayne","Dallas",750,null,"Alan Marsh","San Diego",450]
[null,"Kavin","California",250,null,"Lana","Texas",600]
[null,"Johnson","Texas",540,null,"Wayne","Dallas",750]
[null,"Rudolph","Texas",445,null,"Kavin","California",250]
[null,"Martin","Washington DC",800,null,"Johnson","Texas",540]
[null,"Luther","Texas",470,null,"Rudolph","Texas",445]
[null,null,null,null,null,"Martin","Washington DC",800]
[null,null,null,null,null,"Luther","Texas",470]

{"sheet":"Find-Del (Exact)","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Find and Delete",null,null,null,"Try Yourself"]
[]
[null,"Name","Location","Sales",null,"Name","Location","Sales"]
[null,"John","New York",500,null,"John ","New York",500]
[null,"Marty","Los Angeles",700,null,"Alan","Chicago",600]
[null,"Alan Marsh","San Diego",450,null,"Marty","Los Angeles",700]
[null,"Lana","Texas",600,null,"Alan Marsh","San Diego",450]
[null,"Wayne","Dallas",750,null,"Lana","Texas",600]
[null,"Kavin","California",250,null,"Wayne","Dallas",750]
[null,"Johnson","Texas",540,null,"Kavin","California",250]
[null,"Rudolph","Texas",445,null,"Johnson","Texas",540]
[null,"Martin","Washington DC",800,null,"Rudolph","Texas",445]
[null,"Luther","Texas",470,null,"Martin","Washington DC",800]
[null,null,null,null,null,"Luther","Texas",470]

{"sheet":"Filter","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Delete Rows Using Filter",null,null,null,"Try Yourself"]
[]
[null,"Name","Born","Height (cm)",null,"Name","Born","Height (cm)"]
[null,"Thomas",1981,163,null,"Thomas",1981,163]
[null,"Nielson",1988,175,null,"Nielson",1988,175]
[null,"Andrea",1983,160,null,"Andrea",1983,160]
[null,"Gina",1988,168,null,"Gina",1988,168]
[null,"Marco",1985,157,null,"Marco",1985,157]
[null,"Kyle",1989,164,null,"Kyle",1989,164]
[null,"Peter",1990,160,null,"Peter",1990,160]
[null,"Natalia",1993,150,null,"Bruce",1988,163]
[null,"Amelia",2000,156,null,"Natalia",1993,150]
[null,null,null,null,null,"Amelia",2000,156]

{"sheet":"Filter + 2 matching","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Delete Rows Using Filter for More than 1 Words",null,null,null,"Try Yourself"]
[]
[null,"Name","Born","Height (cm)",null,"Name","Born","Height (cm)"]
[null,"Thomas",1981,163,null,"Thomas",1981,163]
[null,"Nielson",1988,175,null,"Nielson",1988,175]
[null,"Andrea",1983,160,null,"Andrea",1983,160]
[null,"Gina",1988,168,null,"Gina",1988,168]
[null,"Marco",1985,157,null,"Marco",1985,157]
[null,"Kyle",1989,164,null,"Kyle",1989,164]
[null,"Peter",1990,160,null,"Peter",1990,160]
[null,"Bruce",1988,163,null,"Bruce",1988,163]
[null,"Natalia",1993,150,null,"Natalia",1993,150]
[null,"Amelia",2000,156,null,"Amelia",2000,156]

{"sheet":"Filter with criteria","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Delete Rows Using Filter with Criteria",null,null,null,"Try Yourself"]
[]
[null,"Name","Born","Height (cm)",null,"Name","Born","Height (cm)"]
[null,"Thomas",1981,163,null,"Thomas",1981,163]
[null,"Nielson",1988,175,null,"Nielson",1988,175]
[null,"Andrea",1983,160,null,"Andrea",1983,160]
[null,"Gina",1988,168,null,"Gina",1988,168]
[null,"Marco",1985,157,null,"Marco",1985,157]
[null,"Kyle",1989,164,null,"Kyle",1989,164]
[null,"Peter",1990,160,null,"Peter",1990,160]
[null,"Bruce",1988,163,null,"Bruce",1988,163]
[null,"Natalia",1993,150,null,"Natalia",1993,150]
[null,"Amelia",2000,156,null,"Amelia",2000,156]
[null,null,null,null,null,"Gina",1998,154]
[null,null,null,null,null,"Gina",2001,155]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Delete Rows Using VBA",null,null,null,"Do it Yourself"]
[]
[null,"Sales Rep","Region","Total Sales",null,"Sales Rep","Region","Total Sales"]
[null,"Harry","West",76540,null,"Francis","East",40506]
[null,"Sam","North",45015,null,"Harry","West",76540]
[null,"Jesse","South",87684,null,"Andrea","East",41356]
[null,"Michael","South",67895,null,"Sam","North",45015]
[null,"Bruce","West",89456,null,"Jesse","South",87684]
[null,"Thomas","South-East",14857,null,"Michael","South",67895]
[null,"Adrien","North",25654,null,"Rudolph","East",70705]
[null,null,null,null,null,"Bruce","West",89456]
[null,null,null,null,null,"Thomas","South-East",14857]
[null,null,null,null,null,"Adrien","North",25654]