Definition:
The term table has multiple meanings in spreadsheet programs such as Excel.
- 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.
- 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)
