Excel - How To Sort Left To Right In Excel - Episode 1782
962 views · Published 3 September 2013 · 1:51 · Indexed 14 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Sort left to right in Excel. Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing how to sort data from left to right in Excel. This may seem like a simple task, but it can be quite tricky if you don't know the right steps. This question was sent in by Bob, who happens to be my brother and knows just enough about Excel to be dangerous. Bob had a small spreadsheet with a list of regions and sales by region, and he needed to rearrange the columns so that the largest country was listed first. This may seem like a common task, but it can be challenging to do in Excel. However, with the right steps, it can be done easily. We will be using the SORT function, but with a twist. To sort data from left to right, we first need to select the range of data we want to sort. In this case, it is a 2-row by several columns selection. Then, we click on the SORT icon and select the OPTIONS button. Here, we will choose to sort from LEFT TO RIGHT instead of the usual TOP TO BOTTOM. Once we click OK, we can then choose which row we want to sort by and in what order. In this case, we want to sort by the second row, from LARGEST TO SMALLEST. One thing to keep in mind when sorting left to right is that the column widths will not automatically adjust. This can be a bit of a hassle, but we can easily fix it by going to HOME, FORMAT, and selecting AUTOFIT COLUMN WIDTH. This will adjust the column widths to fit the data properly. And there you have it, a simple and effective way to sort data from left to right in Excel. Thank you, Bob, for sending in this question, and thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe for more helpful tips and tricks for Excel. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Sort Left To Right in Excel (00:23) Regions & Sales going across (00:33) Sorting options for left to right (00:43) Sorting by second row (00:56) Need to adjust column widths (01:20) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelsorting This video answers these common search terms: how to sort left to right in excel how does sort left to right work in excel excel how to sort left to right how to sort data from left to right in excel how to sort an excel spreadsheet left to right 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. Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153603/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920