Creating Lists

In Excel, a list is a set of data, arranged in a certain way. Many of Excel's features—the Data Form, pivot tables, filters, and others—will not work properly if data is not arranged as a list. And while other features such as charts will work with data that's not in list format, they become more difficult to use.

Furthermore, it's typical for data that has been imported into Excel from an external data source to enter the workbook in the form of a list. So, it's useful to know what a list is and how to set one up.

A list is a rectangular range of cells on a worksheet. It has one or more adjacent columns and two or more rows. The list is usually separated from other data on the worksheet by blank rows and columns.

In versions of ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.