How to Select Interval Rows or Columns in Excel Office 365?
Tags: kutoolsexceltutorial, selectintervalrowsor, kutools
Published: 2020-10-17 07:29:52

---
title: How to Select Interval Rows or Columns in Excel Office 365?
published: true
date: 2020-10-17 07:29:10 UTC
tags: KutoolsExcelTutorial,SelectIntervalRowsor,Kutools
canonical_url: https://geekexcel.com/how-to-select-interval-rows-or-columns-in-excel-office-365/
---

In this tutorial, we will guide you to learn how to **Select Interval Rows or Columns in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Select Every Other Row:

- First, you need to **select the range** that you want to select every other row in the spreadsheet.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-21.png)<figcaption id="caption-attachment-15964">Select a range</figcaption>

- On the **Kutools Tab, select** the **Select** option, and **choose** the **Select Interval Rows & Columns** option using the drop-down list.

![Select the Select Interval Rows & Columns option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Select-Interval-Rows-Columns-option.png)<figcaption id="caption-attachment-15965">Select the Select Interval Rows &amp; Columns option</figcaption>

- It will open the **Select Interval Rows & Columns dialog box**.
- In that dialog box, **select** the **Rows** option, and **specify** the **number** of **intervals** in the Interval of option using the given drop-down list.
- Then, **enter** the **number** into the **Rows** box.

![Select Interval Rows & Columns dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Interval-Rows-Columns-dialog-box.png)<figcaption id="caption-attachment-15966">Select Interval Rows &amp; Columns dialog box</figcaption>

- **Hit** the **OK** button to see the result as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-24.png)<figcaption id="caption-attachment-15967">Result</figcaption>

## Steps to Select Every Other Column:

- You need to **select the range** that you want to select every other column.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-21.png)<figcaption id="caption-attachment-15964">Select a range</figcaption>

- On the **Kutools Tab, select** the **Select** option, and **choose** the **Select Interval Rows & Columns** option using the drop-down list.

![Select the Select Interval Rows & Columns option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Select-Interval-Rows-Columns-option.png)<figcaption id="caption-attachment-15965">Select the Select Interval Rows &amp; Columns option</figcaption>

- It will open the **Select Interval Rows & Columns dialog box**.
- In that dialog box, **select** the **Columns** option, and **specify** the **number** of **intervals** in the Interval of option using the given drop-down list.
- Then, **enter** the **number** into the **Columns** box.

![Select Interval Rows & Columns dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-16.png)<figcaption id="caption-attachment-15968">Select Interval Rows &amp; Columns dialog box</figcaption>

- **Click** the **OK** button to see the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-34.png)<figcaption id="caption-attachment-15969">Output</figcaption>

## End of the Article:

In this tutorial, we guided you to learn the steps to **Select Interval Rows or Columns in Excel Office 365** using **Kutools. ** Give your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Insert a Monthly or a Yearly Calendar in Excel](https://geekexcel.com/how-to-insert-a-monthly-or-a-yearly-calendar-in-excel-office-365/)
- [Unmerge Cells and Fill Down Values in Excel](https://geekexcel.com/how-to-unmerge-cells-and-fill-down-values-in-excel-office-365/)