Create a picklist

Create a picklist

What is a picklist?

Picklist is a drop-down list with a predefined set of items. In cells with picklists, you can't manually enter any data into the cell.

How to create a picklist

To create a picklist:
  1. Select the range of cells you wish to add the picklist to.
  2. Go to Insert > Picklist  > Create.
  3. Enter the list of items you wish to add as a picklist and click Create.
  4. Alternatively, you can add an existing cell range as your predefined list by selecting a range.
 
Notes
You can not enter any other values manually. If you want to enter a value that is not in the list, you will have to edit the existing drop-down list and add your desired value.

How to manage your picklist

To manage a picklist:

  1. Go to Insert > Picklist > Manage.
  2. Select the picklist you wish to edit and click Edit.
  3. Remove/add entries to the existing picklist and click Save.
Notes
Editing a value from the picklist will effectively change the old value to the new one, in every occurrence until then. This saves you time and effort, and you'll not have to change it manually in every other place.

How to apply an existing picklist to a different range

To apply a picklist to a different range:
  1. Navigate to Insert > Picklist > Manage.
  2. Select the picklist you wish to copy to a different range and click Copy.
  3. Under Applies to, select the new range where you want the picklist added.
  4. Add/remove entries to the existing picklist and click Save.

How to delete a picklist

To delete a picklist:
  1. Go to Insert > Picklist > Manage.
  2. Tap the - icon from the options.
  3. Alternatively, select the range containing the picklist and click Clear All from the Home menu.