Oct 09 2020 03:39 AM
Buenos días
Tengo office 365. En algunos excel (todos del mismo origen) no me deja eliminar columnas no contiguas (adecuadamente seleccionadas). La opción de eliminar está en gris claro. Las celdas no están bloqueadas (mirando en configuración de celdas) y si me deja eliminar columnas y filas contiguas. Gracias
Oct 09 2020 04:10 AM
You cannot delete entire non-contiguous columns if they intersect a table.
If you select only the table columns, you will be able to delete them.
Oct 11 2020 04:01 AM
@Hans Vogelaar Thank you for your answer, but I have some doubts
Why do you know with the image I sent that it is intersected by a table? how can I solve that? What do I have to do to convert everything to the same table? In others excel's files I select non-contiguous columns with ctrl + click and delete them without problems.
Thank you
Oct 11 2020 04:40 AM
SolutionThe ribbon has a tab Diseño (under Herramientas de Tabla) - this indicates that the selection intersects a table.
You can convert the table to a normal range as follows:
Click in any cell of the table, for example FJ1.
Activate the Diseño tab.
Click Convertir en Rango.
Alternatively, right-click anywhere in the table, and select Tabla > Convertir en Rango from the context menu.
You can now delete non-contiguous columns.
Oct 11 2020 05:21 AM
Oct 11 2020 04:40 AM
SolutionThe ribbon has a tab Diseño (under Herramientas de Tabla) - this indicates that the selection intersects a table.
You can convert the table to a normal range as follows:
Click in any cell of the table, for example FJ1.
Activate the Diseño tab.
Click Convertir en Rango.
Alternatively, right-click anywhere in the table, and select Tabla > Convertir en Rango from the context menu.
You can now delete non-contiguous columns.