{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Using Keyboard","Using Right Click","Using Ribbon Command","Using Find & Replace","Using Go To Special ","Using Filter","Using Text to Column","Using Hide","Using VBA","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"How to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple","Apple_1001",450,"2021-12-15","Delivered"]
[null,"Orange","Orange_1002",325,"2021-12-16","Delivered"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Kiwi","Kiwi_1004",576,"2021-12-18","Delivered"]
[null,"Cherry","Cherry_1005",342,"2021-12-19","Delivered"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Orange","Orange_1008",425,"2021-12-16","Delivered"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using Keyboard","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Keyboard Shortcut to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple","Apple_1001",450,"2021-12-15","Delivered"]
[null,"Orange","Orange_1002",325,"2021-12-16","Delivered"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Kiwi","Kiwi_1004",576,"2021-12-18"]
[null,"Cherry","Cherry_1005",342,"2021-12-19","Delivered"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Orange","Orange_1008",425,"2021-12-16","Delivered"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using Right Click","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Right Click to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using Ribbon Command","index":3,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Ribbon Command to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using Find & Replace","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Find & Replace to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple","Apple_1001",450,"2021-12-15"]
[null,"Orange","Orange_1002",325,"2021-12-16"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Kiwi","Kiwi_1004",576,"2021-12-18"]
[null,"Cherry","Cherry_1005",342,"2021-12-19"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Orange","Orange_1008",425,"2021-12-16"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using Go To Special ","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Go To Special to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple","Apple_1001",null,null,"Delivered"]
[null,"Orange","Orange_1002",null,null,"Delivered"]
[null,"Strawberry","Strawberry_1003",null,null,"Pending"]
[null,"Kiwi","Kiwi_1004",null,null,"Delivered"]
[null,"Cherry","Cherry_1005",null,null,"Delivered"]
[null,"Blackberry","Blackberry_1006",null,null,"Pending"]
[null,"Cherry","Cherry_1009",null,null,"Pending"]
[null,"Orange","Orange_1008",null,null,"Delivered"]
[null,"Avacado","Avacado_1007",null,null,"Pending"]

{"sheet":"Using Filter","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Filter to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[]
[]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[]
[]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using Text to Column","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Text to Column to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple",1001,450,"2021-12-15","Delivered"]
[null,"Orange",1002,325,"2021-12-16","Delivered"]
[null,"Strawberry",1003,678,"2021-12-17","Pending"]
[null,"Kiwi",1004,576,"2021-12-18","Delivered"]
[null,"Cherry",1005,342,"2021-12-19","Delivered"]
[null,"Blackberry",1006,543,"2021-12-20","Pending"]
[null,"Cherry",1009,342,"2021-12-19","Pending"]
[null,"Orange",1008,425,"2021-12-16","Delivered"]
[null,"Avacado",1007,567,"2021-12-19","Pending"]

{"sheet":"Using Hide","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Hide to Remove Value in Excel"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple","Apple_1001",450,"2021-12-15","Delivered"]
[null,"Orange","Orange_1002",325,"2021-12-16","Delivered"]
[null,"Kiwi","Kiwi_1004",576,"2021-12-18","Delivered"]
[null,"Cherry","Cherry_1005",342,"2021-12-19","Delivered"]
[null,"Orange","Orange_1008",425,"2021-12-16","Delivered"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Using VBA","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using VBA"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[]
[]
[]
[]
[null,"Cherry","Cherry_1005",342,"2021-12-19","Delivered"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Orange","Orange_1008",425,"2021-12-16","Delivered"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]

{"sheet":"Practice Sheet","index":10,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Do it YourSelf"]
[]
[null,"Product Name","Order ID","Price","Order Date","Status"]
[null,"Apple","Apple_1001",450,"2021-12-15","Delivered"]
[null,"Orange","Orange_1002",325,"2021-12-16","Delivered"]
[null,"Strawberry","Strawberry_1003",678,"2021-12-17","Pending"]
[null,"Kiwi","Kiwi_1004",576,"2021-12-18","Delivered"]
[null,"Cherry","Cherry_1005",342,"2021-12-19","Delivered"]
[null,"Blackberry","Blackberry_1006",543,"2021-12-20","Pending"]
[null,"Cherry","Cherry_1009",342,"2021-12-19","Pending"]
[null,"Orange","Orange_1008",425,"2021-12-16","Delivered"]
[null,"Avacado","Avacado_1007",567,"2021-12-19","Pending"]