View original (French)

Remove red arrows in cells containing formulas

Solved
kylejake -  
 kylejake -

Hello,

In my spreadsheet, I created a column with a dragging formula that serves as a reference for another column.

The formula is long and does not fit in the cell since it doesn't return a result.

Red arrows appear on each side that I would like to see disappear.

This is the first time I've encountered this issue because usually I don't have this problem.

Thank you for your help and advice.

kylejake


1 answer

  1. kylejake
     

    Hello again,

    I just found a solution that I hadn't thought of.

    I simply went to "format / cells / alignment / validated".

    The markings disappeared.

    This might be helpful.

    kylejake

    0