In a microsoft excel worksheet, is it possible to hide the formulae only?

Question

I would want a situation where if one opens the worksheet they can see the figures, but not the formulae behind the figures. Thank you.

I would want to keep the worksheet as a shared worksheet, where others may be able to work with the entry of data to the cells from where the formulae links.

Answer 1

Right click on the cell that has the formulae,
Select Format Cells,
Choose Protection,
Tick Hide.
now this does not hide the cells until the worksheet is protected
so first, if there are cells where input is required:
Select all the cells that require data input by using mouse and CTRL key,
then follow above for Protection but just Untick Locked.
Finally, choose Tools from the menu, then Protection and Protect sheet, you will be given the chance to give a password or you can leave it blank. (Before adding any other information to your spreadsheet you will have to Unprotect it first)

Answer 2

Put the formulae in a different part of the sheet, or possibly better (but more complicated) - on a different tab...
Hide these formula cells & protect them...

Then in the "normal area" the cells which used to contain formulae just need to refer to the appropriate hidden cell...

Good Luck

Answer 3

Lock the cells, restricted access. Tools and Settings will lead the way.

Key work: HIDE
Save it as a presentation and show that, not the work-sheet

Answer 4

Turn the spreadsheet into a pdf file.