{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home Page","Dataset","Go To Special","Find and Replace ","Filter and Delete","VBA"],"not_rendered":{"charts":0,"images":1,"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":"Home Page","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"How to Delete Rows If Cell is Blank in Excel"]
[]
[null,"Learn the methods to delete rows if cell is blank in Excel. Read the article we provided and practice these in the practice section."]
[]
[]
[null,"Prepared By","A.N.M. Mohaimen Shanto"]
[null,"Last Update","2024-01-08"]
[null,"Article Link","How to Delete Rows If Cell is Blank in Excel"]
[]
[null,"Methods"]
[null,"1. Using Go To Special"]
[null,"2. Find and Replace"]
[null,"3. Filtering Rows and Delete"]
[null,"4. Using VBA"]

{"sheet":"Dataset","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,6,1,9]]}
[]
[null,"Delete Row If Cell is Blank",null,null,null,null,"Delete Row If Cell is Blank"]
[]
[null,"ID","Name","Designation","Joining Year",null,"ID","Name","Designation","Joining Year"]
[null,1001,"Aaron","Software Developer","2018-01-02",null,1001,"Aaron","Software Developer","2018-01-02"]
[null,1002,"Jessica","UI/UX Designer","2020-02-10",null,1002,"Jessica","UI/UX Designer","2020-02-10"]
[null,1003,"Elizabeth",null,"2022-04-17",null,1005,"John","HR","2019-09-10"]
[null,1004,"Max","Writer",null,null,1007,"Tyler","Software Developer","2017-12-10"]
[null,1005,"John","HR","2019-09-10",null,1008,"Patrick","Manager","2018-01-02"]
[null,1006,null,"Accountant","2016-10-10",null,1009,"Ben","Manager","2020-03-19"]
[null,1007,"Tyler","Software Developer","2017-12-10"]
[null,1008,"Patrick","Manager","2018-01-02"]
[null,1009,"Ben","Manager","2020-03-19"]
[]
[]
[]
[]
[]
[null,"<< Back to Homepage"]

{"sheet":"Go To Special","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,6,3,9]]}
[]
[null,"Delete Row If Cell is Blank"]
[]
[null,"Using Go To Special",null,null,null,null,"Practice"]
[]
[null,"ID","Name","Designation","Joining Year",null,"ID","Name","Designation","Joining Year"]
[null,1001,"Aaron","Software Developer","2018-01-02",null,1001,"Aaron","Software Developer","2018-01-02"]
[null,1002,"Jessica","UI/UX Designer","2020-02-10",null,1002,"Jessica","UI/UX Designer","2020-02-10"]
[null,1005,"John","HR","2019-09-10",null,1003,"Elizabeth",null,"2022-04-17"]
[null,1007,"Tyler","Software Developer","2017-12-10",null,1004,"Max","Writer"]
[null,1008,"Patrick","Manager","2018-01-02",null,1005,"John","HR","2019-09-10"]
[null,1009,"Ben","Manager","2020-03-19",null,1006,null,"Accountant","2016-10-10"]
[null,null,null,null,null,null,1007,"Tyler","Software Developer","2017-12-10"]
[null,null,null,null,null,null,1008,"Patrick","Manager","2018-01-02"]
[null,null,null,null,null,null,1009,"Ben","Manager","2020-03-19"]
[]
[]
[]
[]
[null,"<< Back to Homepage"]

{"sheet":"Find and Replace ","index":3,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,6,3,9]]}
[]
[null,"Delete Row If Cell is Blank"]
[]
[null,"Find and Replace",null,null,null,null,"Practice"]
[]
[null,"ID","Name","Designation","Joining Year",null,"ID","Name","Designation","Joining Year"]
[null,1001,"Aaron","Software Developer","2018-01-02",null,1001,"Aaron","Software Developer","2018-01-02"]
[null,1002,"Jessica","UI/UX Designer","2020-02-10",null,1002,"Jessica","UI/UX Designer","2020-02-10"]
[null,1005,"John","HR","2019-09-10",null,1003,"Elizabeth",null,"2022-04-17"]
[null,1007,"Tyler","Software Developer","2017-12-10",null,1004,"Max","Writer"]
[null,1008,"Patrick","Manager","2018-01-02",null,1005,"John","HR","2019-09-10"]
[null,1009,"Ben","Manager","2020-03-19",null,1006,null,"Accountant","2016-10-10"]
[null,null,null,null,null,null,1007,"Tyler","Software Developer","2017-12-10"]
[null,null,null,null,null,null,1008,"Patrick","Manager","2018-01-02"]
[null,null,null,null,null,null,1009,"Ben","Manager","2020-03-19"]
[]
[]
[]
[]
[null,"<< Back to Homepage"]

{"sheet":"Filter and Delete","index":4,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,6,3,9]]}
[]
[null,"Delete Row If Cell is Blank"]
[]
[null,"Filtering Rows and Delete",null,null,null,null,"Practice"]
[]
[null,"ID","Name","Designation","Joining Year",null,"ID","Name","Designation","Joining Year"]
[null,1001,"Aaron","Software Developer","2018-01-02",null,1001,"Aaron","Software Developer","2018-01-02"]
[null,1002,"Jessica","UI/UX Designer","2020-02-10",null,1002,"Jessica","UI/UX Designer","2020-02-10"]
[null,1005,"John","HR","2019-09-10",null,1003,"Elizabeth",null,"2022-04-17"]
[null,1007,"Tyler","Software Developer","2017-12-10",null,1004,"Max","Writer"]
[null,1008,"Patrick","Manager","2018-01-02",null,1005,"John","HR","2019-09-10"]
[null,1009,"Ben","Manager","2020-03-19",null,1006,null,"Accountant","2016-10-10"]
[null,null,null,null,null,null,1007,"Tyler","Software Developer","2017-12-10"]
[null,null,null,null,null,null,1008,"Patrick","Manager","2018-01-02"]
[null,null,null,null,null,null,1009,"Ben","Manager","2020-03-19"]
[]
[]
[]
[]
[null,"<< Back to Homepage"]

{"sheet":"VBA","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[3,6,3,9]]}
[]
[null,"Delete Row If Cell is Blank"]
[]
[null,"Using VBA",null,null,null,null,"Practice"]
[]
[null,"ID","Name","Designation","Joining Year",null,"ID","Name","Designation","Joining Year"]
[null,1001,"Aaron","Software Developer","2018-01-02",null,1001,"Aaron","Software Developer","2018-01-02"]
[null,1002,"Jessica","UI/UX Designer","2020-02-10",null,1002,"Jessica","UI/UX Designer","2020-02-10"]
[null,1005,"John","HR","2019-09-10",null,1003,"Elizabeth",null,"2022-04-17"]
[null,1007,"Tyler","Software Developer","2017-12-10",null,1004,"Max","Writer"]
[null,1008,"Patrick","Manager","2018-01-02",null,1005,"John","HR","2019-09-10"]
[null,1009,"Ben","Manager","2020-03-19",null,1006,null,"Accountant","2016-10-10"]
[null,null,null,null,null,null,1007,"Tyler","Software Developer","2017-12-10"]
[null,null,null,null,null,null,1008,"Patrick","Manager","2018-01-02"]
[null,null,null,null,null,null,1009,"Ben","Manager","2020-03-19"]
[]
[]
[]
[]
[null,"<< Back to Homepage"]