Forum Discussion
No deja eliminar filas no contiguas
The 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.
HansVogelaar 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
The 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.
- Thank yoy very much!! I have to edit 90 files, deletting, in each file, a lot of columns no-contigous. Your help save me so much time.