View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Aivis Aivis is offline
external usenet poster
 
Posts: 18
Default 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