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

Answer 1 / 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