The Data menu includes features for managing lists of data, like sorting, filtering, and grouping. It also provides commands for creating pivot tables and importing data from external sources, like databases and Web pages.
The Sort dialog box (Data → Sort) lets you choose the columns you want to use to sort a selected range of cells or a data list. When you click OK, Excel performs the sort, rearranging your cells. For more information, see Section 13.3 (Chapter 13).
This menu lets you filter a list of data so that you see only the rows that meet certain conditions. If you use Excel's data list feature (and create a list using the Data → List → Create List command), automatic filtering is available through the column headers. But if you want to use filtering with a range of cells that isn't explicitly configured as a data list, you can use the AutoFilter command from this menu. You can also use the Advanced Filter to create more sophisticated filter conditions that can take several criteria into consideration. For information about both types of filtering, see Section 13.3.3 (Chapter 13).
The Data Form dialog box (Data → Form) lets you view or edit a single row of data in a list. Each field in your list occupies a separate text box in the Data Form window. You can step from row to row using the window's scrollbar, and you can use a somewhat quirky built-in search feature. The Data Form dialog box is described in detail on Section 13.2 (Chapter 13).