Are You Working with a List?

Often a Microsoft Excel worksheet takes the form of a list, which is a labeled series of rows containing similar data.

Working with lists, you can:

• Show a subset of rows by filtering to see just the data you want.

• Sort the list alphabetically, numerically, or chronologically, or create a custom sort.

• Insert automatic subtotals.

• Compare and analyze data in a PivotTable, which is an interactive worksheet table that summarizes large amounts of data.

For information about working with lists, see Create a Business Contact List in Microsoft Excel. For information about creating a PivotTable, see Create a Sales Summary.

Next Steps