3 symbols appear when left click on black box of cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1503473%22%20slang%3D%22en-US%22%3E3%20symbols%20appear%20when%20left%20click%20on%20black%20box%20of%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503473%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20what%20I%20did%20to%20mess%20up%20cells%20in%20columns%20J%20%2B%20K.%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20cell%20K2.%26nbsp%3B%3C%2FLI%3E%3CLI%3EPointing%20to%20black-box%20at%20the%20lower%20right%20of%20the%20cell%20I%20see%204%20small%20arrows%20-%20pic%201.%3C%2FLI%3E%3CLI%3EI%20expected%20to%20see%20a%20black%20cross%20-%20cell%20L2%20pic%202%20-%20a%20good%20cell.%3C%2FLI%3E%3CLI%3ELeft-clicking%20on%20the%20black-box%20produces%20the%203%20symbols%20linked%20together%20-%20cell%20K2%20pic%203.%20I%20have%20no%20clue%20what%20the%203%20symbols%20mean.%3C%2FLI%3E%3CLI%3EWhat%20caused%20this%20problem%20to%20occur%20in%20cells%20on%20these%20columns%3F%3C%2FLI%3E%3CLI%3EHow%20do%20I%20fix%20the%20cells%20in%20columns%20J%20%2B%20K%20to%20get%20rid%20of%20this%20problem%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3EThe%20following%20attempted%20fixes%20did%20not%20work%3A%3A%3C%2FP%3E%3CUL%3E%3CLI%3Eselecting%20the%20bad%20cells%20and%20clicking%20clear%20contents%3C%2FLI%3E%3CLI%3E%3CSPAN%3Ecopying%20a%20good%20cell%20and%20pasting%20it%20into%20a%20bad%20cell%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Edeleting%20columns%20J%20%2B%20K%20with%20bad%20cells%20-%20this%20moved%20the%20problem%20to%20the%20cells%20in%20column%20I%20(to%20the%20left%20of%20the%20deleted%20columns).%20The%20column%20I%20cells%20were%20ok%20before%20columns%20J%20%2B%20K%20were%20deleted.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EDeleting%20column%20K%20and%20inserting%20a%20new%20column%20to%20replace%20it%20-%20the%20new%20column%20K%20cells%20had%20the%20same%20old%20problem.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EAny%20answers%20to%20how%26nbsp%3BI%20messed%20up%20these%20cells%20and%20how%20to%20fix%20them%20would%20be%20greatly%20appreciated!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

I don't know what I did to mess up cells in columns J + K.

  1. Select cell K2. 
  2. Pointing to black-box at the lower right of the cell I see 4 small arrows - pic 1.
  3. I expected to see a black cross - cell L2 pic 2 - a good cell.
  4. Left-clicking on the cell K2 black-box produces the 3 symbols linked together - cell K2 pic 3. I have no clue what the 3 symbols mean.
  5. What caused this problem to occur in cells on these columns?
  6. How do I fix the cells in columns J + K to get rid of this problem?

The following attempted fixes did not work::

  • selecting the bad cells and clicking clear contents
  • copying a good cell and pasting it into a bad cell
  • deleting columns J + K with bad cells - this moved the problem to the cells in column I (to the left of the deleted columns). The column I cells were ok before columns J + K were deleted.
  • Deleting column K and inserting a new column to replace it - the new column K cells had the same old problem.

Any answers to how I messed up these cells and how to fix them would be greatly appreciated!

 

Thanks

0 Replies