Filter can not find Blank cells if the whole row is blank

[lezawang]

Hi
When I clicked on the filter of any column in the table below, I do not see Blank cells option? However, row 9 is blank! then I tried delete a cell from column B for example and then I click on the filter of column B then I saw Blank cell? does that mean filter can not detect an blank cell if the whole row was empty? Thank you

 

[jasonb75]

When I clicked on the filter of any column in the table below

I don't see any attachment. Best guess would be that the filter range has only been set to the data above the empty row.
When you create the filter it is only applied to the current region. A completely empty row will be seen as the end of that region. If you want it applied to everything then you need to select all of the data before you turn filtering on, not just a single cell / row.

 

[lezawang]

Sorry, I am attaching the file now. I tried as you said to highlight the whole table then the whole column, did not work. Try to filter column C, D, E etc no blank cell
Try to filter column B, you will see blankCell because I had to delete no more cell (which is not part of the empty row). Thank you again.

filterblank.xlsx

drive.google.com

filterblank.xlsx
	A	B	C	D	E	F	G	H	I
1	Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug
2	user1		88	439	154	3	680	453	573
3	user2	544	930	259	723	528	652	186	829
4	user3	266	84	253	50	793	290	230	869
5	user4	996	933	1000	657	410	591	543	349
6	user5	37	725	378	557	212	98	603	103
7	user6	17	46	907	173	921	329	729	253
8	user7	857	872	670	346	168	779	936	736
9	user8	265	11	853	898	864	815	865	330
10	user9	745	547	588	584	629	144	890	42
11	user10	33	130	386	838	511	883	925	797
12	user11	429	405	141	291	233	107	191	325
13
14	user13	739	261	609	627	140	322	827	869
15	user14	12	206	335	331	544	952	791	103
Sheet1

 

[Fluff]

Remove the filter, then select the entire data & whilst it's all selected reapply the filter

 

[jasonb75]

I tried as you said to highlight the whole table then the whole column

That's not what I said.

you need to select all of the data before you turn filtering on

With the XL2BB mini sheet in your post, that would be A1:I15.

Also, note that I said 'before you turn filtering on' and not 'before applying the filter'. That means before clicking the big filter button on the toolbar, not before you click the arrows in the top row.

 

[lezawang]

it works. thank you all.

 

[Fluff]

Glad we could help & thanks for the feedback.