Unable to delete/clear contents of cell

AmandaT

The option to 'clear contents' is grayed out for all cells in of one of my columns that uses a v-lookup formula. All the other columns/cells I'm able to just click 'delete' or right-click 'clear contents'. Is there something that blocks being able to delete/clear contents of a cell with a formula?

Andrée Starå

Hi @AmandaT

I hope you're well and safe!

Make sure that it's not a Column Formula. If it is, you'd need to convert it back to Cell Formulas instead.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

Andrée Starå

@AmandaT

Excellent!

Have you looked into keeping it as it is but adding an IFERROR function so it would show as empty or something else when there's no match?

Make sense?

Andrée Starå

Hi @AmandaT

I hope you're well and safe!

Make sure that it's not a Column Formula. If it is, you'd need to convert it back to Cell Formulas instead.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

AmandaT

Awesome! That works! Any way to do a mass change back to cell formula? I have 1900 cells out of 2300 in the column that need to be deleted. Unless there is a totally different way I can do this. I did a v-lookup and need to get rid of the 'no matches'

Andrée Starå

@AmandaT

Excellent!

Have you looked into keeping it as it is but adding an IFERROR function so it would show as empty or something else when there's no match?

Make sense?

AmandaT

Got it! I hadn't used the IFERROR before; learned something new today. Thanks!

Andrée Starå

@AmandaT

You're more than welcome!