Autofilter drop down list not working in some columns

B

bpw1

I have a spreadsheet with 15 columns and 130 rows. The autofilter drop
list
arrows work fine in some columns and in other columns they refuse to
function. In the latter columns when you click on a drop list arrow it
just
blinks, no list falls down.

I have been unable to find any common reason why the autofilter list
won' t
appear in these columns. I am using excel 2001 for macintosh.

Thank you for any help you can provide. I really am stumped.

Bob
 
R

rlesperance

I have a spreadsheet with 15 columns and 130 rows. The autofilter drop
list
arrows work fine in some columns and in other columns they refuse to
function. In the latter columns when you click on a drop list arrow it
just
blinks, no list falls down.

I have been unable to find any common reason why the autofilter list
won' t
appear in these columns. I am using excel 2001 for macintosh.

Thank you for any help you can provide. I really am stumped.

Bob
Click to expand...

Hello,

Are the columns in a frozen pane area ??? I experiment this problem
when the filter arrows are on columns located in a frozen pane area ...
But I do not have a clue to solve the problem.


Robert
 
Top