Thursday, February 3, 2011
Auto-Filter Command in MS Excel
First, headings cell will be selected for this purpose and then in Data Tool option select Auto filter after which in all headings of the table, auto-filter will be activated.
Below is a sample worksheet of Microsoft Excel where Auto-Filter command is given after preparation of the worksheet.
Now to get one specifc cateogry records, click on a heading and then select one particular word for exmple, China as origin.
Similarly if you want to auto-filter records in such a way that it should show only shipments records of M/s Denim Co Ltd, what ever they imported from whatsoever country. Select in Heading Importer Column, the company name which is Denim Co Ltd and it will show the records of M/s Denim Co Ltd.