Hide formulas
Select the cells to be hidden.
FormatCellsProtection. Checkmark "hidden"........they will be locked also
by default.
Now ToolsProtectionProtect 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
On Mon, 24 Aug 2009 13:34:03 -0700, Heather
wrote:
Hi, is there a way to hide the formulas in a spreadsheet so they'll only see
the result? thank you
|