MS Excel

Hi Fahim

Thanks for your question.

This is fairly simple. You can protect your worksheet. This then stops the user from changing data in any locked cell. By default all cells are locked, so you first need to unlock the cells that the user can change and then protect the worksheet.

Unlocking Cells

Select the cells the user can edit
In the number format combo in the number group (Home tab) select "More Number Formats".
In the resulting dialog box select Protection tab and untick locked.

Protecting the sheet

On the review tab click on "Protect Sheet"
Enter a password to unproptect the sheet, click OK, confirm the password and click OK again.

Your data will then be protected

Regards

Stephen