Pasting list of values from excel into select list

I have a large list of values in excel that I want to copy into select list as unique values:

ex: (each line is a cell in a single column in a row):

  1. Item 1
  2. Item 2
  3. Item 3
  4. Item 4
  5. Item 5
  6. Item 6
  7. Item 7
  8. Item 8
  9. Item 9
  10. Item 10

I want to Copy these items into a select list as unique values.

Every time I try to copy the excel values and try to paste them into a select list, it copies over as 1 value.

Any help is appreciated.

Don’t use the normal select list. Instead, store these values (from your excel) as a separate table in your doc.

Then use either a relation type column (or a select list if you really want that via formula references that table).

That will be really quick for you!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.