Select interval (every other) rows or columns in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
In Excel, you can manually select interval or every other rows or columns with holding the Ctrl key. But if you have thousands of rows in a worksheet, this method will be very troublesome and time consuming. Excel doesn't support you an option to quickly select interval rows or columns with one click. But Kutools for Excel's Select Interval Rows & Columns utility can quickly select interval rows or columns in Excel.
Quickly select every other row
Quickly select every other column
Click Kutools >> Select >> Select Interval Rows & Columns. See screenshots:
Quickly select every other rows
1. Select the range that you want to select every other rows.
2. Go to the Select Interval Rows & Columns dialog box, and check Rows option, then enter the specified number into the Interval of box, and enter the number into Rows box. Tip: For example, if you want to select every 2 rows after each 2 rows in a range, please enter 2 in the Interval of box and enter 2 in the Rows box.
3. Then click Ok. You will see the result as shown in the below screenshot.
Quickly select every other columns
1. Use the 
button to select the range that you want to select every other columns.
2. In the Select Interval Rows & Columns dialog box, please specify Columns from Select option. Then specify the Interval of option and Columns option. Tip: If you want to select each column after one column, please type in 1 in the Interval of box and type in 1 in the Columns box. See screenshot:
3. And then click OK button, and every other column have been selected in the range as shown in the below screenshot.
Note:
If you check Select entire columns, you can quickly highlight the entire selected rows or columns.
Demo: Select Inteval Rows or Columns
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
