How to Filter Data in Microsoft Excel



Guide

  1. Select a cell within your range or table.

  2. Go to the Data tab and click Filter.

  3. Click the filter arrow, select Text Filters or Number Filters.

  4. Choose a comparison (e.g., "Between").

  5. Enter filter criteria and click OK.

  6. Click the filter arrow, uncheck Select All, then check the boxes for the values you want to display, and click OK.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline