{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Select rows- examples","Select every other row","Select every nth row","Select every other rows VBA","Select every nth rows VBA"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"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":"Select rows- examples","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,2],[5,1,5,2],[8,2,8,3]]}
[]
[]
[]
[null,"Select Every Other or Every Nth Row in Excel"]
[]
[null,"The workbook shows how to efficiently select every other row or every Nth row in Excel with filtering and VBA."]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-06-21"]
[null,"Tutorial URL","How to select every other row or every nth row in Excel"]
[]
[null,"Examples:"]
["• ","Filter and select every other row "]
["• ","Filter and select every Nth row "]
["• ","VBA to select every other row"]
["• ","VBA to select every nth row "]
[]
[null,"The workbook contains the following macros:"]
[null,"SelectOddRows - selects every odd row."]
[null,"SelectEvenRows- selects every even row."]
[null,"SelectEveryNRow - selects every Nth rows that you specify."]
[]
[null,"How to use the macros:"]
[null,"1. Keep this workbook open."]
[null,"2. Open your own workbook in which you want to select rows."]
[null,"3. In your workbook, select the target range."]
[null,"3. Press Alt + F8, choose the desired macro, and click Run."]

{"sheet":"Select every other row","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Select every other row in Excel"]
["Item","Biology","English","History","Math","Helper",null,"Instructions:"]
["Adeline",80,83,59,78,{"$f":"ISODD(ROW())","v":true},null,"1. In the Helper column, filter TRUE to display odd rows and FALSE to display even rows."]
["Aiden",65,65,80,94,{"$f":"ISODD(ROW())","v":false},null,"2. Select the filtered rows. Only visible cells will get selected."]
["Anna",67,63,88,74,true]
["Ava",82,73,90,59,false]
["Camilla",80,86,90,72,true]
["Elena",73,71,81,67,false]
["Emma",96,58,62,95,true]
["Ethan",85,87,84,65,false]
["Grace",83,92,94,59,true]
["Liam",71,63,82,59,false]
["Lillian",96,73,81,87,true]
["Lucas",85,93,86,69,false]
["Maria",77,95,79,79,true]
["Noah",58,67,85,94,false]
["Olivia",71,63,62,62,true]
["Scarlett",98,59,87,89,false]
["Sophia",88,85,59,83,true]
["Victoria",65,83,60,97,false]

{"sheet":"Select every nth row","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Selecting every Nth row in Excel"]
["Item","Biology","English","History","Math","Helper",null,"Instructions:"]
["Adeline",80,83,59,78,{"$f":"MOD(ROW() - 2, 4)","v":1},null,"1. In the Helper column, filter 0 values that correspond to every 4th row."]
["Aiden",65,65,80,94,{"$f":"MOD(ROW() - 2, 4)","v":2},null,"2. Select the filtered rows. Only visible cells will get selected."]
["Anna",67,63,88,74,3]
["Ava",82,73,90,59,0]
["Camilla",80,86,90,72,1]
["Elena",73,71,81,67,2]
["Emma",96,58,62,95,3]
["Ethan",85,87,84,65,0]
["Grace",83,92,94,59,1]
["Liam",71,63,82,59,2]
["Lillian",96,73,81,87,3]
["Lucas",85,93,86,69,0]
["Maria",77,95,79,79,1]
["Noah",58,67,85,94,2]
["Olivia",71,63,62,62,3]
["Scarlett",98,59,87,89,0]
["Sophia",88,85,59,83,1]
["Victoria",65,83,60,97,2]

{"sheet":"Select every other rows VBA","index":3,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Select every other row using VBA"]
["Item","Biology","English","History","Math",null,"Instructions:"]
["Adeline",80,83,59,78,null,"1. Select the range A3:E20."]
["Aiden",65,65,80,94,null,"2. Press Alt + F8 to open the macro dialog box."]
["Anna",67,63,88,74,null,"3. Select the desired macro - SelectOddRows or SelectEvenRows."]
["Ava",82,73,90,59,null,"4. Click Run to execute the code."]
["Camilla",80,86,90,72]
["Elena",73,71,81,67]
["Emma",96,58,62,95]
["Ethan",85,87,84,65]
["Grace",83,92,94,59]
["Liam",71,63,82,59]
["Lillian",96,73,81,87]
["Lucas",85,93,86,69]
["Maria",77,95,79,79]
["Noah",58,67,85,94]
["Olivia",71,63,62,62]
["Scarlett",98,59,87,89]
["Sophia",88,85,59,83]
["Victoria",65,83,60,97]

{"sheet":"Select every nth rows VBA","index":4,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Select every Nth row using VBA"]
["Item","Biology","English","History","Math",null,"Instructions:"]
["Adeline",80,83,59,78,null,"1. Select the range A3:E20."]
["Aiden",65,65,80,94,null,"2. Press Alt + F8 to open the macro dialog box."]
["Anna",67,63,88,74,null,"3. Select the SelectEveryNRow macro."]
["Ava",82,73,90,59,null,"4. Click Run to execute the code."]
["Camilla",80,86,90,72,null,"5. In the pop-up dialog box that appear, enter the value for N and click OK."]
["Elena",73,71,81,67]
["Emma",96,58,62,95]
["Ethan",85,87,84,65]
["Grace",83,92,94,59]
["Liam",71,63,82,59]
["Lillian",96,73,81,87]
["Lucas",85,93,86,69]
["Maria",77,95,79,79]
["Noah",58,67,85,94]
["Olivia",71,63,62,62]
["Scarlett",98,59,87,89]
["Sophia",88,85,59,83]
["Victoria",65,83,60,97]