TABLE IN EXCEL
A Table is a rectangular range of structured data. The key features are −
- Each row in the table corresponds to a single record of the data. Example – Employee information.
- Each column contains a specific piece of information. Example – The columns can contain data such as name, employee number, hire date, salary, department, etc.
- The top row describes the information contained in each column and is referred to as the header row.
- Each entry in the top row is referred to as a column header.
You can create and use an Excel table to manage and analyze data easily. Further, with Excel Tables, you get built-in Filtering, Sorting, and Row Shading that ease your reporting activities.
Difference between Tables and Ranges
Following are the differences between a table and a range −
- A table is a more structured way of working with data than a range.
- You can convert a range into a table and Excel automatically provides −
- a Table Name
- Column Header Names
- Formatting the Data (Cell Color and Font Color) for better Visualization
Tables provide additional features that are not available for ranges. These are –
Excel provides table tools in the ribbon ranging from properties to styles.
- Excel automatically provides a Filter button in each column header to sort the data or filter the table such that only rows that meet your defined criteria are displayed.
- If you have multiple rows in a table, and you scroll down the sheet so that the header row disappears, the column letters in the worksheet are replaced by the table headers.
- When you place a formula in any cell in a column of the table, it gets propagated to all the cells in that column.
- You can use table names and column header names in the formulas, without having to use cell references or creating range names.
- You can extend the table size by adding more rows or more columns by clicking and dragging the small triangular control at the lower-right corner of the lower-right cell.
- You can create and use slicers for a table for filtering data.
To create a table from the data you have on the worksheet, follow the given steps
Step 1 − Select the Range of Cells that you want to include in the Table. Cells can contain data or can be empty. The following Range has 270 rows of employee data. The top row of the data has headers.
Step 2 − Under the Insert tab, in the Tables group, click Tables. The Create Table dialog box appears. Check that the data range is selected in the Where is the data for your table? Box is correct.
Step 3 − Check the My table has headers box if the top row of the selected Range contains data that you want to use as the Table Headers.
Note − If you do not check this box, your table will have Headers – Column1, Column2, …
Step 4 − Click OK.
The range is converted to a Table with the default Style.
Step 5 − You can also convert a range to a table by clicking anywhere on the range and pressing Ctrl+T. A Create Table dialog box appears and then you can repeat the steps as given above.