AutoFilter Unavailable?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie
 
Sheet protected?

More than one sheet selected? As in [group] mode in Title bar?


Gord Dibben MS Excel MVP
 
No, the worksheet is not protected. And there is not more than one sheet
selected.

Gord Dibben said:
Sheet protected?

More than one sheet selected? As in [group] mode in Title bar?


Gord Dibben MS Excel MVP

Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie
Click to expand...
Click to expand...
 
I can't think of anything else.

Hang in.........someone may come up with an answer.


Gord

No, the worksheet is not protected. And there is not more than one sheet
selected.

Gord Dibben said:
Sheet protected?

More than one sheet selected? As in [group] mode in Title bar?


Gord Dibben MS Excel MVP

Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie
Click to expand...
Click to expand...
Click to expand...
 
Do you have a workbook open? Autofilter won't work if you don't have
at least one workbook/worksheet open.


--JP
 
Are you serious?


--


Regards,


Peo Sjoblom



JP said:
Do you have a workbook open? Autofilter won't work if you don't have
at least one workbook/worksheet open.


--JP
Click to expand...
 
Possible, right?

Also, check Tools Menu, Options

On the View tab, Objects section, select "Show All" or "Show
Placeholders"


HTH,
JP
 
Back
Top