Home

Excel will now allow me to delete a single cell without deleting the row.

%3CLINGO-SUB%20id%3D%22lingo-sub-743928%22%20slang%3D%22en-US%22%3EExcel%20will%20now%20allow%20me%20to%20delete%20a%20single%20cell%20without%20deleting%20the%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743928%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20some%20reason%2C%20when%20I%20try%20to%20delete%20any%20cell%20it%20will%20delete%20the%20entire%20row%20and%20move%20the%20data%20from%20below%20into%20that%20space.%20Please%20help%20me%20fix%20this.%20I%20cannot%20see%20that%20the%20rows%20are%20grouped%20or%20protected%20and%20everything%20looks%20normal.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-743928%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744418%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20will%20now%20allow%20me%20to%20delete%20a%20single%20cell%20without%20deleting%20the%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744418%22%20slang%3D%22en-US%22%3ECan%20you%20post%20a%20screen-shot%20of%20the%20sorroundings%20of%20the%20cell%20you%20wish%20to%20delete%20and%20tell%20us%20precisely%20how%20you%20do%20the%20deleting%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744453%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20will%20now%20allow%20me%20to%20delete%20a%20single%20cell%20without%20deleting%20the%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744453%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373075%22%20target%3D%22_blank%22%3E%40Amesser%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20delete%20a%20single%20cell%20without%20deleting%20entire%20row%20%2F%20column.%20Please%20see%20attached%20screen%20shot.%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745204%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20will%20now%20allow%20me%20to%20delete%20a%20single%20cell%20without%20deleting%20the%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3EIt%20really%20goes%20for%20any%20cell%20within%20excel.%20I've%20tried%20creating%20a%20new%20spreadsheet%20and%20it%20does%20the%20same%20thing.%20What%20I've%20been%20doing%20is%3A%20home%20tab%2C%20cells%20section%2C%20selecting%20the%20delete%20cells%20button.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745695%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20will%20now%20allow%20me%20to%20delete%20a%20single%20cell%20without%20deleting%20the%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745695%22%20slang%3D%22en-US%22%3EIs%20the%20worksheet%20protected%20or%20does%20it%20contain%20cells%20with%20content%20beneath%20that%20table%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745741%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20will%20now%20allow%20me%20to%20delete%20a%20single%20cell%20without%20deleting%20the%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3EIt%20is%20not%20protected.%20How%20do%20I%20look%20if%20there%20is%20content%20underneath%20the%20table%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Amesser
New Contributor

For some reason, when I try to delete any cell it will delete the entire row and move the data from below into that space. Please help me fix this. I cannot see that the rows are grouped or protected and everything looks normal. 

5 Replies
Can you post a screen-shot of the sorroundings of the cell you wish to delete and tell us precisely how you do the deleting?

Hi @Amesser 

You can delete a single cell without deleting entire row / column. Please see attached screen shot.

Thanks 

Tauqeer

@Jan Karel PieterseIt really goes for any cell within excel. I've tried creating a new spreadsheet and it does the same thing. What I've been doing is: home tab, cells section, selecting the delete cells button. 

Is the worksheet protected or does it contain cells with content beneath that table?

@Jan Karel PieterseIt is not protected. How do I look if there is content underneath the table?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies