{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Home Page","Select Row","Select Row in Range","Insert Row","Insert Row and Copy Formula","Set Row Height","Autofit Row Height","Count Rows","Count Non-empty Rows","Copy Paste Rows","Hide Rows","Unhide Rows","Group Rows","Ungroup Rows","Delete Rows","Delete Rows with Criteria","Freeze Rows","Highlight Rows","Duplicate Rows"],"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":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"VBA Rows"]
[]
[null,"Learn the methods to Select, Insert, Count, Adjust Row Height, Hide/Unhide, Group/Ungroup, and Delete Rows using VBA in Excel. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By","Sishir Roy"]
[null,"Reviewed By","Seemanto Saha",null,"A.N.M. Mohaimen Shanto"]
[null,"Last Update","2023-11-15"]
[null,"Article Link","How to Work with Rows Using VBA in Excel"]
[]
[null,"Examples"]
[null,"How to Select Rows Using VBA in Excel"]
[null,"   Selecting Entire Row"]
[null,"   Selecting Rows in a Range"]
[null,"How to Insert Rows in Excel with VBA"]
[null,"   Inserting Row"]
[null,"   Inserting Row and Copying Formula"]
[null,"How to Set Row Height in Excel VBA"]
[null,"   Setting Row Height Based on User Input"]
[null,"   Autofitting Row Height"]
[null,"How to Count Rows in Excel VBA"]
[null,"   Counting Rows in a Range"]
[null,"   Counting Rows in a Range with Data"]
[null,"How to Copy Paste Rows with Excel VBA"]
[null,"How to Hide and Unhide Rows in Excel VBA"]
[null,"   Hiding Rows"]
[null,"   Unhiding Rows"]
[null,"How to Group and Ungroup Rows in Excel VBA"]
[null,"   Grouping Rows"]
[null,"   Ungrouping Rows"]
[null,"How to Delete Rows in Excel VBA"]
[null,"   Deleting Rows"]
[null,"   Deleting Rows Based on criteria"]
[null,"How to Freeze Rows Using VBA in Excel"]
[null,"How to Use VBA for Highlighting Rows That Meet a Certain Condition"]
[null,"How to Find Duplicate Rows with VBA in Excel"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Select Row","index":1,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Selecting Entire Row",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Select Row in Range","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Selecting Rows in a Range",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Insert Row","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Inserting Row",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,null,null,null,null,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,null,null,null,null,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5195-2","Alex Grayson",43,859.14]
[null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Insert Row and Copy Formula","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Inserting Rows and Copying Formula",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Retail Price","Discount (10%)","Discounted Price",null,null,null,"Order No","Customer Name","Retail Price","Discount (10%)","Discounted Price"]
[null,"5071-1","Christopher Schild",100.57299999999999,{"$f":"D6*0.1","v":10.0573},{"$f":"D6-E6","v":90.515699999999995},null,null,null,"5071-1","Christopher Schild",100.57299999999999,{"$f":"L6*0.1","v":10.0573},{"$f":"L6-M6","v":90.515699999999995}]
[null,"5071-2","Christopher Schild",14.696,{"$f":"D7*0.1","v":1.4696},{"$f":"D7-E7","v":13.2264},null,null,null,"5071-2","Christopher Schild",14.696,{"$f":"L7*0.1","v":1.4696},{"$f":"L7-M7","v":13.2264}]
[null,"5145-1","Cyma Kinney",65.697999999999993,6.5697999999999999,59.128199999999993,null,null,null,"5145-1","Cyma Kinney",65.697999999999993,6.5697999999999999,59.128199999999993]
[null,"5145-2","Cyma Kinney",25.695999999999998,2.5695999999999999,23.126399999999997,null,null,null,"5145-2","Cyma Kinney",25.695999999999998,2.5695999999999999,23.126399999999997]
[null,"5160-2","Berenike Kampe",154.44,15.444000000000001,138.99600000000001,null,null,null,"5160-2","Berenike Kampe",154.44,15.444000000000001,138.99600000000001]
[null,null,null,null,0,0,null,null,null,"5195-1","Alex Grayson",34.847999999999999,3.4847999999999999,31.363199999999999]
[null,null,null,null,0,0,null,null,null,"5195-2","Alex Grayson",945.05399999999997,94.505400000000009,850.54859999999996]
[null,"5168-1","Christy Brittain",142.34,14.234000000000002,128.10599999999999,null,null,null,"5168-1","Christy Brittain",142.34,14.234000000000002,128.10599999999999]
[null,"5168-2","Christy Brittain",121.83599999999998,12.183599999999998,109.65239999999999,null,null,null,"5168-2","Christy Brittain",121.83599999999998,12.183599999999998,109.65239999999999]
[null,"5195-1","Alex Grayson",34.847999999999999,3.4847999999999999,31.363199999999999]
[null,"5195-2","Alex Grayson",945.05399999999997,94.505400000000009,850.54859999999996]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Set Row Height","index":5,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Setting Row Height Based on User Input",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Autofit Row Height","index":6,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Autofitting Row Height",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Count Rows","index":7,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Counting Rows in a Range",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Count Non-empty Rows","index":8,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Counting Rows in a Range with Data",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[]
[null,"5145-2","Cyma Kinney",4,23.36]
[null,null,null,null,null,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[]
[null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Copy Paste Rows","index":9,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Copying and Pasting Rows",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,"Order No","Customer Name",null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,"5071-1","Christopher Schild",null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,"5071-2","Christopher Schild",null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,"5145-1","Cyma Kinney",null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,"5145-2","Cyma Kinney",null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Hide Rows","index":10,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Hiding Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Unhide Rows","index":11,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Unhiding Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Group Rows","index":12,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Grouping Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Ungroup Rows","index":13,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Ungrouping Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Delete Rows","index":14,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Deleting Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,null,null,null,null,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,null,null,null,null,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,null,null,null,null,null,null,null,"5195-2","Alex Grayson",43,859.14]
[null,"Back to Home Page"]

{"sheet":"Delete Rows with Criteria","index":15,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Deleting Rows Based on Criteria",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,null,null,null,null,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,null,null,null,null,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,null,null,null,null,null,null,null,"5195-2","Alex Grayson",43,859.14]
[null,"Back to Home Page"]

{"sheet":"Freeze Rows","index":16,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Freezing Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5146-2","Cyma Kinney",14,204.56,null,null,null,"5146-2","Cyma Kinney",14,204.56]
[null,"5162-1","Berenike Kampe",50,960.59,null,null,null,"5162-1","Berenike Kampe",50,960.59]
[null,"5164-2","Berenike Kampe",30,240.4,null,null,null,"5164-2","Berenike Kampe",30,240.4]
[null,"5166-1","Christy Brittain",28,128.5,null,null,null,"5166-1","Christy Brittain",28,128.5]
[null,"5170-2","Christy Brittain",48,115.76,null,null,null,"5170-2","Christy Brittain",48,115.76]
[null,"5190-1","Alex Grayson",31,100.68,null,null,null,"5190-1","Alex Grayson",31,100.68]
[null,"5148-2","Cyma Kinney",40,163.36000000000001,null,null,null,"5148-2","Cyma Kinney",40,163.36000000000001]
[null,"5165-1","Berenike Kampe",55,970.8,null,null,null,"5165-1","Berenike Kampe",55,970.8]
[null,"5180-2","Berenike Kampe",36,160.80000000000001,null,null,null,"5180-2","Berenike Kampe",36,160.80000000000001]
[null,"5178-1","Christy Brittain",20,229.2,null,null,null,"5178-1","Christy Brittain",20,229.2]
[null,"5165-2","Christy Brittain",35,210.76,null,null,null,"5165-2","Christy Brittain",35,210.76]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Highlight Rows","index":17,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Highlighting Rows That Meet a Certain Condition",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5145-1","Cyma Kinney",1,5.18,null,null,null,"5145-1","Cyma Kinney",1,5.18]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5168-2","Christy Brittain",39,110.75999999999999,null,null,null,"5168-2","Christy Brittain",39,110.75999999999999]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Duplicate Rows","index":18,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"VBA Rows"]
[]
[null,"Finding Duplicate Rows",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No","Customer Name","Order Quantity","Total Price",null,null,null,"Order No","Customer Name","Order Quantity","Total Price"]
[null,"5071-1","Christopher Schild",41,91.429999999999993,null,null,null,"5071-1","Christopher Schild",41,91.429999999999993]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[null,"5145-2","Cyma Kinney",4,23.36,null,null,null,"5145-2","Cyma Kinney",4,23.36]
[null,"5160-1","Berenike Kampe",41,860.58999999999992,null,null,null,"5160-1","Berenike Kampe",41,860.58999999999992]
[null,"5160-2","Berenike Kampe",26,140.4,null,null,null,"5160-2","Berenike Kampe",26,140.4]
[null,"5168-1","Christy Brittain",20,129.4,null,null,null,"5168-1","Christy Brittain",20,129.4]
[null,"5071-2","Christopher Schild",2,13.36,null,null,null,"5071-2","Christopher Schild",2,13.36]
[null,"5195-1","Alex Grayson",11,31.68,null,null,null,"5195-1","Alex Grayson",11,31.68]
[null,"5195-2","Alex Grayson",43,859.14,null,null,null,"5195-2","Alex Grayson",43,859.14]
[]
[]
[]
[null,"Back to Home Page"]