CREATE AN AUTO FILTER MENU

If you have a spread sheet full of
data,using the auto filter option may
be more easy and effective to use and
maintain that pivot tables.You can
create a dedicated menu command
for the autofilter feature to make your
navigation and usage much quicker.To
create an autofilter menu,carry out
the steps as mentioned below:
go to the "tools|customize"menu
command
once the customize dialog box is
displayed,got to the data|filter
command from the menu bar on top
of the application window.
Keeping the (ctrl)key pressed,drag and
drop the autofilter option on a
comfortable location on your menu
bar.
Click the close button to close the
customize dialog box.You can now
acess the autofilter menu directly from
the menu bar as and when required.