{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Sales Dataset","Using Filter","Conditional Format","Using Highlight ODD","Using Highlight EVEN","Keyboard and Mouse","Go To Special","VBA","Format Table","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sales Dataset","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"How to Select Every Other Row in Excel"]
[]
[null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Using Filter","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,10]]}
[null,"Using Filter to Select Every Other Row",null,null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales","Row Even/Odd",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,{"$f":"ISEVEN(ROW())","v":true},null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,{"$f":"ISEVEN(ROW())","v":false},null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,{"$f":"ISEVEN(ROW())","v":true},null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,false,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,true,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,false,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,true,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,false,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,true,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,false,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Conditional Format","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null,"Using Conditional Formatting to Select Every Other Row",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Using Highlight ODD","index":3,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null,"Using Highlight to Select Every Other Row ",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Using Highlight EVEN","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null," Select Every Other Row Overview",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Keyboard and Mouse","index":5,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null,"Using Keyboard and Mouse to Select Every Other Row ",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Go To Special","index":6,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null,"Using GO To Special to Select Every Other Row",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"VBA","index":7,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null,"Using VBA to Select Every Other Row ",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Format Table","index":8,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9]]}
[null,"Using Table to Select Every Other Row",null,null,null,null,"Do Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales",null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800,null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700,null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780,null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040,null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100,null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500,null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000,null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500,null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000,null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000,null,"Penny","Las Vegas","Smartwatch",2000]

{"sheet":"Practice Sheet","index":9,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Do it Yourself"]
[]
[null,"Sales Rep","Region"," Product","Sales"]
[null,"Ahmed ","New York","Games",16800]
[null,"Victor","Los Angeles","Applewatch",18700]
[null,"Alekxander","Chicago","Iphone",45780]
[null,"Rose","Houston","Laptop",9040]
[null,"Jim","San Antonio","Ipad",10100]
[null,"Steve","Dallas","Computer",24500]
[null,"Jerry","Austin","Macbook",50000]
[null,"Rodney","Denver","Smartphone",5500]
[null,"Alan","Boston","Laptop",20000]
[null,"Penny","Las Vegas","Smartwatch",2000]