Maintaining Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I maintain a formula in a cell when the data is cleared? I thought by
creating a templet the problem would be resolved, but I am not having any
luck. Any ideas??
 
not sure what you mean by "when the data is cleared?" The formula will stay
there until it is erased. To keep it from being erased, do a
Format/Protection/Locked, then do a tools/protection/protect sheet
 
Hi,

By default all the cells in Worksheet are locked. Click the cell which has a
formula and unlock it. The procedure for unlocking a cell is as follows;

1. On the Format menu, click Cells. In the Format Cells dialog box, click
the Protection tab and clear the Locked check box and then click OK. This
will help you enter new values in the protected sheet.
2. Select the cell which has the formula and retain the default setting –
Locked in the Protection tab in the Format cells dialog box.
3. On the Tools menu, click Options. The Options dialog box appears. Click
the View tab. Under the Windows option, clear the “Zero values†check box and
click Ok to return to the worksheet.
4. On Tools menu, point to Protection, and then click Protect Sheet. The
Protect Sheet dialog box appears. Select the Worksheet and Content of locked
cells check box. Enter a password in the “Password to Unprotect sheet†text
box. In the “Allow all users of this worksheet to†list, select “Locked
Cells†and “Select Unlocked cell†check boxes, and then OK. In the “Confirm
Password†dialog box, enter the password in the “Reenter password to proceedâ€
text box, Click OK to return to the worksheet.
5. On the File menu, click Save as, and type a file name in the Save As text
box.
6. Open the File again. Enter new values in the unlocked cell, the formula
locked cell automatically displays the computed value.

Challa Prabhu
 
Hi,

By default all the cells in Worksheet are locked.

To creat a protected worksheet using locked and unlocked cells:

1. On the Format menu, click Cells. In the Format Cells dialog box, click
the Protection tab and clear the Locked check box and then click OK. This
will help you enter new values in the protected sheet.
2. Select the cell which has the formula and retain the default setting –
Locked in the Protection tab in the Format cells dialog box.
3. On the Tools menu, click Options. The Options dialog box appears. Click
the View tab. Under the Windows option, clear the “Zero values†check box and
click Ok to return to the worksheet.
4. On Tools menu, point to Protection, and then click Protect Sheet. The
Protect Sheet dialog box appears. Select the Worksheet and Content of locked
cells check box. Enter a password in the “Password to Unprotect sheet†text
box. In the “Allow all users of this worksheet to†list, select “Locked
Cells†and “Select Unlocked cell†check boxes, and then OK. In the “Confirm
Password†dialog box, enter the password in the “Reenter password to proceedâ€
text box, Click OK to return to the worksheet.
5. On the File menu, click Save as, and type a file name in the Save As text
box.
6. Open the File again. Enter new values in the unlocked cell, the formula
locked cell automatically displays the computed value.

Challa Prabhu
 
Back
Top