Lists


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

Define a drop down list in Spreadsheet


By clicking "Manage lists" button, you have access to all list functionalities :

  • Create / Rename / Delete a list

Manage lists in Spreadsheet

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

Organize lists by drag and drop

  • 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

Manage lists options



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

Activate a list in a 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

Remove list from a cell

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.