How to Select Interval Rows or Columns in Excel

Select Interval Rows Or Columns In Excel

Convert Numbers To Words 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.

Click DOSE » Select » Select Interval Rows / Columns

How to Select Interval Rows or Columns in Excel

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.
How to Select Interval Rows or Columns in Excel

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.
How to Select Interval Rows or Columns in Excel

More Features:

Excel Color Duplicates

Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…

Excel Count Chars

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

Excel Sort Sheets

Sort Sheets by alphanumeric or date In Excel Sort your sheets in your current workbook…


Scroll to Top