Versions Compared

Version Old Version 25 New Version 26
Changes made by

Daniel LaGrow

Daniel LaGrow

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printablefalse

\uD83D\uDCD8 InstructionsInstructions

Section 6.1: Creating Forms

...

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

    A restaurant complaint form.

  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.

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@82d
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "AN"