You can use the **CHOOSECOLS** function in Excel to select every other column in a specific range.

For example, you can use the following formula to select every other column in the range **A1:G11**:

=CHOOSECOLS(A1:G11, {1,3,5,7})

The following example shows how to use this formula in practice.

**Example: Select Every Other Column in Excel**

Suppose we have the following dataset in Excel that contains information about various basketball players:

Suppose we would like to select every other column in this range.

We can type the following formula into cell **A14** to do so:

=CHOOSECOLS(A1:G11, {1,3,5,7})

The following screenshot shows how to use this formula in practice:

We can see that the **CHOOSECOLS** function returned columns in positions **1**, **3**, **5** and **7** from the range **A1:G11**.

This has the effect of selecting every other column in the range:

Since the first number that we specified in the **CHOOSECOLS** function was **1**, it returned every other column from the range starting with the first column.

If you would instead like to return every other column starting with the second column, you can use the following formula instead:

=CHOOSECOLS(A1:G11, {2,4,6})

The following screenshot shows how to use this formula in practice:

Notice that every other column in the range is selected, starting from the second column.

**Note**: You can find the complete documentation for the **CHOOSECOLS** function here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Select Every Other Row in Excel

How to Select Every Nth Row in Excel

How to Sum Every Nth Row in Excel