SOLVED

no se copian listas desplegables en fila nueva de tabla

%3CLINGO-SUB%20id%3D%22lingo-sub-902530%22%20slang%3D%22es-ES%22%3Edrop-down%20lists%20are%20not%20copied%20into%20new%20table%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902530%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20a%20table%20to%20which%20I%20add%20records%20as%20documents%20are%20created%2C%20when%20I%20add%20a%20new%20row%2C%20the%20validation%20n%20drop-down%20lists%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-902530%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-906726%22%20slang%3D%22en-US%22%3ERe%3A%20no%20se%20copian%20listas%20desplegables%20en%20fila%20nueva%20de%20tabla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-906726%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423001%22%20target%3D%22_blank%22%3E%40mgottero%3C%2FA%3E%26nbsp%3BHere's%20a%20trick%20for%20extending%20data%20validation%20in%20tables%3A%20go%20to%20the%20last%20cell%20in%20the%20table%20range%20and%20press%20Tab.%20This%20will%20also%20add%20a%20new%20row%20if%20you%20have%20a%20Total%20Row%20turned%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Tengo una tabla a la cual voy agregando registros a medida que se crean documentos, cuando agrego una nueva fila, las listas desplegables de validación n

1 Reply
Highlighted
Solution

@mgottero Here's a trick for extending data validation in tables: go to the last cell in the table range and press Tab. This will also add a new row if you have a Total Row turned on.