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

Demo: Select Interval Rows or Columns in Excel
Select Every Other Rows
- Select a range of cells.
- 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.
- Then click on Apply. See screenshots.

Select Every Other Columns
- Select a range of cells.
- 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.
- Then click on Apply. See screenshots.

More Features:
Excel Sort Sheets
Sort Sheets by alphanumeric or date In Excel Sort your sheets in your current workbook…
Excel Delete Rows
Excel Highlight Or Delete Any Type Of Rows Highlight or delete items that are identical,…
Excel Remove Or Replace Comments
Advanced Comments Assistant For Excel If you ever want to remove comments or replace them…
Excel Batch Delete Check Boxes
Excel Batch Delete Check Boxes In Excel Batch deleting check boxes in selected cells without…
How To Convert Numbers To Words In Excel
Convert numbers to words in Excel Converting numerical values into words in Excel holds significant…
Excel Delete Blank Sheets
Delete All Empty Worksheets Excel Delete all blank or empty sheets in Excel one time…