How to Select Interval Rows or Columns in Excel

Select Interval Rows Or Columns In Excel

Easily select interval rows or columns, for example, select each 2 rows every an interval of 3 rows, this will select 2 rows and then skip 3 rows then select 2 rows again and so on until the end of the selected range. Dose for Excel‘s Select Interval Rows / Columns utility can quickly do the task.

• Select every other rows
• Select every other columns

Click DOSE » Select » Select Interval Rows / Columns

Demo: Select Interval Rows or Columns in Excel

Select Every Other Rows

1. Select a range of cells.
2. And then apply this function by clicking on DOSE » Select » Select Interval Rows / Columns. For example, if you want to select 2 rows every 3 rows in a range then enter 3 in the Interval of box and 2 in rows box.
3. Then click on Apply. See screenshots.

Select Every Other Columns

1. Select a range of cells.
2. And then apply this function by clicking on DOSE » Select » Select Interval Rows / Columns. For example, if you want to select 1 column every 1 column in a range then enter 1 in the Interval of box and 1 in columns box.
3. Then click on Apply. See screenshots.