Document Editing Problems

How to Filter Excel Data by One or More Salespeople

Chanuka Geekiyanage Oct 21, 2026 868 views

Question details

The user needs to filter an Excel dataset to display only the sales records associated with one or more specific salespeople.

How to Filter Excel Data by One or More Salespeople

Product: Excel
Device & OS: not provided
Scenario: Analyzing a sales dataset and isolating the records belonging to individual or multiple salespeople for performance tracking or reporting.
Observed behavior: The goal is to hide irrelevant data and display only the matching records for the selected salespeople using Excel's filtering features.

Before you start

Ensure your dataset is organized continuously without any completely blank rows or columns, and that every column has a clear header label, such as 'Salesperson'.

Solution 1Recommended

Use Excel Table Filters to Select Specific Salespeople

Converting your data into an Excel Table automatically applies interactive drop-down filters to your headers, making it easy to check and uncheck multiple criteria.

Using the built-in table format is the most reliable way to handle dynamic data in Excel. It ensures that filters are applied to the correct ranges and automatically extends when new data is added.

Select your data range

Click any cell inside your dataset. Press Ctrl+T on your keyboard to open the Create Table dialog box.

Confirm table range

Verify that the selected range covers all your data. Check the box that says 'My table has headers' and click OK to convert the data into a table.

Open the salesperson filter

Locate the 'Salesperson' column header and click the small drop-down filter arrow that has appeared next to the header text.

Select the required salespeople

Uncheck the 'Select All' box to clear current selections, then check the boxes next to the names of the salespeople you wish to view. Click OK to apply the filter.

Use Excel Table Filters to Select Specific Salespeople

Data Filtered Successfully: Excel will immediately hide all rows that do not match your selection, leaving only the records for the chosen salespeople visible on your screen.

Free Spreadsheet Data Analysis

Filter Sales Records Quickly with WPS Spreadsheet

WPS Spreadsheet provides powerful data filtering and table formatting features identical to Excel. You can easily isolate sales records by salespeople using intuitive drop-down filters in a highly familiar interface.

1. Open your sales dataset: Launch WPS Spreadsheet and open the file containing your sales records.
2. Enable auto-filtering: Highlight your header row, navigate to the 'Data' tab on the top ribbon, and click the 'AutoFilter' button.
3. Filter by Salesperson: Click the filter arrow in the Salesperson column header, uncheck 'Select All', tick the specific names you want to display, and press OK.

100% compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight program that opens large datasets instantlyFamiliar ribbon interface ensures zero learning curveIncludes advanced data analysis tools completely for free

microsoft office alternative - wps office

Frequently Asked Questions

How do I clear the filter to see all salespeople again?

To clear an active filter, click the funnel icon on the 'Salesperson' column header and select 'Clear Filter from Salesperson'. Alternatively, go to the Data tab and click the 'Clear' button in the Sort & Filter group.

Can I filter by salesperson and sales amount at the same time?

Yes, Excel allows you to apply multiple filters. After filtering the 'Salesperson' column, click the filter arrow on the 'Sales Amount' column and apply a number filter, such as 'Greater Than', to further refine the visible records.

Why is the filter option grayed out in my spreadsheet?

The filter button may be grayed out if multiple sheets are grouped together or if the worksheet is protected. To fix this, right-click any sheet tab and select 'Ungroup Sheets', or go to the Review tab and click 'Unprotect Sheet'.

How do I search for a specific salesperson in a very long list?

When you click the filter drop-down arrow in the column header, there is a search box just above the checkbox list. Type the name of the salesperson there, and Excel will immediately narrow down the checklist options.

Document & File Issues