Microsoft Excel: How to select alternate columns

This article will guide you step-by-step through the process of selecting specific columns in Excel, such as every other or every nth column.

Microsoft Excel, the go-to spreadsheet software for data enthusiasts and professionals, offers several methods to select columns based on specific criteria.

---

Select alternate columns in Excel

The simplest way to select alternate columns in Excel is by utilizing the Ctrl key in combination with the mouse. Here’s how you can do it:

1. Press and hold the Ctrl key on your keyboard.
2. While holding the Ctrl key, click on the header of every other column.
3. Repeat steps 2 and 3 until you have selected all the desired columns.
4. Release the Ctrl key.

As a result, you have the alternate columns selected:

By using the Ctrl key, you can handpick every 3^rd, every 4^th or every nth column, so you can apply formatting or perform calculations on specific sections of your data.

This method of selecting every other or every nth column is a straightforward and effective approach, particularly for small datasets. However, it may become cumbersome and time-consuming when dealing with large sets of data. Manually clicking on each column header can be prone to errors and can become tiresome. In such cases, alternative methods come in handy to streamline the process and save valuable time.

---

Selecting every other or nth column with a formula

If you prefer a more precise method to select every other or nth column in Excel, you can achieve this by using the CHOOSECOLS function. Here’s how you can use it:

1. In an empty cell, enter the CHOOSECOLS formula. The first argument should be the source range that contains the columns you want to select.
2. In the subsequent arguments, provide the column numbers you want to return.
3. Press Enter to apply the formula.

For example, to select every even column in the range A2:F20, the formula takes this form:

=CHOOSECOLS(A2:F20, 2, 4, 6)

This formula specifies that you want to return columns 2, 4, and 6 from the range A2:F20.

The CHOOSECOLS formula returns the specified columns as a dynamic array, which you can easily select and copy to another part of your worksheet.