Reshape Your Data Instantly in Excel with CHOOSECOLS & CHOOSEROWS

If you’ve ever found yourself spending way too much time manually moving columns around or using complex formulas to extract specific rows in Excel, this post is for you.

Microsoft Excel 365 introduced two game-changing functions—CHOOSECOLS and CHOOSEROWS—and they’re absolute time-savers.

🔍 What Are CHOOSECOLS and CHOOSEROWS?

• CHOOSECOLS(range, col1, [col2], …) allows you to instantly pull specific columns from a data range—in any order you want.

• CHOOSEROWS(range, row1, [row2], …) does the same for rows.

  
  

Together, they give you complete control over your table layout—perfect for reporting, cleaning up datasets, or creating customized exports.

▶️ Watch the Full Walkthrough

To see these functions in action, check out my latest YouTube video:

In the video, I walk through:

✅ How to rearrange columns without touching your original data

✅ Selecting specific rows based on position

✅ Real-world examples that you can apply immediately

✅ How these functions compare to alternatives like INDEX, FILTER, and VBA

EXERCISE FILE DOWNLOAD:

SalesData-01.xlsx

Download XLSX • 12KB