Filter

Filter data by background color or conditional formatting

During working on the Excel sheet you have to fill multiple colors in any column to set the criteria as per your need. You can apply different background colors or conditional formatting on large worksheet data as per your need. Excel allows you to quickly filter data by background color or conditional formatting in active worksheet. Read More

How to use Advanced Filter in Microsoft Excel

Hi, friends today we are talking on How to use Advanced Filter. Advanced filter is an important utility of Microsoft Excel. If you need to apply complex criteria on any worksheet than you have to use Advanced filter in Microsoft Excel. This option displays all those records which meet the complex criteria on any worksheet. In this guide we have to discuss how to use advanced filter in Microsoft Excel. Read More

How to use filter command in Microsoft Excel

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. Read More