I want to be able to hide my formulas from being viewed when you hover over the cell.

kat_cramer0

I have a sheet that has a lot of complex formulas and is used (and edited) by many users. When the users are referencing the sheet, the formulas show up and get in the way of reviewing the data. Is there a way I can hide the formulas from popping up when others are using this sheet to edit?

All of the columns with the complex formulas are locked.

Paul Newcome

There is no way to hide them directly within the sheet. The best you can do is instruct users not to select or hover over a cell containing a formula.

If you use a report, it will only show "fx" which is much less intrusive than the full formula. Dynamic View also does not show the formula.

kat_cramer0

Thank you!

Paul Newcome

Happy to help. 👍️