Forum Discussion
Excel
Help,
I have a spreadsheet with various data added and want to filter this to only show certain data. However the sheet is not filtering out all blank cells. I have removed the filter, resaved the document and ensured all cells are blank and tried again - and failed again. I have the same document saved this different data that is allowing the filter to work correctly. Any ideas on what I am doing wrong?
thank you in advance
Mandy
4 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I think I have already sent this link but going to send it again as I cannot find my reply https://www.loom.com/share/45cbef296c3f40b78c5df02bd270b1ae?sid=a2dd7de6-12a3-40ae-a4b3-c68ce3e9cabd
🙂
Hiya Hans, sorry for the delay.
there is no sensitive data as such so I created a recording see https://www.loom.com/share/45cbef296c3f40b78c5df02bd270b1ae?sid=a2dd7de6-12a3-40ae-a4b3-c68ce3e9cabd
any help would be greatly appreciated
🙂
Thanks. Try the following:
- Turn off Filter.
- Select the entire range from B4 to the last cell with (related) data.
- Turn on Filter.
- Click the filter drop-down in N4 and clear the Blanks check box, then click OK.
