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

  • 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.

Home
HOME           PRODUCTS           EULA           AFFILIATES           SUPPORT           ABOUT US
  • Click DOSE Select Select Interval Rows / Columns
Dose for Excel

Dose for Excel adds more than +100 new features and functions to your Excel.
Supported Excel versions: 2016, 2013, 2010, 2007 and Office 365. Free download and use for 14 days.

Dose for Excel
Dose for Excel
 

Copyright 2014 - 2018 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns

 
  • 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.

 
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns
Excel Select Interval Rows / Columns