Software

Ask something
Question Locked

Advance feature in excel 2007 missing

0 helpful
4 replies

by armskite

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I've looked everywhere online and can't seem to find an answer. I have office 2007 professional plus. I want to use the advanced filter option but it doesn't show up as a menu item at all. It's not that it's greyed out, it simply does not appear. Does anyone know why or how I can fix this? My operating system is Vista. Thanks much.

4 replies

by boxfiddler

the Advanced Filter/Sort dialogue to your Quick Launch Bar using the customization options available via the Office Button.

Office Button\Excel Options\Customize.

In the left-hand dialogue drop-down box choose All Commands. Just scroll until you find the one you want, select it, and click Add.

Hope this is what you're looking for.

by chris910

This selection is context sensitive.
Have you made a selection to apply the advanced filter to?

Another possibility is that you have created a table which disables the advanced filter because the features are built into the Table.

This discussion is closed to new replies.