(CALC)...How to obtain: AUTO-EXPND on Insert?

I clk’d: ‘Auto-expnd on insert’ … TOOLS > OPTNS…

To provide an answer more information is needed. Please have a look at What information should I include in a question in addition to OS and LibreOffice version? - #4 by ROSt53