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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies