Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding cell equation from unautherized editing
thanks to you guys, i have some what completed my family budget plan. what i
will like to do is to have certen cells be protected (the formula that gives the results, have the formula be goast). is there a way to goast only the formula and show the results of that cell in the work sheet. if thats possible, would i the creater be able to rework any goast formula within the work sheet? thanks to all you techs out there who gotten me this far from knowing nothing in MS Excel. Colin. |
#2
|
|||
|
|||
Select the cells with the formulas you want to hide. Go to Format -- Cells
-- Protection and check the Hidden box. Now when you protect your worksheet (Tools -- Protection -- Protect Sheet), the formulas will not show, but the results of the formulas will still appear. Note: If you use a password, don't forget to make a note of it so that you will be able to unprotect your worksheet later. To edit the hidden formulas, you will need to first unprotect the worksheet (Tools -- Protection -- Unprotect Sheet). P.S. By default, all cells in the worksheet are locked, so if there are cells you want to edit while the worksheet is protected, you will need to first unlock those cells. To do that, select the cells you want to unlock, then go to Format -- Cells -- Protection, uncheck the Locked box. -- Elisabeth "Colin2u" wrote: thanks to you guys, i have some what completed my family budget plan. what i will like to do is to have certen cells be protected (the formula that gives the results, have the formula be goast). is there a way to goast only the formula and show the results of that cell in the work sheet. if thats possible, would i the creater be able to rework any goast formula within the work sheet? thanks to all you techs out there who gotten me this far from knowing nothing in MS Excel. Colin. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Equation Referencing Row Number Stored in Cell | Excel Discussion (Misc queries) | |||
Hiding cell contents | Excel Discussion (Misc queries) | |||
Hiding a function value in a cell until function used | Excel Worksheet Functions |