Microsoft Office Excel spreadsheets have been the most useful way when it comes to compile information about customers, product, sales revenues and other types of data. But when the volume of data in a single worksheet grows to fill dozens of columns or rows, sorting through it can be a challenge. For example, if you have to review the data for your 10 customers in a particular region, you may end up spending a long time to get the details for every data entry.

Fortunately, Excel includes an easy-to-use AutoFilter option that after applying shows you just what you want to see and hides the rest. Filtering doesn’t affect your data in any way. As soon as you remove the filter, your data reappears in the same format.

Don’t know how to use filter in Microsoft Excel? Here’ how

  1. Open Microsoft Excel Sheet.
  2. Click the ‘first cell’ in the column.
  3. Click on ‘Data’ on the toolbar and click the ‘Filter’ button.
  4. Click the ‘drop-down’ button that appears on the first cell.
  5. Uncheck ‘Select all’ and check the option you want to count the total for. Click OK.
  6. Now, select all the cells containing the option throughout the column.
  7. The ‘Status Bar’ at the bottom will show the ‘Count’.


If you will follow these steps, you will certainly help yourself by keeping your data organized in the Microsoft Excel spreadsheet. To comprehend the above-mention steps in a better way,