default format insert cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1441525%22%20slang%3D%22en-US%22%3Edefault%20format%20insert%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1441525%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20you%20insert%20a%20cell%20(moving%20the%20row%20below%20it%20down)%20it%20automatically%20copies%20the%20formatting%20from%20above.%3C%2FP%3E%3CP%3EYou%20get%20a%20promt%20%2F%20dropdown%20menu%20(insert%20options)%20where%20you%20can%20choose%20either%20formatting%20from%20below%20or%20clear%20formatting.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20set%20the%20default%20to%20clear%20formatting%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20reference%2C%20I'm%20talking%20about%26nbsp%3BFormatting%20options%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finsert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finsert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1441525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445287%22%20slang%3D%22en-US%22%3ERe%3A%20default%20format%20insert%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445287%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689555%22%20target%3D%22_blank%22%3E%40D3NNIZZZ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20doesn't%20allow%20%3CSPAN%3E%26nbsp%3Bset%20the%20default%20to%20clear%20formatting.%20You%20have%20to%20clear%20the%20Formatting%20by%20clicking%20on%20the%26nbsp%3B%3CSTRONG%3EInsert%20options%26nbsp%3B%3C%2FSTRONG%3Eicon%20and%20choose%26nbsp%3B%3CSTRONG%3EClear%20Formatting.%26nbsp%3B%3C%2FSTRONG%3EOr%20you%20can%20use%26nbsp%3B%3CSTRONG%3EClear%20Format%26nbsp%3B%3C%2FSTRONG%3Elocated%20in%20the%26nbsp%3B%3CSTRONG%3EClear%26nbsp%3B%3C%2FSTRONG%3Ebutton%20in%20the%26nbsp%3B%3CSTRONG%3EEditing%26nbsp%3B%3C%2FSTRONG%3Egroup%20of%20the%26nbsp%3B%3CSTRONG%3EHome%26nbsp%3B%3C%2FSTRONG%3Etab%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorAbiola1_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

When you insert a cell (moving the row below it down) it automatically copies the formatting from above.

You get a promt / dropdown menu (insert options) where you can choose either formatting from below or clear formatting.

Is there a way to set the default to clear formatting?

 

For reference, I'm talking about Formatting options in https://support.microsoft.com/en-us/office/insert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d...

1 Reply
Highlighted

Hello@D3NNIZZZ 

 

Excel doesn't allow  set the default to clear formatting. You have to clear the Formatting by clicking on the Insert options icon and choose Clear Formatting. Or you can use Clear Format located in the Clear button in the Editing group of the Home tab