If you have large worksheet data and want to search specific values as per your requirement. Filter command in MS Excel allows you to turn on or off filtering option on selected range of cells. Now, you can easily get the specific result as per your requirement. In this article we have to discuss how to quickly use filter command in Microsoft Excel.
Filter in an special utility command of Microsoft Excel. If you need to find specific values as per any situation then you have to use filter option in Microsoft Excel. If you have large worksheet data and need to filter required complex data then you have to use filter command in Excel. You can use filter command either from Home or Data tab as per your requirement. You can also turn-on filter option with the help of Ctrl+Shift+L excel shortcut key.
Must Read: How to convert cell contents from General to Date format in Excel
How to quickly use filter command in Excel
If you need to filter required complex data then you can easily and quickly use filter command in Excel. You have to take following few steps to use filter command in Excel.
Step 1: Create a new blank worksheet to start the filter process. Select the range of cells in which you want to apply filter command in Microsoft Excel.
Step 2: You must have to turn on filter option on selected range of cells. You have to turn on filter option with the help of three methods which is given below.
- You have to click on the Home tab > Sort & Filter > Click on the Filter command.
- You have to click on the Data tab > Click on the Filter command.
- You have to press Ctrl+Shift+L shortcut key to quickly turn-on filter option on selected range of cells.
Step 3: Finally, click on drop down arrow and set the condition to get the required result.
Must Read: How to Print Row or Column Headings on Each page in Excel
I hope after reading this article you can easily and quickly use filter command in Microsoft Excel. After using filter command you can easily filter data which is based on the complex condition. You can easily get the required result as per your requirement. If you have any suggestion regarding this article please write us in the comment box. Thanks to all.