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

Watch on YouTube

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