It's easy to protect a worksheet in Excel, but it's not so obvious how you leave some of the cells unprotected, so users can make changes to those cells. You can follow this tutorial to learn how to do that, and maybe you'll even see the weird dialog box heading that I show below.

For example, on a data entry sheet, you might have some cells with formulas, that you don't want users to mess up. However, you want the users to be able to enter the date, item name and quantity for an order.

In the screenshot below, the selected cells -- A2:C6 -- should be unprotected, so users can enter data. The rest of the cells should be protected, so the formulas cannot be changed or deleted.

Step 1: Unlock the Data Entry Cells

By default, all the cells on the worksheet will be locked, if

Continue reading Allow Changes on a Protected Worksheet