O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Menu

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.

Sort

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).

Filter

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).

Form

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).

Subtotals ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required