How to Fix Excel Vendor Filters Showing All Vendors Instead of Filtering Correctly in WPS Spreadsheets
Question details
The user needs to make an Excel vendor filter show only the selected vendor, because the current filter still returns other vendors or incomplete production results after filtering.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with vendor production data in a spreadsheet and applies a filter to the Vendor column to isolate a single vendor's records.
- Observed behavior
- The filter appears to select one vendor, but the sheet still displays other vendors or only part of the expected production results.
Make sure the spreadsheet is not protected and identify the exact header row and data range that should be filtered; also note whether the vendor list contains merged cells, blank rows, or imported values with extra spaces.
Check and Rebuild the Filter Range as a Single Excel Table
Use this when the filter range is broken by blank rows, merged cells, or a non-contiguous selection.
A filter works reliably when the dataset has one header row and no empty rows or columns cutting through the range. Converting the range to a table forces WPS Spreadsheets to treat the data as a single filterable block.
Click any cell inside the vendor dataset, then press Ctrl+A to select the current region, or drag to select from the header row to the last populated row.
Go to the Home tab and click Format as Table, or go to Insert > Table, then confirm that the selected range includes the header row and all data rows.
In the Create Table dialog, verify the range and check My table has headers, then click OK.
Click the filter arrow in the Vendor column, choose Text Filters or the search box, select only the target vendor, and click OK.
Clean Vendor Names with TRIM and CLEAN Before Filtering
Use this when vendor names contain extra spaces, line breaks, or hidden characters imported from other systems.
Clear All Filters and Remove Hidden or Blank Rows
Use this when existing filters, manual hidden rows, or blank rows are left over from previous edits.
Fix Excel Vendor Filter Issues Directly in WPS Office Spreadsheets
Use WPS Office Spreadsheets to repair the vendor filter range, clean imported vendor names, and reapply filters so only the selected vendor appears. WPS Spreadsheets opens .xlsx, .xls, and .csv files and gives you the same familiar filtering tools.
- 1. Open the workbook in WPS Office: Launch WPS Office, click Open, and choose the Excel .xlsx or .xls file that contains the vendor data.
- 2. Convert the data to a table: Click inside the vendor data, go to the Home tab, click Format as Table, and confirm the range has one header row and no blank rows.
- 3. Standardize vendor names: Use =TRIM(CLEAN(VendorCell)) in a helper column, then paste the cleaned values back into the Vendor column.
- 4. Reapply the vendor filter: Click the filter arrow in the Vendor column, search for the target vendor, select it, and click OK to display only that vendor's rows.
- 5. Save the corrected file: Click File > Save As, choose Excel Workbook (*.xlsx) to keep the file compatible with Microsoft Excel, and save it.
Frequently Asked Questions
Why does my Excel filter show other vendors after I select only one?
Usually the filter range is not one contiguous table, or the Vendor column contains blank rows, hidden rows, or inconsistent spelling. Clear the filter, convert the data to a single table, and reapply the vendor filter.
How do I make Excel treat vendor names with spaces as the same value?
Add a helper column and use =TRIM(CLEAN(A2)) to remove extra spaces and nonprintable characters, then copy and paste the results as values into the Vendor column before filtering.
Does converting my data to a table change my spreadsheet formulas or formatting?
No. It changes the range into a structured, filterable table while keeping values, formulas, and most formatting intact. You can still edit it as a normal spreadsheet.
Can I fix this in WPS Office if the file was created in Microsoft Excel?
Yes. Open the .xlsx or .xls file in WPS Office Spreadsheets, repair the range and vendor names, reapply the filter, and save it back to Excel Workbook format.
