{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VBA to insert rows","Sample data"],"not_rendered":{"charts":0,"images":4,"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":"VBA to insert rows","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,2],[7,2,7,3]]}
[]
[]
[]
[null,"VBA to Insert Every Other Row in Excel"]
[]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-06-29"]
[null,"Tutorial URL","How to insert multiple rows in Excel "]
[]
[null,"The workbook contains the following macro:"]
[null,"InsertEveryOtherRow - inserts a blank row between every existing row in the selected range."]
[]
[null,"How to use the macros:"]
[null,"1. Keep this workbook open."]
[null,"2. Open your own workbook in which you want to insert rows."]
[null,"3. In your workbook, select the range where you want to add new rows."]
[null,"4. Press Alt + F8, select the InsertEveryOtherRow macro, and click Run."]

{"sheet":"Sample data","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ID","Description",null,"Price ","Vendor ID"]
["Int-0001","SR150Al, LGA771, S5000PAL, SVGA",null,1711,115812,null,"How to use the macro to insert every other column:"]
["Int-0002","RX5700XT, PCIe 4.0, GDDR6",null,1441,118823,null," "]
["Int-0003","RTX3070, 8GB VRAM, DisplayPort",null,1470,114045,null,"1. Select the range A1:D22."]
["Int-0004","Ryzen 9 5900X, AM4 socket",null,1572,114828,null,"2. Press Alt + F8 to open the macro dialog box."]
["Int-0005","DDR4-3600, 16GB RAM, CL18",null,1024,112378,null,"3. Choose the InsertEveryOtherRow macro."]
["Int-0006","Intel Core i7-10700K, LGA1200",null,825,116576,null,"4. Click Run to execute the code."]
["Int-0007","SATA III, 6Gb/s, 2.5\" SSD",null,1671,115385]
["Int-0008","USB 3.2 Gen 2, Type-A, 10Gbps",null,966,119148]
["Int-0009","27\" 1440p, IPS panel, 165Hz",null,1670,116120]
["Int-0010","Bluetooth 5.1, Low Energy",null,1450,113346]
["Int-0011","7.1 surround sound, Dolby Atmos",null,1693,119934]
["Int-0012","M.2 NVMe SSD, 1TB capacity",null,1712,113088]
["Int-0013","DDR3L-1600, 8GB SO-DIMM",null,1197,114602]
["Int-0014","Mini-ITX, SFF motherboard",null,1846,119164]
["Int-0015","DVI-D, Single Link, 1080p",null,1135,113636]
["Int-0016","HDMI 1.4b, 4K@30Hz support",null,1007,112158]
["Int-0017","LGA1151, 8th/9th Gen compatible",null,874,117585]
["Int-0018","USB Type-C, PD 3.0, 100W",null,1491,117492]
["Int-0019","SATA II, 3Gb/s, 3.5\" HDD",null,1621,117360]
["Int-0020","PCIe x16, 3.0, full-length",null,1774,112278]
["Int-0021","Gigabit Ethernet, RJ-45, 1000Mbps",null,1735,118734]