If you have a spreadsheet full of data, using the auto filter option may be more effective and easier to use and maintain than pivot tables. You can create a dedicated menu command for the AutoFilter feature to make your navig,ation 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, go to the 'Data / Filter' command from the menu bar on top of the application window.

Name: Autofilter menu in Excel.jpg Views: 342 Size: 47.5 KB

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 access the AutoFilter menu directly from the menu bar as and when required.