Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

How can I protect formulas from being deleted or changed?

MS Excel Interview Question
MS Excel Interview Question

Answer:

Before protecting the worksheet:

1. Select all cells that users ARE allowed to change.
2. On the keyboard, press Ctrl + 1 to open the Format Cells dialog box
3. On the Protection tab, remove the check mark from Locked.
4. Click OK, to close the dialog box

Protect the worksheet in Excel 2007

1. On the Excel Ribbon, click the Review tab
2. Click Protect Sheet.

Protect the worksheet in Excel 2003

1. Click the Tools menu, then click Protection

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How many worksheets I can put in a workbook?Excel Limits and Specifications: