From the course: Excel 2016: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Sorting columns (sorting left-to-right)

Sorting columns (sorting left-to-right)

From the course: Excel 2016: Managing and Analyzing Data

Start my 1-month free trial

Sorting columns (sorting left-to-right)

“

- Sorting nearly always means moving rows up or down, but here's a worksheet called Column Sort where we actually want to move columns left and right. We like to alphabetize the list. In other words, as we're looking at the cities here, we like to have Albuquerque over here in column B, and then it looks like maybe we have Boston possibly, yeah, then Boston, Chicago, and so on. We can move the columns left to right. We can certainly drag them that way, but we've get too many columns to do that. We can actually sort by moving data left and right. Now, in the example here, we do not want to change column A at all. It's going to stay static, unchanged, but we do need to highlight the data. In the example here, the list, which goes down to row 31, we can either highlight the data this way or simply drag across the column letters. That's even easier, makes no difference whether this goes down to the bottom of the worksheet or not. This is what we want to sort by moving the data left and…

Contents