Excel Select Interval Rows Columns

Select Interval Rows Or Columns In Excel

Easily select rows or columns at a certain interval, 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.

Click DOSE » Select » Select Interval Rows / Columns


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.

More Features:

Excel Export Sheets

Export Sheets Separately In Different Formats In Excel Exporting from sheets from Excel using Excel…

Excel Count Chars

Count Chars In Excel Count chars in a cell or in a selected range of…

Excel Random Generator

Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…

Excel Insert Empty

Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…

Excel Change Case

Change Case Of Excel Cells Text Change case of text in selected cells in Excel…


Scroll to Top