How to Sort Data from Left to Right in Excel (Sort Horizontally)
25.3 هزار بار بازدید -
5 سال پیش
-
In this video, learn how
In this video, learn how to sort data from left to right in Excel.
Mostly we get datasets that are arranged in columns (with headers in a row). This is the top to a bottom format which most of us are used to. And when you sort this data, you sort it from top to bottom.
But sometimes, you may have to work with data which is on rows (i.e., the headers are in a column). And if you want to sort this data, you will have to sort it from left to right (sort horizontally).
In this video, I show two ways of sorting the data in Excel from left to right:
1. Using the inbuilt left to right sorting feature in Excel
2. By first copying and transposing the data, sorting it from top to bottom, and then copying and transposing it back again.
While using the inbuilt left-to-right sort feature is more convenient, a lot of people prefer transposing it as they are used to top to bottom data format.
I also cover how to create custom sorting criteria in Excel. For example, when you sort the data by region from left to right, you end up with - East, North, South, and West.
This is because the data has been sorted alphabetically.
But what if you want to sort it in the following order - East, West, North, South.
To do this, you need to create a custom sorting criteria which you can then use to sort the data (left to right or top to bottom both).
You can read more about sorting data in Excel here: https://trumpexcel.com/sort-excel/
#Excel #ExcelTips #ExcelTutorial
Mostly we get datasets that are arranged in columns (with headers in a row). This is the top to a bottom format which most of us are used to. And when you sort this data, you sort it from top to bottom.
But sometimes, you may have to work with data which is on rows (i.e., the headers are in a column). And if you want to sort this data, you will have to sort it from left to right (sort horizontally).
In this video, I show two ways of sorting the data in Excel from left to right:
1. Using the inbuilt left to right sorting feature in Excel
2. By first copying and transposing the data, sorting it from top to bottom, and then copying and transposing it back again.
While using the inbuilt left-to-right sort feature is more convenient, a lot of people prefer transposing it as they are used to top to bottom data format.
I also cover how to create custom sorting criteria in Excel. For example, when you sort the data by region from left to right, you end up with - East, North, South, and West.
This is because the data has been sorted alphabetically.
But what if you want to sort it in the following order - East, West, North, South.
To do this, you need to create a custom sorting criteria which you can then use to sort the data (left to right or top to bottom both).
You can read more about sorting data in Excel here: https://trumpexcel.com/sort-excel/
#Excel #ExcelTips #ExcelTutorial
5 سال پیش
در تاریخ 1398/04/11 منتشر شده
است.
25,357
بـار بازدید شده