Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks non blanks in filter
I turned on the filter on an excel spreadsheet. When I look at the drop down
list from any given column I do not see the blanks - non blanks selection. I have done this on other spreadsheets and those two options are available. Why is this? -- Taylor |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks non blanks in filter
verify that you actually have blanks They may look blank but not actually be
"Spaces etc". if there are no blanks in the selection the blanks-non blanks will not show "TaylorLeigh" wrote: I turned on the filter on an excel spreadsheet. When I look at the drop down list from any given column I do not see the blanks - non blanks selection. I have done this on other spreadsheets and those two options are available. Why is this? -- Taylor |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks non blanks in filter
Make sure you select the whole range you want to include in the filter or
else Excel might cut it off where the first blank starts. -- Regards, Peo Sjoblom "TaylorLeigh" wrote in message ... I turned on the filter on an excel spreadsheet. When I look at the drop down list from any given column I do not see the blanks - non blanks selection. I have done this on other spreadsheets and those two options are available. Why is this? -- Taylor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blanks non blanks in filter | Excel Discussion (Misc queries) | |||
Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
Advanced Filter (Criteria + Blanks) | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |