SOLVED

No deja eliminar filas no contiguas

%3CLINGO-SUB%20id%3D%22lingo-sub-1763366%22%20slang%3D%22es-ES%22%3EDoesn't%20let%20un%20contiguous%20rows%20be%20deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763366%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20have%20office%20365.%20In%20some%20excel%20(all%20from%20the%20same%20source)%20it%20does%20not%20let%20me%20delete%20non-contiguous%20(properly%20selected)%20columns.%20The%20delete%20option%20is%20in%20light%20gray.%20The%20cells%20are%20not%20locked%20(looking%20at%20cell%20settings)%20and%20if%20you%20let%20me%20delete%20contiguous%20columns%20and%20rows.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1763366%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1763545%22%20slang%3D%22en-US%22%3ERe%3A%20No%20deja%20eliminar%20filas%20no%20contiguas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826145%22%20target%3D%22_blank%22%3E%40GemaMM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20cannot%20delete%20entire%20non-contiguous%20columns%20if%20they%20intersect%20a%20table.%3C%2FP%3E%0A%3CP%3EIf%20you%20select%20only%20the%20table%20columns%2C%20you%20will%20be%20able%20to%20delete%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1768662%22%20slang%3D%22es-ES%22%3ERe%3A%20Doesn't%20let%20un%20contiguous%20rows%20be%20deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768662%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20answer%2C%20but%20I%20have%20some%20doubts%3C%2FP%3E%3CP%3EWhy%20do%20you%20know%20with%20the%20image%20I%20sent%20that%20it%20is%20intersected%20by%20a%20table%3F%20how%20can%20I%20solve%20that%3FWhat%20do%20I%20have%20to%20do%20to%20convert%20everything%20to%20the%20same%20table%3F%20In%20others%20excel's%20files%20I%20select%20non-contiguous%20columns%20with%20ctrl%20%2B%20click%20and%20delete%20them%20without%20problems.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

4 Replies
Highlighted

@GemaMM 

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.

Highlighted

@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

Highlighted
Best Response confirmed by GemaMM (New Contributor)
Solution

@GemaMM 

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.

Highlighted
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.