How To Hide Formulas In Excel Sheet

I would like to hide formulas in Excel Sheet without lock the worksheet or workbook.

Please help if anyone can.

Thanks.

How hidden do you want it? You can always copy and paste values after you run the formulas.

Aside from that you could open a tab, write all the formulas on that tab. Open another tab in the same workbook and then have that tab reference the values on the hidden tab. That's not *very* hidden, granted.

Those are what I can think of - someone with a better grasp of excel will probably come along with a better suggestion.

and as asked, how hidden do you want it, another option is to hide the formula bar (View, uncheck formula bar). doesn't really do much, but just wanted to put another option because we don't know what the full purpose is.

Hiding formules you can do this by protection your sheet

also do right click on that cell formatcells and protection and then cekc the box hide
This will hide the formules