Filter Option in Microsoft Office Excel
Microsoft office Excel itself is like a Table having number of columns and rows. But have you ever thought that if there is more number of values and when we need to filter on some column values how to achieve it. This article explains you how to insert filter for a column in Microsoft office Excel.
Here in this Microsoft office Excel sheet I am placing a filter on column Name, For that Right click on the cell, Go to Filter option select Filter by Selected Cell’s Value. See the image below.
Now the columns get filter options on its header.Click on the Filter option in the header.The list shows the values in the column,we can filter it out on the values which wee need.See here I am filtering on one particular name.
Once we select the name and click OK the records with the selected value gets filtered out. See the Image below.
Also we can sort the records ascending/descending if we have selected Filter option. Sort A to Z sorts the records ascending order and the next one sort in descending order. In the following Image I selected the “Select All” option and Sort A to Z option. See now the sheets show all records sorted in ascending order.
Tip from the Article:
There is a shortcut to add filter in the Microsoft office Excel Cells and here it is:
Ctrl + Shift + L
Try it out and Happy learning!
