Forum Discussion
Irenehl
Nov 23, 2021Copper Contributor
Validación de datos que no admite nombre de tabla
Hola!. Estoy usando una validación de datos para que muestre los valores de una lista. Esta lista la tengo organizada en una tabla con su correspondiente nombre. Al indicar en la validación de datos...
HansVogelaar
Nov 23, 2021MVP
Although the table feature was added to Excel many years ago, you still cannot use a table as source for Data Validation directly. Instead, you have to create a named range that refers to the data body range of the table, and use that named range in the Data Validation rule.
The named range (T_CALENTAMIENTO in the screenshot above) will automatically grow and shrink with the table.