Learn Excel - Sort Left to Right - Podcast #1782

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Sep 3, 2013.
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.
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top