How i can get/copy the options from an excel sheet list

Steel Contributor

I have an excel sheet cell of type dropdown, as follow:-

 

johnjohn_0-1678476838425.png

 

it contain around 50 options, so how i can copy those options to a note pad? Thanks

 

5 Replies
options to a note pad

what kind of note pad?iPad?
these options may link to a range

@peiyezhu 

 

I mean the note pad program inside windows 

 

johnjohn_0-1678528655988.png

 

 

i need to copy those options to a notepad to add them as options inside SharePoint. i hope this make my request clearer..

https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce4...

want to appear in your drop-down list. Ideally, you’ll have your list items in an Excel table .

so,you can find the linked range and copy.

I am new user of excel but i am unable to put the any formula of mathematics.

@peiyezhumy requirement is simpler i just need to copy those options >> Paste them inside any text editor.. i hope you got what i mean