Problems with Excel drop-down lists

Hello,

My name is Alejandro and I am a primary language teacher. As I needed a template to teach vocabulary to my students, I did a search on the Internet and found a template entitled "Word Bank 2.1"; however, due to my limited technological knowledge, I am unable to translate some sections of the table, such as the items in the drop-down lists.

I would be very grateful if you could tell me how to translate the drop-down list items, as when I try to do it myself, the table does not work properly.

Thank you in advance for your help and I apologise for any inconvenience caused.

Note: I have uploaded both the template and a video demonstrating my problem, but I am not allowed to post links or attach images.

The site will not allow you to post links to anything, however, you can upload a sample workbook here.

It will be almost impossible to just guess what you have, what you are trying to do, and what is going wrong - without seeing a sample sheet.