deleting and adding rows and columns without affecting format !

%3CLINGO-SUB%20id%3D%22lingo-sub-1600367%22%20slang%3D%22en-US%22%3Edeleting%20and%20adding%20rows%20and%20columns%20without%20affecting%20format%20!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600367%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CBR%20%2F%3Ein%20excel%26nbsp%3B%3CBR%20%2F%3EHow%26nbsp%3Bto%20delete%20or%20add%20rows%20and%20columns%20without%20affecting%20format!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1600367%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601799%22%20slang%3D%22en-US%22%3ERe%3A%20deleting%20and%20adding%20rows%20and%20columns%20without%20affecting%20format%20!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601799%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765219%22%20target%3D%22_blank%22%3E%40alhais02%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20afraid%20you%20will%20have%20to%20elaborate.%20Perhaps%20you%20could%20share%20a%20couple%20of%20screenshots%20that%20detail%20the%20unwanted%20change%20before%20and%20after%20a%20row%2Fcolumn%20is%20added%2Fdeleted.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi 
in excel 
How to delete or add rows and columns without affecting format!

1 Reply

Hello @alhais02,

 

I'm afraid you will have to elaborate. Perhaps you could share a couple of screenshots that detail the unwanted change before and after a row/column is added/deleted.