SOLVED

Validación de datos

%3CLINGO-SUB%20id%3D%22lingo-sub-1766674%22%20slang%3D%22es-ES%22%3EData%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766674%22%20slang%3D%22es-ES%22%3E%3CP%3ECan%20I%20create%20a%20drop-down%20list%20without%20using%20a%20range%20of%20cells%20as%20a%20value%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766674%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766768%22%20slang%3D%22en-US%22%3ERe%3A%20Validaci%C3%B3n%20de%20datos%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827096%22%20target%3D%22_blank%22%3E%40Salvador_2703%3C%2FA%3E%26nbsp%3BYes!%20You%20can%20type%20the%20various%20options%20to%20choose%20from%20in%20the%20%22Source%22%20field.%20Attached%20an%20example.%20Not%20very%20practical%2C%20though%2C%20if%20you%20have%20many.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766774%22%20slang%3D%22es-ES%22%3ERe%3A%20Data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766774%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%2C%20it%20is%20a%20great%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

¿Puedo crear una lista desplegable sin usar un rango de celdas como valor?

3 Replies
Highlighted
Best Response confirmed by Salvador_2703 (New Contributor)
Solution

@Salvador_2703 Yes! You can type the various options to choose from in the "Source" field. Attached an example. Not very practical, though, if you have many.

Highlighted

@Riny_van_Eekelen Thank you very much, it is a great help.

Highlighted

@Salvador_2703 You're welcome!