Although not frequently needed, you can sort by rearranging the left or right…order of columns, instead of the much more common rearranging of rows from top to bottom.…As we look at this worksheet here, I think you could begin to see what we're headed for.…We might want to rearrange this data in such a way that our cities are…alphabetized from left to right.…Now, unlike the shortcuts we have seen with prior examples of sorting, we must…highlight all of the data in question here and select this data specifically.… This is what we want to rearrange.…We do not want to touch the data in column A at all.…We simply want to rearrange the column data as we see it.…We want Atlanta to be on the left- hand side, then Atlanta and so on.…We want these alphabetized.…So we must specifically highlight all the data and we must use the Sort…command on the Data tab.…Notice typically, this dialogue box has … the word column right here, … meaning we sort on the basis of what's in each column. … We're about to do this on the basis … of what's in that top row. … and then instead of sorting top to bottom … which is what we do most of the time. … We're about to sort left to right. … And now we see the word row right here. … And in this case here, … So before clicking okay, just take a quick look at the data. …
Microsoft Excel is a commercial Spreadsheet software designed by Microsoft. It is a component of the Microsoft Office and is often called simply Excel or MS Excel.
Download the workbook here:
Tags:
excel, data, sort, sort data, sort data in excel, menu, how to sort data in excel, excel sort data, MS Excel - Data Sorting, data sorting, Sorting Data, data sorting in excel in hindi, Sorting columns, sorting left to right, sort data from left to right in excel, sort left to right in excel, sort data left to right, sort left to right, excel sort data from left to right, How to Sort Data from Left to Right in Excel, Sort Data from Left to Right, Excel Sorting Left to Right
0 Yorumlar