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 ...
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?
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.