View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default NO values in Auto-filter drop-down

Remove the filter, put a header on top, then select all 722 rows header
included and then apply the filter. Still the same?


--
Regards,

Peo Sjoblom



"Jane" wrote in message
...
I have a column with 721 values. I placed Auto-filter in the row just
above
the data. There are no blank rows among my rows of data. However, the
drop-down shows NO values.

The workbook is not shared or protected.

what do you recommend?

thanks in advance!! Jane