Convert into a formula column

vstr8889

HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column it's greyed out. i've tried with different sheets different cell types it's still greyed out, please help out.

Thanks

Vinoth

Piotr Z.

Hi vstr8889,

In order to convert column into formula column, you need to type in formula into a cell first. When you finish your formula hit enter, right click on the cell you've created your formula in, and you should be able to click on Convert to column formula.

Hope that helps!