To enhance the ease of managing and analyzing a set of related data, one can convert a range of cells into a table. This conversion empowers users with functionalities akin to those found in a spreadsheet list, streamlining data manipulation and analysis.
A table can include the following elements:
- Header row: By default, a table has a header row. Every table column has filtering enabled in the header row so that you can filter or sort your table data quickly. For more information, see Filtering and Sorting Tables.
- Banded rows: Alternate shading or banding in rows helps to better distinguish the data.
- Calculated columns: By entering a formula in one cell in a table column, you can create a calculated column in which that formula is instantly applied to all other cells in that table column.
To quickly create a table in Tabulate, do the following:
- Select the cell or the range in the data.
- On the STYLES ribbon, select the Tables drop-down and choose the style you want for the table.
The table is created from the selected data.
Note: You can also create an empty table by selecting a range of empty cells.