Excel® 2013 On Demand

Understanding Tables

A table is a series of rows and columns with data you manage separately from other data in a worksheet. Examples of tables are an address book, a list of customers or products, and a telephone directory. In Excel 2007, you can turn a range of cells into a table (previously referred to as an Excel list) to make it easier to manage and analyze a group of data. You can create more than one table in the same worksheet. However, you cannot create a table in a shared workbook.

When you create a table, Excel adds filtering in the header row where you can sort data by order or color, and filter data by criteria. After you create a table, you can easily format table data using Quick Styles. Additionally, you can insert and delete ...