SOLVED

Cant remove boxes from spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-133382%22%20slang%3D%22en-US%22%3ECant%20remove%20boxes%20from%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133382%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20trying%20to%20delete%20some%20objects%20from%20my%20spreadsheet.%20There%20is%20some%20information%20that%20needs%20to%20be%20on%20a%20spreadsheet%20but%20the%20system%20I%20am%20pulling%20from%20doesn't%20export%20files.%20I've%20been%20working%20around%20this%20by%20using%20copy%20and%20paste%20but%20there%20are%20these%20boxes%20inside%20of%20my%20sheet%20that%20I%20cannot%20delete.%20It%20is%20almost%20like%20cells%20within%20cells%20because%20I%20can%20write%20in%20them.%20Any%20help%20is%20appreciated.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F25010i1354A34C20144138%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Cell%20in%20a%20cell.png%22%20title%3D%22Cell%20in%20a%20cell.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-133382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133387%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20remove%20boxes%20from%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133387%22%20slang%3D%22en-US%22%3E%3CP%3EMgoularte19%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethey%20are%20probably%20objects.%3C%2FP%3E%0A%3CP%3EPress%20F5%2C%20klick%20on%20%22Special...%22%2C%20select%20%22Objects%22%2C%20klick%20on%20%22OK%22.%3C%2FP%3E%0A%3CP%3EThe%20objects%20are%20now%20selected.%3C%2FP%3E%0A%3CP%3EPress%20DEL.%3C%2FP%3E%0A%3CP%3EThe%20objects%20are%20gone.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1855293%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20remove%20boxes%20from%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1855293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3BWorked%20great%2C%20thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have trying to delete some objects from my spreadsheet. There is some information that needs to be on a spreadsheet but the system I am pulling from doesn't export files. I've been working around this by using copy and paste but there are these boxes inside of my sheet that I cannot delete. It is almost like cells within cells because I can write in them. Any help is appreciated. Cell in a cell.png

2 Replies
Highlighted
Best Response confirmed by mgoularte19 (Occasional Visitor)
Solution

Mgoularte19,

 

they are probably objects.

Press F5, klick on "Special...", select "Objects", klick on "OK".

The objects are now selected.

Press DEL.

The objects are gone.

 

Highlighted

@Detlef Lewin Worked great, thank you