FIX: Excel spreadsheet doesn’t filter correctly

by Matthew Adams
Matthew Adams
Matthew Adams
Windows & Software Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things... read more
Affiliate Disclosure
microsoft excel can't access the file

To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Most Excel users probably set up data tables within that application. Users can filter data in their tables with Excel’s filtering tool. However, sometimes Excel spreadsheet tables might not filter the data correctly.

If you need to fix Excel’s table filtering, check out some of the potential resolutions below.

How can I fix Excel table filtering?

1. Select the whole column to apply the filter to

  1. Select the table’s whole spreadsheet column by clicking the column’s letter.
    Excel column excel spreadsheet not filtering correctly
  2. Click the Data tab.
  3. Then click the Filter button to apply the filter to the whole column.
  4. Click the cell filter arrow button to open the filtering options shown directly below.Excel filtering options excel spreadsheet not filtering correctly
  5. You can deselect the Blanks checkbox to leave out the empty cells.

2. Delete blank cells from the table’s column

Alternatively, you can erase blank rows from a table’s column to include values below the empty cells within the filter.

Select all the empty cells’ rows by holding the Ctrl key. Then right-click and select the Delete option.

Delete option excel spreadsheet not filtering correctly

3. Ungroup sheets

The Filter option will be greyed out when your sheets are grouped together. Thus, you can’t filter spreadsheet tables in grouped sheets. To fix that, right-click the grouped sheets at the bottom of Excel and select Ungroup sheets.

Ungroup Sheets option excel spreadsheet not filtering correctly

4. Unprotect the worksheet

  1. Select Excel’s Review tab.
  2. Press the Unprotect sheet button.Unprotect Sheet button excel spreadsheet not filtering correctly
  3. If an Unprotect sheet window opens, enter the password for the worksheet in the text box.
  4. Click the OK button.

5. Unmerge cells

  1. Press the Ctrl + F hotkey.
    Find and Replace window excel spreadsheet not filtering correctly
  2. Click the Format button on the Find and Replace window.
  3. Click Merge cells on the Alignment tab shown directly below.The Merge cells setting excel spreadsheet not filtering correctly
  4. Press the OK button.
  5. Press the Find All button.
    • Thereafter, the Find and Replace window will list all cell references with merged cells.
  6. To unmerge merged cells, select a merged cell.
  7. Click the Merge & Center option on the Home tab.
  8. Select the Unmerge cells option.Unmerge Cells option excel spreadsheet not filtering correctly

6. Set up a new filter

  1. If there are rows in your table that don’t get filtered, try setting up a new filter. To do so, select the Data tab.
  2. Click the Clear button within the Sort & Filter group.
  3. Then select table’s full column range with the cursor.
  4. Click the Filter button on Excel’s Data tab.

The Filter option excel spreadsheet not filtering correctly

Those are some of the resolutions that might get your Excel table filters fixed. In most cases, reapplying filters or clearing them to set up new filters will often resolve Excel filtering issues.

Which of the solutions solved the pro Excel filtering issue for you? Let us know by leaving a message in the comments section below.


idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: