I'm running into an issue that I do not know how to fix. I have a spreadsheet with an excel table. The automatic filter at the top of one column is no longer allowing users to select (blanks) as an option. All other columns with blank entries are still working as they are supposed to.
When I sort the automatic filter by select all, it chooses not to select those rows where there is no data entered. I have tried making sure no spaces are in those cells but it has not fixed the issue. Does anyone know how to resolve this? It is only showing up in one column of the table.
EDIT: I don't know if this was part of the original problem (another user reported it to me) but now the automatic filter on one column not only does not show blanks but will filter out several rows near the bottom that do have values in their cells. It filters these rows even when I tell it to filter by "Select All"