Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lock formula??
Office 2k, win98se.
Would like to lock formulas in cells but not data that is entered/caculated. Thanks, L. |
#2
|
|||
|
|||
You can select the whole sheet (ctrl + a), do formatcellsprotection, uncheck
locked, click Ok. Now press F5, special, select formulas, click OK. do formatcellsprotection, check locked, click OK. Now protect the sheet Regards, Peo Sjoblom "L/P" wrote: Office 2k, win98se. Would like to lock formulas in cells but not data that is entered/caculated. Thanks, L. |
#3
|
|||
|
|||
Thanks for the info. Seems I have a "problem" with the delete key and
sometimes when I mean to delete contents of a cell I end up deleting the formula's' instead!!! Again, thanks, L. "Peo Sjoblom" wrote in message ... You can select the whole sheet (ctrl + a), do formatcellsprotection, uncheck locked, click Ok. Now press F5, special, select formulas, click OK. do formatcellsprotection, check locked, click OK. Now protect the sheet Regards, Peo Sjoblom "L/P" wrote: Office 2k, win98se. Would like to lock formulas in cells but not data that is entered/caculated. Thanks, L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |