Bob has a two-row data set with sales from different countries arranged across the columns. He wants the country with the largest sales to appear first. Episode 1782 shows you how to sort data left-to-right.
Transcript of the video:
This MrExcel podcast is sponsored by Easy-XL.
Learn Excel From MrExcel, Podcast Episode 1782: Sort Left To Right.
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
Today's question is sent in by Bob. Bob, as you may remember, is my brother.
He knows just enough about Excel to be dangerous.
He calls up, he says, well, I got this really small spreadsheet today, lists all of these regions and sales by regions, and I need to sort the data so that way the largest country is first.
How can I rearrange all of these columns?
I was like this is actually very easy to do although it is very, very hidden.
So, we're going to select the range like that.
So, we have a 2-row by several columns selection.
We’re going to click the SORT icon, and very first thing, click the OPTIONS button, and we're going to say we're not going to SORT TOP TO BOTTOM as usual, we're going to SORT LEFT TO RIGHT, click OK, and then we'll take a look at our data.
We want to SORT BY the second row.
So, see, we have row 1, row 2, and we want to sort LARGEST TO SMALLEST, like that, click OK.
Now, the one huge “got you” after you do this is the data is rearranged but the column widths are not rearranged.
So, normally, when we do a sort or we’re sorting rows, most rows are the same height and we never have this problem, but the columns are often different.
So, we want to come out here to HOME, FORMAT, AUTOFIT COLUMN WIDTH to get the columns to fit again.
You know, probably a little bit of additional formatting, center, or right justify, or whichever, but the real trick here, how to sort left to right this really small data set of headings and sales, just 2 rows, and needing to sort that.
Okay.
Well, hey.
I want to thank Bob for phoning that question in and I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
Learn Excel From MrExcel, Podcast Episode 1782: Sort Left To Right.
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
Today's question is sent in by Bob. Bob, as you may remember, is my brother.
He knows just enough about Excel to be dangerous.
He calls up, he says, well, I got this really small spreadsheet today, lists all of these regions and sales by regions, and I need to sort the data so that way the largest country is first.
How can I rearrange all of these columns?
I was like this is actually very easy to do although it is very, very hidden.
So, we're going to select the range like that.
So, we have a 2-row by several columns selection.
We’re going to click the SORT icon, and very first thing, click the OPTIONS button, and we're going to say we're not going to SORT TOP TO BOTTOM as usual, we're going to SORT LEFT TO RIGHT, click OK, and then we'll take a look at our data.
We want to SORT BY the second row.
So, see, we have row 1, row 2, and we want to sort LARGEST TO SMALLEST, like that, click OK.
Now, the one huge “got you” after you do this is the data is rearranged but the column widths are not rearranged.
So, normally, when we do a sort or we’re sorting rows, most rows are the same height and we never have this problem, but the columns are often different.
So, we want to come out here to HOME, FORMAT, AUTOFIT COLUMN WIDTH to get the columns to fit again.
You know, probably a little bit of additional formatting, center, or right justify, or whichever, but the real trick here, how to sort left to right this really small data set of headings and sales, just 2 rows, and needing to sort that.
Okay.
Well, hey.
I want to thank Bob for phoning that question in and I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
