unwanted linked identical cell values in a column

%3CLINGO-SUB%20id%3D%22lingo-sub-1189730%22%20slang%3D%22en-US%22%3Eunwanted%20linked%20identical%20cell%20values%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189730%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20values%20of%203%20adjoining%20vertical%20cells%20in%20each%20column%20are%20inexplicably%20linked%20together.%20A%20thin%20blue%20line%20is%20noted%20around%20the%20three%20cells.%20When%20I%20try%20to%20delete%20the%20%22greyed%20out%22%20formula%20in%20the%20two%20lower%20adjoining%20cells%2C%20I%20am%20unable%20to%20do%20so.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1189730%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1189788%22%20slang%3D%22en-US%22%3ERe%3A%20unwanted%20linked%20identical%20cell%20values%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189788%22%20slang%3D%22en-US%22%3EHello%2C%20can%20you%20post%20a%20picture%20of%20what%20you%20imply%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1189871%22%20slang%3D%22en-US%22%3ERe%3A%20unwanted%20linked%20identical%20cell%20values%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566192%22%20target%3D%22_blank%22%3E%40Ron20202130%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20Spill.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20here%20for%20more%20details%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1189899%22%20slang%3D%22en-US%22%3ERe%3A%20unwanted%20linked%20identical%20cell%20values%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189899%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

The values of 3 adjoining vertical cells in each column are inexplicably linked together. A thin blue line is noted around the three cells. When I try to delete the "greyed out" formula in the two lower adjoining cells, I am unable to do so. Any ideas?

2 Replies
Highlighted
Thank you so much.