Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hide formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hide formula
You could use Tools/ Protection, and protect the sheet, not allowing users
to select locked cells. Format Cells/ Protection will allow you to set which cells are locked. This protection isn't very secure, as Excel passwords can easily be cracked, so if you really don't want the formula visible, don't put it in Excel. -- David Biddulph "Narendra Boga" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hide formula
Hi,
By default all the cells in worksheet are locked. Do the following: 1. Select the formula do the following: Formula-Cells-Protection and select Lock and Hidden check boxes. The formula cannot be viewed in the formula bar only when you protect the document. 2. Select the values above the formula and do the following: Formula-Cells-Protection and unselect Lock checkbox. The will help you enter new values in the protected document. Otherwise, all the cell will be locked an you cannot any new values. Challa Prabhu "Narendra Boga" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hide formula
Thanq very much for your instant reply..
here the whole sheet is prected from the editing the sheet. I need to allow edit to others such as entering the data into another rows and columns. The only thing is the calculated formula shuld not visible to others. The calculated formula is secreat to others. plese give suggestion..... "Aivis" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to hide formula
unprotect the cells which you want the to be able to modify before you
protect the sheet "Narendra Boga" wrote: Thanq very much for your instant reply.. here the whole sheet is prected from the editing the sheet. I need to allow edit to others such as entering the data into another rows and columns. The only thing is the calculated formula shuld not visible to others. The calculated formula is secreat to others. plese give suggestion..... "Aivis" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if/hide formula | Excel Worksheet Functions | |||
formula to hide row | Excel Worksheet Functions | |||
Formula won't hide | Excel Discussion (Misc queries) | |||
how to hide the formula | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions |