Apr 16
The autofilter facility in Excel is an excellent and easy tool that enables filtering of the data in the column based on multiple criteria. After filling the column with all required data (including the heading which is a must to ensure that we know what date the column contains) , we need to be in the column header cell. We need to select the Data drilldown from the menu, and then select suboption , and then the Autofilter suboption. Tryout yourself with your data and you will be amazed with the results. happy excelling.
written by admin