Data Menu With Filters

Sort

Arranges the information in selected rows or lists alphabetically, numerically, or by date.

AutoFilter

The quickest way to select only those items you want to display in a list.

Show all

       To show all the data list in the display list.

Advanced Filter

Filters data in a list so that only the rows that meet a condition you specify by using a criteria range are displayed. We are filtering the desire value from the display list on another location.

Subtotals

Calculates subtotal and grand total values for the labeled columns you select. Microsoft Excel automatically inserts and labels the total rows and outlines the list.

Form

Displays a data form in a dialog box. You can use the data form to see, change, add, delete, and find records in a list or database.

Validation

Defines what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.