{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Select columns - examples","Select columns with formula","Macro-select alternate columns","Macro - select every Nth column"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"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 columns - examples","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,2],[5,1,5,2],[8,2,8,3]]}
[]
[]
[]
[null,"Select Every Other or Every Nth Column in Excel"]
[]
[null,"The workbook shows how to efficiently select alternate columns or every Nth column in Excel with formula and VBA."]
[null,null,"Ablebits.com"]
[null,"Last update","2023-07-14"]
[null,"Tutorial URL","How to select every other or every nth column in Excel"]
[]
[null,"Examples:"]
["• ","Select every other or every Nth column with formula "]
["• ","VBA to select every other column"]
["• ","VBA to select every nth column "]
[]
[null,"The workbook contains the following macros:"]
[null,"SelectOddColumns - selects every odd column."]
[null,"SelectEvenColumns- selects every even column."]
[null,"SelectEveryNColumn - selects every Nth column 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 columns."]
[null,"3. In your workbook, select the target range."]
[null,"3. Press Alt + F8, choose the desired macro, and click Run."]

{"sheet":"Select columns with formula","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Select every other column using formula"]
["Item","Biology","Chemistry","English","History","Math",null,{"$f":"_xlfn.CHOOSECOLS(A2:F20,2,4,6)","v":"Biology"},"English","Math"]
["Adeline",80,83,59,78,97,null,80,59,97]
["Aiden",65,65,80,94,87,null,65,80,87]
["Anna",67,63,88,74,92,null,67,88,92]
["Ava",82,73,90,59,61,null,82,90,61]
["Camilla",80,86,90,72,83,null,80,90,83]
["Elena",73,71,81,67,71,null,73,81,71]
["Emma",96,58,62,95,80,null,96,62,80]
["Ethan",85,87,84,65,86,null,85,84,86]
["Grace",83,92,94,59,64,null,83,94,64]
["Liam",71,63,82,59,63,null,71,82,63]
["Lillian",96,73,81,87,58,null,96,81,58]
["Lucas",85,93,86,69,69,null,85,86,69]
["Maria",77,95,79,79,60,null,77,79,60]
["Noah",58,67,85,94,67,null,58,85,67]
["Olivia",71,63,62,62,77,null,71,62,77]
["Scarlett",98,59,87,89,74,null,98,87,74]
["Sophia",88,85,59,83,75,null,88,59,75]
["Victoria",65,83,60,97,59,null,65,60,59]

{"sheet":"Macro-select alternate columns","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Item","Biology","Chemistry","English","History","Math"]
["Adeline",80,83,59,78,97,null,"How to select every Nth column using a macro:"]
["Aiden",65,65,80,94,87]
["Anna",67,63,88,74,92,null,"1. Select the range A2:F20."]
["Ava",82,73,90,59,61,null,"2. Press Alt + F8 to open the macro dialog box."]
["Camilla",80,86,90,72,83,null,"3. Select the desired macro - SelectOddColumns or SelectEvenColumns ."]
["Elena",73,71,81,67,71,null,"4. Click Run to execute the code."]
["Emma",96,58,62,95,80]
["Ethan",85,87,84,65,86]
["Grace",83,92,94,59,64]
["Liam",71,63,82,59,63]
["Lillian",96,73,81,87,58]
["Lucas",85,93,86,69,69]
["Maria",77,95,79,79,60]
["Noah",58,67,85,94,67]
["Olivia",71,63,62,62,77]
["Scarlett",98,59,87,89,74]
["Sophia",88,85,59,83,75]
["Victoria",65,83,60,97,59]

{"sheet":"Macro - select every Nth column","index":3,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Item","Biology","Chemistry","English","History","Math"]
["Adeline",80,83,59,78,97,null,"How to select every other column using a macro:"]
["Aiden",65,65,80,94,87]
["Anna",67,63,88,74,92,null,"1. Select the range A2:F20."]
["Ava",82,73,90,59,61,null,"2. Press Alt + F8 to open the macro dialog box."]
["Camilla",80,86,90,72,83,null,"3. Select the SelectEveryNColumn macro."]
["Elena",73,71,81,67,71,null,"4. Click Run to execute the code."]
["Emma",96,58,62,95,80,null,"5. In the pop-up dialog box that appears, enter the value for N and click OK."]
["Ethan",85,87,84,65,86]
["Grace",83,92,94,59,64]
["Liam",71,63,82,59,63]
["Lillian",96,73,81,87,58]
["Lucas",85,93,86,69,69]
["Maria",77,95,79,79,60]
["Noah",58,67,85,94,67]
["Olivia",71,63,62,62,77]
["Scarlett",98,59,87,89,74]
["Sophia",88,85,59,83,75]
["Victoria",65,83,60,97,59]