3 symbols appear when left click on black box of cell

Copper Contributor

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