Versions Compared

Version Old Version 35 New Version 36
Changes made by

Daniel LaGrow

Daniel LaGrow

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Highlight the input cells, right click, and select Format Cells.

    A restaurant complaint form.Image RemovedA restaurant complaint form.Image Added

  2. In the dialog box, click the Protection Tab and un-check the Locked Option. Click OK.

    Format Cells Dialog box with the Protection Tab open. The Locked option is unchecked.

  3. Go to the Review Tab of the ribbon. Select Protect Sheet.

    Review Tab in ExcelThe Protect Section in MS Excel. Protect Sheet is all the way to the left.

  4. In the Protection Sheet Dialog Box, make sure “Select Locked Cells” and “Select Unlocked Cells” are checked. Everything else can be unchecked. Click OK.

    Protect Sheet dialog box with select locked cells and select unlocked cells checked.

  5. Optional: You can create a password.

  6. Now with your spreadsheet saved, a user will only be able to make changes to the input fields. If they tried to make changes, an alert message will appear.

...