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

Question

I have an excel sheet cell of type dropdown, as follow:-&nbsp;&nbsp;it contain around 50 options, so how i can copy those options to a note pad? Thanks&nbsp;

peiyezhu · Answer

options to a note padwhat kind of note pad？iPad？these options may link to a range

john john · Answer

peiyezhu&nbsp;&nbsp;I mean the note pad program inside windows&nbsp;&nbsp;&nbsp;&nbsp;i need to copy those options to a notepad to add them as options inside SharePoint. i hope this make my request clearer..

peiyezhu · Answer

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

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.

zahidzaidi · Answer

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

john john · Answer

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

Forum Discussion

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

Share

Resources