Autofilter not working for cells with data validation

G

Guest

Hi all

I have a long column of cells that have the same data validation lists applied to them. At the top of the list is an auto filter. However when I go to use the autofilter and select of the options it doesn't work...grrrrr.

please help!!!

thanx in advance
Freddo Frog
 
G

Gord Dibben

Freddo

What is "doesn't work"?

I just tested 5000 rows in a column.

Selected A1:A5000 and DV>List. Entered days of the week.

Selected Sunday through Saturday in A1:A7

Copied down to A5000.

Autofiltered on Monday in Column A and worked fine.

Gord Dibben Excel MVP

On Mon, 21 Jun 2004 21:30:39 -0700, "Freddo Frog" <Freddo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel 2003 - Autofilter for protected cells 1
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
Conditional Autofilter For Formula 4
2007 data validation not working 1
Auto filter and data validation 1
Autofilter misses last line 7
Data Validation Dropdown List Not Working 4
Named data validation list- how to undo? 1

Top