Hoping I have the right name, but sometimes in an Excel file there is a cell with a drop-down menu. One clicks the small pointer on the right, and many cells of data drop down. You select the one you want. The most common form of this is when you are enroling online for something, and you are asked for your country. You click the rhs of the cell and all the world's countries are there.

I would like to copy and paste this, but, when I do, I want ALL the world's countries to be listed, one-by-one in seperate Excel cells of their own, not all in a drop-down menu.

Is this possible?