Forum Discussion

Copper Contributor

Oct 31, 2018

Excel Formulas and Copy Down Rows

I just started Windows 2016. I typed in a formula to concatenate tow cells. However, the formula shows up in the cell instead of the results. I know if you click in the cell and hit F9 the results...

excel

Rusty Dane

Brass Contributor

Oct 31, 2018

It sounds like you have auto calc turned off. Go to File, Options, Formulas.

Leslie Girardot

Copper Contributor

Oct 31, 2018

YOU'RE A GODSEND !!! Simple --- though DUUUH How did manage to turn it off ????? Been using for couple months no problem. Did have to extend length of entire spreadsheet then began.

Thanks so much.