1. Technology
Send to a Friend via Email
You can opt-out at any time. Please refer to our privacy policy for contact information.



Excel Table

Excel Table

© Ted French

The term table has multiple meanings in spreadsheet programs such as Excel.

  1. A series of rows and columns in a worksheet that contain related data.

    One of the best analogies for this definition of an Excel table is a telephone book. A telephone book contains related information about a person - such as a their name, address, and telephone number. This data has been organized into rows and columns to make it easier to find the information we are after.

  2. In addition to the rows and columns of related data, a table in Excel 2007 and Excel 2010 includes a number of tools or features that make it easier to organize and find specific information in the table.

These tools include sorting data and filtering data.

In previously versions of Excel a table of this type was referred to as a List

Also Known As: a List (Excel 2003 and previous versions)

©2014 About.com. All rights reserved.