how to hide formula
Mark cells that contain formula, than use comand Format-Format Cells and
choose Protection tab. Tick in checkbox Hidden and close the box with OK.
After than protect sheet using Tool-Protect-Protect sheet (enter password).
After OK hidden cells will not show any result.
--
A.B.
"Narendra Boga" rakstîja:
Hi All.
Could you please tell, how to hide the formulas entere into a cell. That
should be invisible to others who are in shared network, but the result
should visible.
And that should be desplayed on other words instead of the formula.
for example:
A3 cell consists formula =a1+a2;
after entering the formula, in formula bar "=a1+a2" should not display
instead "sum" should display or the formula shold not disply.
please help me.
Narendra
|