Lists
The list feature in Elements Spreadsheet allows you to perform data validation in your Spreadsheet document by constraining users to select options from a list in some cells.
Two types of list are supported in Elements Spreadsheet:
Lists which allow you to manually create options for your dropdown list
Lists from a range which allow you to create options coming from selected range(s) in the Spreadsheet editor
Lists can be managed from the sidebar. Simply click on the list icon in the sidebar:
![](../__attachments/10968105232/SP%20-%20Manage%20lists%20(1)%20(2).gif?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
In order to use lists in your Spreadsheet document, you first need to create it. Once that is done, you will be able to apply a list to one or more cells.
Create Lists
The first step is to create a list. Creating lists is done from the List sidebar.
Lists
Creating a list allows you to input manual options.
From the Lists sidebar, simply click the "Create a new list" button, then select "List" from the List type selector.
![](../__attachments/10968105232/image2023-1-24_10-42-51.png?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Click "Create".
The list has been automatically named for you. You can rename it as you please.
Now manually create options for your list.
![](../__attachments/10968105232/Create-manual-list.gif?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Lists (from a range)
Creating a list from a range is useful when list data is already available in the spreadsheet document you work with. Lists created from a range are also ideal when you have many items that you do not want to manually create one by one.
From the Lists sidebar, simply click the "Create a new list" button, then select "List (from a range)" from the List type selector.
![](../__attachments/10968105232/image2023-1-24_10-43-14.png?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Click "Create".
The list has been automatically named for you. You can rename it as you please.
Now select a range in your Spreadsheet document. You will notice the sidebar list input is updating as you are selecting.
![](../__attachments/10968105232/Create-list-input-from-range.gif?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Click "Enter" or click the
icon to save your selection.
If you need to edit the selection, you can click the
Do not forget to save the updated selection by clicking "Enter" from the list input or the
Did you know?
Lists from a range allows you to select multiple non-contiguous ranges!
![](../__attachments/10968105232/Create-list-from-range.gif?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Apply Lists to a selection
After creating a List, you can apply that list to a selection.
Applying lists to a selection can be done from the context menu.
Select one or more cells and right-click and go to Lists > Apply list "your list name".
![](../__attachments/10968105232/Apply-list-to-selection.gif?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Clear List from a selection
To clear a list that was added to a selection, right-click the selection, go to Lists and select Clear list from selection.
![](../__attachments/10968105232/image2023-1-24_17-7-48.png?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Import Excel & Google Sheets lists
All lists created from data validation in Excel documents (version 97 and later) and Google Sheets drop-down lists can be imported in Elements Spreadsheet and available as drop-down lists.