How to Sort Data in a Table-Microsoft Excel?

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit

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:
  1. Select Custom Sort.
  2. 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

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

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