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
and I use autofilter all the time! Thanks - Julie
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JW
Check that the worksheet is not protected.
G
Gord Dibben
Sheet protected?
More than one sheet selected? As in [group] mode in Title bar?
Gord Dibben MS Excel MVP
More than one sheet selected? As in [group] mode in Title bar?
Gord Dibben MS Excel MVP
G
Guest
No, the worksheet is not protected. And there is not more than one sheet
selected.
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
G
Gord Dibben
I can't think of anything else.
Hang in.........someone may come up with an answer.
Gord
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
J
JP
Do you have a workbook open? Autofilter won't work if you don't have
at least one workbook/worksheet open.
--JP
at least one workbook/worksheet open.
--JP
P
Peo Sjoblom
Are you serious?
--
Regards,
Peo Sjoblom
--
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
J
JP
Possible, right?
Also, check Tools Menu, Options
On the View tab, Objects section, select "Show All" or "Show
Placeholders"
HTH,
JP
Also, check Tools Menu, Options
On the View tab, Objects section, select "Show All" or "Show
Placeholders"
HTH,
JP
G
Gord Dibben
I believe you got it with the Tools>Options>View
Gord
Gord
J
JP
Thank you, but without the OP to confirm, the world may never know.
--JP
--JP
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.