Thread: data in rows not showing in auto-filter drop down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default data in rows not showing in auto-filter drop down
Sometimes blanks and other "junk" will cause the autofilter to fail.

Don't just click on the header cell when you set the autofilter, select the
entire table.
--
Gary''s Student - gsnu200909


"Denise" wrote:

Work sheet is only about 150 rows. Rows that appear in auto-filter are random.
Reply With QuoteReply With Quote