MS Excel Data Filter Learn from the beginning
What is Filter?
How to apply filter in Excel Sheet?
The option of Filter is also available in the Data tab. You can also apply filters and remove them by clicking on the Filter symbol of the Data tab.
Data >> Filter
Filter Data by Selecting specific information
After the filter is applied, click on the drop down symbol of the header of the column whose information is to be filtered. The window of the filter will open. The first 2 options are Sort A to Z & Sort Z to A. Click here to learn options for sorting. The third option is sort by color. We can also apply filters by the color of the cell and the color of the text.
Here we selected the first two names and clicked on OK.
Only those data which have been Filtered, have started appearing on the screen.
Filter by Searching Text or Number
Filter is also applied by typing the Text or Number in the search bar..
Column D contains location code. Filter option by number is available.
After selecting the number of any location code, we will see the result of that number.
Multiple Filter
In the image shown below, first the Development Department has been filtered.
Employees of all the development departments started appearing and the rest became hidden. After that select Android Developer from the column of Designation.
Android Developer’s is visible.
Date wise Filter
If the date is in the column, then the filter separates Automatic Year, Month & Day. We can easily select whole year or month.
With the + sign, we can select the Year & Month by Minimize and Maximize.
Copying and pasting the data into a separate sheet
Click and paste in another sheet. Only filtered data will be different.
Calculation of filtered data
Apply filter and select Numerical cells. Only Visible filter data will be calculated on the status bar of Excel.
Data sorting using Filter Option
Data sort by date
Sort Oldest to Newest
Sort Newest to Oldest
The drop down option of filter provides the option of data sort.
If there are dates in the column, then the old dates in the top cell can be placed under the new dates, such an order by selecting option Sort Oldest to newest, or the reverse order by selecting option Sort Newest to oldest.
Sort data smallest to Largest
Sort data largest to smallest
If the cell has numerical data, then automatic 1.Sort Smallest to largest 2.Sort Largest to Smallest option. Sort Smallest To Largest With This Option Can Arrange Data In Ascending Order, And Sort Largest To Smallest With This Option Can Arrange Data In Descending Order.