2.137 FAQ-1186 How to insert one row for every certain number of rows?

Last Update: 7/25/2023

To insert one row for every N rows,

  1. With the worksheet active, select menu Worksheet: Worksheet Query.
  2. In the Worksheet Query dialog that opens, enter following Condition 
    mod(i,N)=1&&i!=1
    to select every N rows. For example, if you want to insert one row for every 5 rows, enter 
    mod(i,5)=1&&i!=1
    in the Condition edit box.
  3. Click Test -- select if true button to test the condition. This will highlight every N rows.
  4. In the Output group, select Select radio button. Click OK button to close Worksheet Query.
    Insert Every N Rows FAQ1186 1.png
  5. Right click on any one of the selected rows and select Insert Row from the context menu. This will insert one row before each shighlighted row.
    Insert Every N Rows FAQ1186 2.png


  • You can insert one column for every certain number of columns in a similar way. For column selection, you can use menu Edit: Select.
  • You can also press Ctrl key and use mouse to select discontinuous rows or columns, and then use Insesrt button on the mini toolbar to insert row or column before each selection.
Insert Every N Rows FAQ1186 3.png

Keywords:insert rows, insert columns, evenly insert, select every spaced rows