Working with Categories

Categories are the general classes of information contained in a table. Categories are comprised of items, and are displayed and manipulated with category tiles.

A category is a class of information, represented in FlexiSheet by a category tile. A category contains instances known as items. By default, categories in new FlexiSheet models are named "A" and "B." Newly created categories follow sequentially ("C," "D," etc.) until they're renamed.

Each category contains one or more items. For example, the Quarters category might contain items named Q1, Q2, Q3 and Q4. A Writing Tools category might contain items named Pens, Pencils and Chalks, and the Territory category might contain items named USA, Europe and Asia.

The intersection of items within categories are known as cells, and might describe, for example, Q4 sales of pens in Europe. Formulas that define these values can refer to categories and items by name, which simplifies both reading and writing formulas.

Related Topics
Name categories
Moving a Category
Deleting a Category