Hide formulas

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Hi, is there a way to hide the formulas in a spreadsheet so they'll only see
the result? thank you
 
Just google for "hide formulas excel"
there are macro solutions and sheet protection solutions
 
Select the cells to be hidden.

Format>Cells>Protection. Checkmark "hidden"........they will be locked also
by default.

Now Tools>Protection>Protect Sheet.

You may want to leave other cells unlocked for editing.

First hit CTRL + A to select all cells.

Unlock these.

Now select the cells to be hidden and locked and do so.

Now protect the sheet.


Gord Dibben MS Excel MVP
 
Just a warning.

Worksheet protection, even with a password, is very weak.

A determined user can find ways to see your formulas.


Gord
 
thank you, this is very helpful :)

Gord Dibben said:
Just a warning.

Worksheet protection, even with a password, is very weak.

A determined user can find ways to see your formulas.


Gord
Click to expand...
 
Back
Top