In the previous post, we saw ‘How to Create and Format-Table in the Microsoft Excel?’, now we will learn about how to Sort Data in a Table-Microsoft Excel?
Where to find The Sort & Filter option?
To find the Sort and filter option in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Home Tab’ (By default home tab is selected) and under ‘Editing Group’ click on the ‘Sort & Filter’

Select a cell within the data. Select Home > Sort & Filter.
Then select an option:
- Sort A to Z – sorts the selected column in an ascending order.
- Sort Z to A – sorts the selected column in a descending order.
- Custom Sort – sorts data in multiple columns by applying different sort criteria.Here’s how to do a custom sort:
- Select Custom Sort.
- Select Add Level.
Short Data in a Range or Table
Select a column and then select sort & filter and choose the option.
Click on the image

Select a column (Contain number) and then select sort & filter and choose the option.
Click on the image

To do Custom sort, select anywhere in the table then select on the sort & filter and click on the ‘Custom Sort…’ the sort screen will popup in that you can add level and sort by, etc. then click on the ok option.
Click on the image
Also read other articles @ EduTaxTuber
If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.
The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function
How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status
In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More
For Latest Updates & Learning Join Our YouTube Channel: Join Now

We are here to help for every updates related to everything…👍📙👍📗