Register now or log in to join your professional community.
Through data tab we can use the data filter option in Excel sheet to sort the data according to the requirement.
Many of us find Microsoft Office Excel spreadsheets very useful for compiling information about customers, products, sales revenues and other types of data. But when the volume of data in a single worksheet grows to fill dozens of columns or rows, sorting through it can be a challenge. If you want to isolate, for example, your top10 customers in a particular region over the last six months, you might spend a long time reviewing your data entries.
Fortunately, Excel includes an easy-to-use AutoFilter to show just what you want to see and hide the rest. Filtering doesn't change your data in any way. As soon as you remove the filter, all your data reappears, exactly the same as it was before.
By insterting in every column of another something same like a custom sort options...
Filtering data in a spreadsheet means to set conditions so that only certain data is displayed.It is done to make it easier to focus on specific information in a large database or table of data.
to filter and sort data for every column as required to get quick and useful data to print
or analysing
filter option in excell help users to sort many results and to focus on the most important data when there is a lot of information on database.
