The list feature in Elements Spreadsheet allows you to define and use drop down lists in specifics cells in order to control what a user enters in the cell.
Define a drop-down list in your sheet
Simply click on the list icon in the sidebar: .
A panel appears on right side which can be define in two parts:
on top of the panel, selection and activation of a list in a selected cell
below, list management
By clicking "Manage lists" button, you have access to all list functionalities :
Create / Rename / Delete a list
When you delete a list, the content of cells which used it in the sheet will be erased
Organize your lists by dragging and dropping the item by the icon on the left
Create / Rename / Delete the options in the list
When you delete an option list, the content of cells which used it in the sheet will be erased
Organize your option's list by dragging and dropping the item by the icon on the left
Activate a list in a cell
Select a cell or a range of cells and click on the list icon in the sidebar .
In drop down list, choose a list which will be used in the cell
Remove list from a cell
Select a cell (or a range) with a list activated and click on the list icon in the sidebar .
In drop down list, click on remove cell list
Import Excel lists
All lists (data validation) defined in Excel documents (version 97 and later) are automatically imported in Elements Spreadsheet and available as drop-down lists.
