Convert to Column Formula option is missing from my menu

Elizabeth Smeller

Hi, I'm the Admin of this sheet, but when I right click on the Formula column, I don't see the option to 'Convert to Column Formula' in the menu. Am I missing something?

Andrée Starå

Hi @Elizabeth Smeller

I hope you're well and safe!

You'll have to right-click on one of the cells in the column instead.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Elizabeth Smeller

I hope you're well and safe!

You'll have to right-click on one of the cells in the column instead.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Elizabeth Smeller

Thank you Andree, that worked! Not sure why I didn't try that first lol! :-)

Andrée Starå

@Elizabeth Smeller

Excellent!

Easy to miss!

You're more than welcome!