23:47:00
Create or delete an Excel table in a worksheet
When you create a table (previously known as list) in a
Microsoft Excel worksheet (worksheet: The primary document that you use in
Excel to store and work with data. Also called a spreadsheet. A worksheet
consists of cells that are organized into columns and rows; a worksheet is
always stored in a workbook.), you can manage and analyze the data in that
table independently of data outside the table. For example, you can filter
table columns, add a row for totals, apply table formatting, and publish a
table to a server that is running Windows SharePoint Services 3.0 or Microsoft
SharePoint Foundation 2010.
If you no longer want to work with your data in a table, you can convert the table to a regular range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of data while keeping any table style formatting that you applied. When you no longer need a table and the data that it contains, you can delete it.
Note Excel tables should not be confused with the data tables (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.) that are part of a suite of what-if analysis commands.
